1 Reply Latest reply on Aug 10, 2004 5:53 PM by sankas75

    Trouble Using OracleConnection

    sankas75 Newbie

      Environment : JBoss 3.23, Oracle 9.2.01(using Thin Drivers), Win2K

      Problem: I am getting an exception saying “Logical handle no longer valid” when using a OracleConnection class

      //Stateless Bean Class

      //Remote Methoid

      update () {
      //Step1 get regular connection
      java.sql.Connection conn = txdataSource.getConnection();
      //do DB Updates and close connection

      //Step2
      java.sql.Connection conn = txdataSource.getConnection();
      WrappedConnection wrappedConnection = (WrappedConnection) conn;
      return (OracleConnection)wrappedConnection.getUnderlyingConnection();
      //do DB updates and close connection

      //Step3 get regular connection
      java.sql.Connection conn = txdataSource.getConnection();

      //This is where exception occurs saying
      “Logical handle no longer valid”

      }



      Any help is appreciated on this.
      Thanx,
      Sanjeev