Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Connection Pool Dirty Connection? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection Pool Dirty Connection?" Watch "Connection Pool Dirty Connection?" New topic

Connection Pool Dirty Connection?

Dominik Ratajski

Joined: Feb 09, 2004
Posts: 14
I'm coming across a problem where an exception is raised after server based connection pool connection has the setAutoCommit(false) method run:

03/Jul/2004:10:15:56] SEVERE ( 8864): RAR5040:Cannot get local connection
com.sun.enterprise.resource.PoolingException: I/O Error: Got minus one from a read call.
at com.sun.enterprise.resource.JdbcUrlAllocator.createResource(
at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(
at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(
at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(
at com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.getCurrentConnection(
at com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.setAutoCommit(

is there anyway a connection can be passed back to the pool in a dirty state? for instance prior to a commit/rollback.

any ideas what a "minus one from read call" means?

also - does the setAutoCommit() method communicate in anyway with the backend database? so for instance, could this error be as a result of a connection that is "valid" to the server connection pool, but say a network error causes the exception when the setAutoCommit() communication occurs.

i can't reproduce this error. it's on Sun ONE AS 7.0 and i'll post this in that forum also.

any ideas appreciated. cheers.
I agree. Here's the link:
subject: Connection Pool Dirty Connection?
It's not a secret anymore!