I am gettting java.lang.ClassCastException: $Proxy63. WHen i am getting cursor from the stored procedure. In jboss 4.0.4
I am using java.sql.CallableStatement.
Here is my code
cstmt.setObject(i++, ratingTypeId, OracleTypes.NUMBER);
rs = (ResultSet)cstmt.getObject(3); // Here i am getting classcast exception
Thanks in advance.
The normal way to get a ResultSet from a query like that is to use CallableStatement.getResultSet(), which returns... a ResultSet! That may or may not work in this particular case, but it's more likely to work than your code is.
Joined: Sep 23, 2002
But same code in working in server, But in my local environment its not working