2 Replies Latest reply on Jan 24, 2008 10:29 AM by Mark Little

    Not closing connections with Oracle 10g

    Sean McCauliff Newbie

      Hi,

      I'm using oracle 10g, JbossTM 4.2.3SP5, and Hibernate 2. It seems like the Oracle connections are never closed which eventually leads to errors with Oracle; ORA-12514: TNS:listener could not resolve SERVICE_NAME. After doing some debugging I've found this code in com.arjuna.ats.internal.jdbc.ConnectionImple.close() :


      /*
      * We can't close the connection until the transaction
      * has terminated, so register a synchronisation here
      */

      getModifier();

      if (_theModifier != null && ((ConnectionModifier) _theModifier).supportsMultipleConnections()) {
      tx.registerSynchronization(new ConnectionSynchronization(_theConnection, _recoveryConnection));
      _theConnection = null;
      }