result set cast problem...

denisspiridonov Nov 29, 2001 9:52 AM

hi everybody!!!
could anyone help me with such problem that i can't cast result set in the following code from my bean's DAO class:
...
oracle.sql.CLOB descn = ((OracleResultSet)rs).getCLOB(1);
...
i get java.lang.ClassCastException: org.jboss.pool.jdbc.ResultSetInPool
at that line... so, is there way to make jboss to return me OracleResultSet instead of ResultSetInPool?
i'm really stuck with that so any help will be very appriciated!!!

1. Re: result set cast problem...

davidjencks Dec 2, 2001 12:06 AM (in response to denisspiridonov)

You can get the Oracle Connection...
((ConnectionInPool)con).getUnderlyingConnection();

You can get the Oracle PreparedStatement

((PreparedStatementInPool)ps).getUnderlyingPreparedStatement

You can get the Oracle ResultSet

((ResultSetInPool)rs).getUnderlyingResultSet()
Actions