Event Handlers & Remote Methods

03/04/2010 | ORM, ColdFusion | 21 Comments

Working on a project today I came across a strange issue so I thought I would get everyones opinion on it. I am not really sure if its something I am doing wrong, a bug or maybe I am just missing something. In this application I have event handling turned on. this.ormenabled = "true"; this.datasource = "*********"; this.ormsettings = { cfclocation = "models", eventhandling = true, eventhandler = "cfc.com.*******.********.events.eventHandler", dbcreate = "dropcreate", sqlscript = "install/derby.sql" };

So for nothing special and up until this point everything has been working fine. Today I am adding some ajax via everyone's favorite framework (jQuery of course) and I came across something. This is my ajax call to my remote method. $.ajax({ url: "services/User.cfc", data: {method:"getByRole",role:roleid,returnformat:"json"}, success: function(data){ console.log(data); } }); And my remote method that does a join to pull all users who have a role id equal to the argument passed. remote any function getByRole(Numeric role){ var users = ormExecuteQuery("select u from User as u inner join u.roles as r where r.roleid = ?",[arguments.role]); return users; }

If you were to turn event handling off this works fine but with it on I am seeing the following error.

coldfusion.runtime.TemplateProxy$InvalidRemoteAccessException: The method 'preLoad' in component D:\websites\extranetsteriscom\cfc\com\*****\*****\events\EventHandler.cfc cannot be accessed remotely.

Now in my event handler I have preLoad defined (because you have to when you implement another component) but it's not doing anything. Am I to believe that If I use event handling in my application I can't use ORM for any remote functions? I can certainly get down and write some sql but thats no fun :) Anyways, just thought I would share this and get your thoughts.

This entry was posted on March 4, 2010 at 12:01 PM and has received 2281 views. Comments 21 | Print this entry. Download attachment.

TweetBacks

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

[Add Comment] [Subscribe to Comments]

#1 by Raymond Camden on 3/4/10 - 11:13 AM

Is User.cfc a service component or the actual entity?
#2 by Dan Vega on 3/4/10 - 11:17 AM

It is a service component
#3 by Raymond Camden on 3/4/10 - 11:19 AM

Wow. Now that to me is a bug, plain and simple. Of course, its trivial enough to get around, but still.
#4 by Sam Farmer on 3/4/10 - 11:21 AM

I'd be interested in others thoughts on this but I also came across this situation and to resolve it set all the functions in my event handler to remote. It did feel a little weird doing that at first but then there's not much you could if you hit an event handler directly and that also assumes someone guessing or working out where it is. And if that really is a problem you can always put it under webroot.

Also, I think if you made the call through a framework or via a cfm file, rather than direct to User.cfc, then I don't think it would be a problem.
#5 by Dan Vega on 3/4/10 - 11:29 AM

I thought so as well. Ray and I were talking and came up with this. Your event handler has to implement IEventHandler so it should have to follow the method signatures of the interface. You could always go in and change those methods to remote. I may give that a try to see if that works.
#6 by Dan Vega on 3/4/10 - 11:31 AM

@Sam - Were you able to change the event methods access to remote? I thought because you are implementing IEventHandler that your component methods had to follow the same signatures?
#7 by Sam Farmer on 3/4/10 - 11:38 AM

@Dan, yeah I changed it with no problems. Just need to ormReload() afterwards ;)
#8 by Dan Vega on 3/4/10 - 11:39 AM

Maybe that is another bug then :) Shouldn't you have to follow the methods access in the interface?
#9 by Raymond Camden on 3/4/10 - 11:47 AM

@Dan: Maybe not. Maybe it is just the return type and argument signature.
#10 by Ben Nadel on 3/4/10 - 11:48 AM

That looks like a bug to me. Maybe. Maybe ColdFusion cannot have mixed-mode access on a CFC. I guess it depends on how the "remote" wiring is happening. When CF instantiates a CFC and invokes the method remotely, perhaps it is ensuring that all calls to that CFC are made remotely as a security precaution??
#11 by Sam Farmer on 3/4/10 - 11:55 AM

I don't think so based on my reading of the cfinterface tag:
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef...

Scroll down to Interface requirements
#12 by Sam Farmer on 3/4/10 - 11:56 AM

Reading the docs it doesn't look like a bug to me:

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef...

Scroll down to Implementation Requirements
#13 by Sam Farmer on 3/4/10 - 11:58 AM

Reading the docs it doesn't look like a bug to me:

Go to CFML Ref > cfinterface

Scroll down to Implementation Requirements
#14 by Raymond Camden on 3/4/10 - 12:00 PM

To be clear Sam, when you say not a bug, you mean "my implementation uses remote for function x where the interface uses public for x". You are NOT saying that the _core_ issue of this blog entry isn't a bug (um, please pardon the double negatives and read what I mean, not what I say. ;)
#15 by Sam Farmer on 3/4/10 - 12:09 PM

@Ray: Yes, I was referring to the implementation of interfaces and not the main blog entry.

Also sorry about the multiple comment posting. It wasn't showing up at first and I thought that was due to the link.
#16 by Terrence Ryan on 3/4/10 - 12:34 PM

I just ran into this issue too. Even weirder, if you set the methods for the eventHandler to be remote, it will work.

Discovered it all yesterday. Haven't had time to figure out if it is bugs or what.
#17 by Dan Vega on 3/4/10 - 12:57 PM

I did the same after Sam pointed that out. Works fine for the methods that are not doing anything. I will have to test it out on a method that actually does something, like postUpdate().
#18 by Rupesh Kumar on 3/5/10 - 7:28 AM

Guys, I really need a repro case for this. This looks like a serious bug to me but I am unable to reproduce it at my end. I tried invoking the CFC service method from flex client as well as ajax client and I am unable to see the error that you see. Since many of you are seeing this, I am sure I am missing something.
#19 by Dan Vega on 3/5/10 - 8:57 AM

I have attached a quick demo I worked up this morning. The demo uses the cfbookclub datasource that ships with ColdFusion. If you run the index you should see the author loaded and dumped to the screen. If you go to the ajax.cfm template and check firebug you should see the error I was getting. Now go to the event handler and change the pre load and post load functions to remote. Now to reload the application and have those changes take just append ?reload=true to the url. Now if you try and run ajax.cfm everything should work just fine.

Can anyone let me know if they are seeing the same issues as me? Rupesh said he tried it from an Ajax + Flex client and was not seeing the same results.
#20 by Raymond Camden on 3/5/10 - 9:21 AM

I can confirm I get this error and the fix.
#21 by Dan Vega on 3/9/10 - 7:51 AM

FYI - I logged this as bug #82360. I was notified but Adobe that this bug was fixed and we should see the fix implemented in 9.0.1

[Add Comment] [Subscribe to Comments]

Navigation

Search

Tags

Archives by Subject

Subscribe

Recent Comments

Blog Roll

Event Handlers & Remote Methods

TweetBacks

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)