Using scrollable resultset in stored procedures

Greenhorn

Posts: 11

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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..

JulianInactive KennedyInactive

Ranch Hand

Posts: 823

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 11

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

It is of type forward only...that is the problem

The One..

Jose Botella

Ranch Hand

Posts: 2120

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

JulianInactive KennedyInactive

Ranch Hand

Posts: 823

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Manish,

Can you post a code fragment? Which JDBC driver are you using?

Space seems cool in the movies, but once you get out there, it is super boring. Now for a fascinating tiny ad:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com