Subject FBWrappingDataSource Blocking Timeout
Author Rick Fincher
Post date 2002-07-09T20:37:49Z
Hi All,
 
What is the blocking timeout in FBWrappingDataSource?
 
I'm using Firebird and the level 4 JDBC driver with Tomcat and it works initially, but fails after a period of time with errors like "java.lang.IllegalStateException: Can't destroy managed connection  with active transaction" and null exceptions when making requests for a connection to the database.
 
I suspect that it has something to do with timeout settings or the maximum number of connections.
 
Also, Tomcat uses the database for user authentication with FBDriver and my web apps use FBWrappingDataSource for the pooling capability.  Could there be some problem with using those simultaneously?
 
The full error message is below.
 
Thanks,
 
Rick

 
java.lang.IllegalStateException: Can't destroy managed connection  with active
transaction
        at
org.firebirdsql.jca.FBManagedConnection.destroy(FBManagedConnection.java:336)
        at
org.firebirdsql.jca.ManagedConnectionPool.doDestroy(ManagedConnectionPool.java:2
53)
        at
org.firebirdsql.jca.ManagedConnectionPool.removeTimedOut(ManagedConnectionPool.j
ava:181)
        at org.firebirdsql.jca.IdleRemover$1.run(IdleRemover.java:89)
        at java.lang.Thread.run(Thread.java:484)
getting new fbwds connection failed! Error: java.sql.SQLException: Problem
getting connection: javax.resource.ResourceExcep
tion: No ManagedConnections Available!