This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Getting classcast exception when getting cursor from stored prcedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Getting classcast exception when getting cursor from stored prcedure" Watch "Getting classcast exception when getting cursor from stored prcedure" New topic
Author

Getting classcast exception when getting cursor from stored prcedure

Reddy Sudhakar
Greenhorn

Joined: Sep 23, 2002
Posts: 11
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

Joined: Oct 13, 2005
Posts: 44038
    
  33
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

Joined: Oct 14, 2005
Posts: 19728
    
  10

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

Joined: Sep 23, 2002
Posts: 11
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
 
subject: Getting classcast exception when getting cursor from stored prcedure
 
It's not a secret anymore!