Hi,
I'm getting this error several times in a day, it happens in all httpSSLWorkerThread-8080 threads and i have to reset the application, the application server is SJSAS 9.1. This is one example:
[#|2009-01-19T18:40:58.454-0300|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=32;_ThreadName=httpSSLWorkerThread-8080-41;_RequestID=82b30543-b1b4-4347-886d-62d205190cb3;|RAR7093 : Error while cleaning up ManagedConnection
javax.resource.ResourceException: This Managed Connection is not valid as the phyiscal connection is not usable
at com.sun.gjc.spi.ManagedConnection.checkIfValid(ManagedConnection.java:627)
at com.sun.gjc.spi.ManagedConnection.cleanup(ManagedConnection.java:233)
at com.sun.enterprise.resource.AbstractConnectorAllocator.cleanup(AbstractConnectorAllocator.java:145)
at com.sun.enterprise.resource.PoolManagerImpl.putbackResourceToPool(PoolManagerImpl.java:448)
at com.sun.enterprise.resource.PoolManagerImpl.resourceErrorOccurred(PoolManagerImpl.java:411)
at com.sun.enterprise.resource.LocalTxConnectionEventListener.connectionErrorOccurred(LocalTxConnectionEventListener.java:78)
at com.sun.gjc.spi.ManagedConnection.connectionErrorOccurred(ManagedConnection.java:677)
at com.sun.gjc.spi.ManagedConnectionFactory.getInvalidConnections(ManagedConnectionFactory.java:259)
at com.sun.enterprise.resource.AbstractConnectorAllocator.getInvalidConnections(AbstractConnectorAllocator.java:99)
at com.sun.enterprise.resource.AbstractConnectorAllocator.isConnectionValid(AbstractConnectorAllocator.java:111)
at com.sun.enterprise.resource.AbstractResourcePool.isConnectionValid(AbstractResourcePool.java:701)
at com.sun.enterprise.resource.AbstractResourcePool.getUnenlistedResource(AbstractResourcePool.java:653)
at com.sun.enterprise.resource.AbstractResourcePool.internalGetResource(AbstractResourcePool.java:594)
at com.sun.enterprise.resource.AbstractResourcePool.getResource(AbstractResourcePool.java:443)
at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:248)
at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:176)
at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:327)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:158)
at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:108)
The connection pool settings are:
<jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="table" datasource-classname="oracle.jdbc.pool.OracleConnectionPoolDataSource" fail-all-connections="true" idle-timeout-in-seconds="30" is-connection-validation-required="true" is-isolation-level-guaranteed="false" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="50" max-pool-size="32" max-wait-time-in-millis="3000" name="turnosPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="3" validate-atmost-once-period-in-seconds="0" validation-table-name="dual" wrap-jdbc-objects="true">
Any ideas?
Thanks in advance.
Pablo
[Message sent by forum member 'pablo_k75' (pablo_k75)]
http://forums.java.net/jive/thread.jspa?messageID=327374