5:54 a.m.
Hello,
our customer encoutered this issue while they do some normal operations on web
application. The exception is:
08:30:45,435 WARN [LocalManagedConnectionFactory] Destroying connection that is not
valid, due to the following exception: oracle.jdbc.driver.T4CConnection@1545e24
java.sql.SQLException: pingDatabase failed status=-1
at
org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:72)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:435)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:200)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
...........................................................................................................
08:30:45,440 WARN [TxConnectionManager] Connection error occured:
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@13115ab[state=NORMAL
mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1f0bf67 handles=0
lastUse=1229578757037 permit=false trackByTx=false
mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@a63987
context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@10aed2c
xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@59071d
txSync=null]
java.sql.SQLException: pingDatabase failed status=-1
at
org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:72)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:435)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:200)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:209)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
...........................................................................................................
08:30:45,443 WARN [JBossManagedConnectionPool] Destroying connection that could not be
successfully matched:
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@13115ab[state=DESTROYED
mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1f0bf67 handles=0
lastUse=1229578757037 permit=false trackByTx=false
mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@a63987
context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@10aed2c
xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@59071d
txSync=null]
my *-ds.xml is:
<?xml version="1.0" encoding="UTF-8" ?>
-
- <local-tx-datasource>
<jndi-name>jdbc/mvpdm</jndi-name>
<connection-url>jdbc:oracle:thin:@stddsdb1:3302:DDS</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>mcf</user-name>
mcf01
- <!-- This checks the connections are good before handing them out
-->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<min-pool-size>1</min-pool-size>
<max-pool-size>10</max-pool-size>
-
<type-mapping>Oracle9i</type-mapping>
</local-tx-datasource>
any ideas?
TIA!
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4200961#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...