Problem: The connection between ColdFusionMX and Firebird "hangs"
intermittently. The occurrence has increased to 4 times in the past
10 days. When it hangs, CFMX displays this error to all users on
their next database access:

"Error Executing Database Query.ResourceException:
org.firebirdsql.jca.FBResourceException: local transaction active:
can't begin another Reason: local transaction active: can't begin
another. The specific sequence of files included or processed is:
D:\www\cfprojects\myCFMXfile.cfm"

To clear the error, the ColdFusion service must be stopped and
restarted. During the period the system is "hung", Firebird database
server works fine. All of the client/server systems (Delphi/IBO) are
fully functional. Oddly enough, the ColdFusionMX Administrator's
function to "verify" datasources works fine and they all pass! But,
none of the CFMX application work.

Platform: Win2000, IIS, CFMX 6.1 all running on same computer. All
have current updates, patches, and necessary hot fixes. Firebird 1.0
on dedicated server that has worked flawlessly for nearly 2 years
without changes. JDBC driver is Jaybird 1.01 that has the fix for
CFMX insert and update problem that Roman sent me. I called it V1.01b.

History: The Intranet applications ran fine under CF4.5 <--> ODBC <--

> Firebird for nearly 2 years. We upgraded to CFMX 6.1 and the

Jaybird JDBC about 8 weeks ago. I encountered this problem about 3
times in the first 6 weeks, now it seems to be occurring more often.

Log File: The CFMX application log shows the following sequence
(shown in chronological order instead of reverse chron. order as in
log file). The first entry is the culprit:

Jun 1, 2004 8:20 AM Error 0 TAS

"Error Executing Database Query.ResourceException:
org.firebirdsql.jca.FBResourceException: Error reading data from the
connection. null Reason: Error reading data from the connection.
null. The specific sequence of files included or processed is:
D:\www\cfprojects\myCFMXfile.cfm"

Jun 1, 2004 8:21 AM Error 0 TAS

"Error Executing Database Query.ResourceException:
org.firebirdsql.jca.FBResourceException: local transaction active:
can't begin another Reason: local transaction active: can't begin
another. The specific sequence of files included or processed is:
D:\www\cfprojects\allOtherCFMXfiles.cfm" (This error repeated in log
file for each subsequent access request)


Summary: The problem always starts with "Error reading from
connection. null", but happens with different cfm applications that
have not changed in a long time. Then all users get the "local
transaction active, can't begin another" error until CFMX service is
restarted. The applications don't handle transactions explicitly
(using <cftransaction>) but instead rely on the default implicit
transaction.

CFMX administrator datasources are set to "maintain connections" but
there is no limit set on the number of connections allowed, so the
hotfix at
http://www.macromedia.com/support/coldfusion/ts/documents/conn_pool_ho
tfix.htm does not seem necessary.
Anybody encountered this? Thanks for your help.