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
