Hi Graham,

I am having the same problem. I noticed that you posted to the
Macromedia forums about this since your message here, and you now
know that is a confirmed bug in Coldfusion MX.

I am not as convinced as Steven Erat (Serat) that it is just a
conflict with FB JDBC driver as a couple of other people using other
DB's and corresponding JDBC drivers are having the same problem with
the same symptoms. However, these people haven't really used the
forum to the fullest to let MM know it is also a problem for them...
I am not going to rally everyone together to make a stand, I'd like
to think that am not a trouble maker!

Have you tried the kludgy fix I suggested, and did it work for you? I
could email you my "patched" version of cfusion.jar if it would be
helpful?

Jonathan Handford

--- In Firebird-Java@yahoogroups.com, "gstratfo" <gstratford@d...>
wrote:

> 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