0 Replies Latest reply on Aug 28, 2006 2:56 AM by rocksayz

    Problem with datasource

    rocksayz

      i am using oracle data source and it was working fine but suddenly this error prompted after a month
      [JBossManagedConnectionPool] Exception destroying ManagedConnection org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@e6899[state=DESTROYED mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@7103af handles=0 lastUse=1156519380593 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1a8ecf4 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@15c9f9d xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@1f33bb0 txSync=null]org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Io exception: Connection reset) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:481)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:206)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:550)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.removeTimedOut(InternalManagedConnectionPool.java:415)
      at org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:81)
      at java.lang.Thread.run(Thread.java:536)
      Caused by: java.sql.SQLException: Io exception: Connection reset
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273)
      at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:395)
      at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1046)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:202)
      ... 4 more

      Please let me what is the solution for this