File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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?
jQuery in Action, 3rd edition