Hi, Has anyone got Firebird working with CFMX? I've Firebird installed on Linux with CFMX 6.1 and am using the latest JDBC driver downloaded from the Firebird site. I'm finding that SQL queries executed using cfquery that create database objects or insert data "hang"...
I have a simple test script which is roughly this: <cfoutput>test string</cfoutput> <cfflush> <cfquery ...>insert into...</cfquery> <cfoutput>test string2</cfoutput> <cfflush> <cfquery ...>select from...</cfquery> <cfdump var=#selectQuery#> The first test string is always output, and the insert statement succeeds in that the data does get into the database, but once the data has been inserted processing stops and nothing else gets sent back in the http response and the server doesn't close the connection. If I remove the cfflush tags, the server will eventually respond with a "503 Server Error" and a message saying the server encountered an internal error and JRun closed the connection. I have tried setting the timeout attribute for cfquery to a few seconds, but the server still fails to respond even with a query timeout error. SELECT statements are fine, processing continues after the closing cfquery tag as expected - if I remove the insert query from the test template, it runs fine. Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:14 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:14 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
