-
1. Re: need to get JDBC Connections to 2 different Schemas
saltnlight5 Aug 11, 2010 8:38 AM (in response to nskarthik_k)Err... how are you obtaining the Connection object? Through a JBoss DataSource pool? Are you using a PersistenceContext? Hibernate session factory?
Obviously the error indicate that you are using Connection object directly and you didn't close them propertly. You will have to look into your own code to find this problem.
-
2. Re: need to get JDBC Connections to 2 different Schemas
nskarthik_k Sep 14, 2010 5:18 AM (in response to saltnlight5)Hi
Sorry for the Late Reply ....
>>Through a JBoss DataSource pool?
Yes I am using the JBOSS Datasource pool using JNDI
I fetch the Connection from wrapper Object
[ Declaration skipped ]
try {
connx = ODS.getConnection();
WCP = (WrappedConnection)connx;
underlyingConn = WCP.getUnderlyingConnection();
connx = (OracleConnection)underlyingConn;
} catch (SQLException sqlex) {
sqlex.printStackTrace();
}And close the Connection as
try {
//Close WRAPPER Connection
WCP.close();
}catch (Exception e) {
Note:-
I am not using "con.close();" instead using "WCP.close();"
cause of Class Cast Exception for EXISTING ORACLE PLSQL's Call with in java methods.
and using the same we see in JMX Connections being released.with regars
karthik