Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using scrollable resultset in stored procedures

 
Manish Chhetri
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is of type forward only...that is the problem
 
Jose Botella
Ranch Hand
Posts: 2120
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Manish,

Can you post a code fragment? Which JDBC driver are you using?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic