CF6.1 to CF7 ... second query fails

Hi

We are developing a Rich Internet App - http://www.lets-eat.co.nz

Our current working setup in on a shared server running CF6.1 and IIS.

We are testing CF7 running under Apache2 all on a WindowsXP Professional machine (we're going to a dedicated server).

We have a problem when one first opens the browser, that on the initial (or second) database call, the query always fails. If you refresh the page, or in Firefox, close the tab, then open the page again. It all works.

The query fails - nothing gets to the database. The database side of the application is locked up.

In the Flash IDE I get this (on first compile ):

Error opening URL "http://www.lets-eat.co.nz/flashservices/gateway;jsessionid=3c3067ac01bc$BDW0f$1"

then if I compile again, it works.

However:

CF6.1 + IIS - this works (ie everything)
CF7 + JRUN - this works (ie everything)
CF7 + Apache - this doesn't work
CF7 + IIS - this doesn't work

So this feels like CF not knowing the correct session initially, and it has to create the correct session. Then when it creates the session, and the session is still alive, everything works.

I've tried most of the session settings in CF7 admin ie Enable Session variables etc... everything is currently set to default. Nothing I changed make any difference.

Can't find any errors in CF logs, nor Database logs.

Any suggesions?

Regards

Dave.

At first glance I'm pretty sure this is not a valid URL:

http://www.lets-eat.co.nz/flashservices/gateway;jsessionid=3c3067ac01bc$BDW0f$1

Shouldn't it be something like:

http://www.lets-eat.co.nz/flashservices/gateway/index.cfm?jsessionid=3c3067ac01bc$BDW0f$1

Yes - that does look weird.. will have a look into it.

Cheers

Dave.

Hi

We have nailed the issue down to:

If you use Apache or IIS (but not JRUN) with CF7, and you call a swf from a wrapper swf, the second swf's remoting doesn't work.

We have a zip file of the test code, including source, and a sample access db on:

http://www.nqb8r.co.nz/testCF7.zip

create a datasource for your mdb called: lets-eatconz
change the www.lets-eat.co.nz to the IP address of your test server

Point your browser to wrapper.swf, and press the big red button. If 3 rows of data pop up it works. Be careful to clear you cache, and all cookies before doing this.

Regards

Dave.
dave AT nqb8r.co.nz

Solution in:

http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=138&threadid=961362&enterthread=y

Dave