File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting classcast exception when getting cursor from stored prcedure

 
Reddy Sudhakar
Greenhorn
Posts: 11
  • 0
  • 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
Sheriff
Pie
Posts: 47262
52
  • 0
  • 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
Pie
Posts: 20185
26
MySQL Database
  • 0
  • 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
  • 0
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic