There's a bug in the Firebird SQL Driver. See this forum thread for how to get a standalone Java reproducible case which demonstrates the bug: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10&threadid=609902
-----Original Message----- From: Mark Woods [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 5:22 AM To: CF-Linux Subject: Firebird DB and CFMX 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
