0 Replies Latest reply on Feb 25, 2003 1:42 PM by kdavey

    Exception destroying ManagedConnection

    kdavey

      I am gettin the following message from the server. I am not quite sure where to look for the problem. This seems to be an intermittent problem. We are running 3.0.4 with Orcacle 91 release 2 and the jdbc 1.4 drivers from Oracle.

      From a application standpoint we are using Cocobase as the persistence engine. Cocobase is using the connection pool from JBoss for its connections. All the Oracle setting for timeouts are set to the default. Here is the connection profile for the Oracle Connection:

      <!--embedded mbean-->


      0
      50
      5000
      15
      <!--criteria indicates if Subject (from security domain) or app supplied
      parameters (such as from getConnection(user, pw)) are used to distinguish
      connections in the pool. Choices are
      ByContainerAndApplication (use both),
      ByContainer (use Subject),
      ByApplication (use app supplied params only),
      ByNothing (all connections are equivalent, usually if adapter supports
      reauthentication)-->
      ByContainer




      10:35:15,031 INFO [JBossManagedConnectionPool] Exception destroying ManagedConnection
      javax.resource.ResourceException: SQLException
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.checkException(LocalManagedConnection.java:501)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.destroy(LocalManagedConnection.java:230)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:273)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.removeTimedOut(InternalManagedConnectionPool.java:191)
      at org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:70)
      at java.lang.Thread.run(Thread.java:536)
      11:58:05,765 INFO [JBossManagedConnectionPool] Exception destroying ManagedConnection
      javax.resource.ResourceException: SQLException
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.checkException(LocalManagedConnection.java:501)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.destroy(LocalManagedConnection.java:230)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:273)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.removeTimedOut(InternalManagedConnectionPool.java:191)
      at org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:70)
      at java.lang.Thread.run(Thread.java:536)