This content has been marked as final.
Show 1 reply
-
1. Re: ClassCastException during getCursor with Oracle...
daorriss Jun 21, 2004 12:59 PM (in response to daorriss)I figured out how to do it.. For posterity I'll post it here...
cst = connection.prepareCall("{call request_list.get_default_request_list (?,?,?)}"); cst.setInt(1, 1); cst.setInt(2, 1); cst.registerOutParameter(3, OracleTypes.CURSOR); cst.execute(); rs = (ResultSet) cst.getObject(3);
Note that using getCursor doesn't work BUT getObject does provided I tell the output parameter it's a oracle cursor.
Go figure - the one thing I didn't try was the way to fix it..
The reason for this is that JBoss called statements are implemented via a WrappedCallableStatement (a JBoss object) and that can't be cast to the OracleCallableStatement (which makes sense after I thought about it a bit). However, you can register the output parameter as an oracle type and then cast *that* to the result set.