This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Handling Cursors in JDBC programming Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Handling Cursors in JDBC programming" Watch "Handling Cursors in JDBC programming" New topic
Author

Handling Cursors in JDBC programming

Rajaguru Ramalingam
Greenhorn

Joined: Apr 12, 2004
Posts: 11
Hi Everyone,

Assume, my Stored procedure returns 10 values of same type.If i din't keep that as array, i can use the cursor otherwise. If it is the case, how to handle the cursor which has values of same type in my java-jdbc programming?

Thanks in advance.
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Register your out paramter as cursor, execute the procedure then typecast your output cursor to resultset and use onwards

Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Handling Cursors in JDBC programming
 
Similar Threads
ClassNotFoundException
Error in row
Connections that won't close
what is difference between JDBC1 and JDBC2 ?
Invalid Cursor State Error...