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.t4cconnect...@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$txconnectioneventliste...@13115ab[state=normal
mc=org.jboss.resource.adapter.jdbc.local.localmanagedconnect...@1f0bf67
handles=0 lastUse=1229578757037 permit=false trackByTx=false
mcp=org.jboss.resource.connectionmanager.jbossmanagedconnectionpool$onep...@a63987
context=org.jboss.resource.connectionmanager.internalmanagedconnectionp...@10aed2c
xaresource=org.jboss.resource.connectionmanager.txconnectionmanager$localxaresou...@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$txconnectioneventliste...@13115ab[state=destroyed
mc=org.jboss.resource.adapter.jdbc.local.localmanagedconnect...@1f0bf67
handles=0 lastUse=1229578757037 permit=false trackByTx=false
mcp=org.jboss.resource.connectionmanager.jbossmanagedconnectionpool$onep...@a63987
context=org.jboss.resource.connectionmanager.internalmanagedconnectionp...@10aed2c
xaresource=org.jboss.resource.connectionmanager.txconnectionmanager$localxaresou...@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#4200961
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4200961
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
