any thoughts or suggestions? i can setup tomcat/railo and add a datasource just fine locally without using stax (see my latest post). obviously, i want this to work with stax.
fyi - this is the only error i get when trying to add a datasource =…
spike -
can you see any problem with the way I'm setting up railo? see my previous entry, i outlined my steps 1-6
there's gotta be a problem with my stax/railo setup because i just downloaded railo express…
If you can connect with a mysql client, then that implies something is wonky with Railo or the way it's setup. You'll need to track down the underlying Railo error (maybe in its logs??) to see if you can figure out what error it is…
When I try to "verify a datasource" using Railo's web administrator (http://localhost:8080/railo-context/admin/web.cfm), two possible values come back for a datasource - OK or Error.
I get Error. That's it. No explanation. Just…
The free Stax database service isn't locked down from remote access so there shouldn't be any problem connecting from your local machine (most users connect this way).
Couple questions to help figure this out:
- What error do you get when…
Checking to see if Spike (or someone else) has any ideas on this one:
My application - Railo on top of Java on top of Tomcat - can access my datasources just fine WHEN in the production environment (in the Stax cloud) but no such luck locally…
that makes perfect sense, spike. i had a feeling you'd have some insight into this. i was making this config change using the Railo admin on the deployed instance in the cloud. i'll make the change locally and redeploy.
thanks again,…
if memory serves, Railo writes its config files to the WEB-INF folder. Are you using the Railo admin on the deployed instance in the cloud? or are you using the Railo admin locally, and then deploying your application with the modified…
It's funny, I now see that the original thread reported the same issue with it working locally, but not remotely. I'm still puzzled at why that would be the case.
Doh! I actually posted the article he was quoting while back, but I didn't realize this was the cause of your problem.
Didn't you say this was working locally but failing remotely? If so, that doesn't seem to full explain your…
Here is the answer to my problem if anyone is interested (thank you google and the guy that was kind enough to post this for everyone). The problem had to do with the behavior of the MySQL JDBC driver as it relates to column aliases...
The solution…
Hi Jeremy,
Off the top of my head I'd guess that deployment-specific issues could be related to assumptions about local filesystem access or making non-HTTP connections to the Flex gateway. I checked out your app and it seemed to be working…