[jboss-user] [JCA/JBoss] - WHY pingDatabase failed status=-1?

[xpdz]

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 at 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 at 13115ab[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection at 1f0bf67 handles=0 lastUse=1229578757037 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at a63987 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 10aed2c xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource at 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 at 13115ab[state=DESTROYED mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection at 1f0bf67 handles=0 lastUse=1229578757037 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at a63987 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 10aed2c xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource at 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