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
posted
0
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
posted
0
It is of type forward only...that is the problem
Jose Botella
Ranch Hand
Joined: Jul 03, 2001
Posts: 2120
posted
0
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
0
