File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "Connection Pool Dirty Connection?" Watch "Connection Pool Dirty Connection?" New topic
Author

Connection Pool Dirty Connection?

Dominik Ratajski
Greenhorn

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(JdbcUrlAllocator.java:100)
at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNonSharedResourcePool.java:742)
at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedResourcePool.java:520)
at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:263)
at com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.getCurrentConnection(JdbcXAConnection.java:637)
at com.sun.enterprise.resource.JdbcXAConnection$JdbcConnection.setAutoCommit(JdbcXAConnection.java:402)
at com.aramco.gps.dao.ConnectionManager.getConnection(ConnectionManager.java:46)

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.
 
wood burning stoves
 
subject: Connection Pool Dirty Connection?
 
Similar Threads
getting multiple connection in one method problem and poll parameters
Connection Pool Dirty Connection?
Struts DB pooling from 1.0.2 to 1.1
Database Connection Pool Not Releasing Connection to pool
java.sql.SQLException: Io exception: Got minus one from a read call