Subject Unable to Update, Insert, Delete
Author gstratfo
I'm running Cold Fusion MX that uses JDBC to connect to a Firebird
1.0 database. CFMX reports that the connection is fine. I can even
perform SELECT queries with not problem.

I can NOT, however, perform an UPDATE, INSERT, or DELETE query
properly. The CFMX log reports:

"Error Executing Database Query.GDS Exception. invalid request handle"

and Cold Fusion doesn't continue processing the page. Eventually the
webserver times out.

Oddly enough, the query actually does what it is supposed to. The
UPDATE, INSERT, or DELETE works.

Accessing the Firebird database directly (i.e. not using JDBC) works
perfectly.

Does anyone have an idea what is causing this? If I can't get it
fixed it will cause serious problems for my project.

Thanks,

Graham