aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Using scrollable resultset in stored procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Using scrollable resultset in stored procedures" Watch "Using scrollable resultset in stored procedures" New topic
Author

Using scrollable resultset in stored procedures

Manish Chhetri
Greenhorn

Joined: Oct 31, 2003
Posts: 11
Hi
I wanted to know if we could use scrollable(forward and backward) resultset for stored procedures. If yes, could i have a link or a sample code which tells me more about it.


The One..
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
There's a version of Connection.prepareCall() that takes resultSetType and resultSetConcurrency parameters, so I don't see why not as long as your driver supports JDBC 2.0. I've never tried it myself; why don't you give it a go?

Jules
Manish Chhetri
Greenhorn

Joined: Oct 31, 2003
Posts: 11
It is of type forward only...that is the problem
Jose Botella
Ranch Hand

Joined: Jul 03, 2001
Posts: 2120
If you are able to wait to J2SE 5.0 the implementations of the new RowSet interface are able to provide a Resultset scrollable even though the driver is not. RowSet extends ResultSet.
I haven't tried it but have a look at JdbcRowSet

And RowSet Tutorial


SCJP2. Please Indent your code using UBB Code
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
Manish,

Can you post a code fragment? Which JDBC driver are you using?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using scrollable resultset in stored procedures