I have some strange problem using jboss's WrappedConnection.
If I write this simple jsp:
<%@ page import="javax.sql.*,javax.naming.*,java.util.*,java.sql.*,
java.math.*,it.imiweb.internal.todb.*,it.imiweb.internal.todb.util.*"%>
<%
try{
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)
ctx.lookup("java:/MYDATASOURCE");
org.jboss.resource.adapter.jdbc.WrappedConnection
wc=(org.jboss.resource.adapter.jdbc.WrappedConnection)ds.getConnection();
oracle.jdbc.driver.OracleConnection conn =
(oracle.jdbc.driver.OracleConnection)wc.getUnderlyingConnection();
// here i used the connection to call an oracle procedures using struct
conn.close();
}catch(Exception ex){
ex.printStackTrace();
}
%>
All is ok and I have any problem.
If, in my application I create an object where it get a Connection
using the same code jboss tell me this error:
java.lang.ClassCastException:
org.jboss.resource.adapter.jdbc.WrappedConnection
This is the method's code:
protected Connection checkOutConnection() throws Exception{
String idm =
"ContextStoredProceduresUtil.checkOutConnection - ";
try{
System.out.println(idm + "Check out
connection");
Context ctx = new InitialContext();
javax.sql.DataSource ds
=(javax.sql.DataSource)ctx.lookup(this.getDataSourceName());
System.out.println("my class is" +
ds.getConnection().getClass());
WrappedConnection
wc=(WrappedConnection)ds.getConnection();
return wc.getUnderlyingConnection();
}catch(Exception ex){
throw new Exception(idm + ex.getMessage());
}
}
The ClassCastException happens when I try to cast ds.getConnection(),
ma this is WrappedConnection 's object because I print before the class
name.
I don't understand why I have this problem.
I need an UnderlyingConnection to call an oracle's procedure with
object because this method with a simple ds.getConnection() and with no
procedure with object working great.
I try to use it with jboss 4.03 and 4.04
Any helps?
Luca.
