• Post Reply Bookmark Topic Watch Topic
  • New Topic

Getting classcast exception when getting cursor from stored prcedure

 
Reddy Sudhakar
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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);
cstmt.setString(i++, ACTIVE_FLAG);
cstmt.registerOutParameter(i++, OracleTypes.CURSOR);
cstmt.registerOutParameter(i++, OracleTypes.NUMBER);
cstmt.execute();
rs = (ResultSet)cstmt.getObject(3); // Here i am getting classcast exception
Thanks in advance.

Regards
Sudhakar

 
Campbell Ritchie
Marshal
Posts: 53140
124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the value of i?
Try printing out the Object returned from no 3; that is obviously not a ResultSet or similar.

I don't know a lot more, I am afraid.
 
Paul Clapham
Sheriff
Posts: 21963
36
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Reddy Sudhakar
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
But same code in working in server, But in my local environment its not working
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!