aspose file tools
The moose likes JDBC and the fly likes Does DB2 support Scrollable Resultsets with Callable Statements Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Does DB2 support Scrollable Resultsets with Callable Statements" Watch "Does DB2 support Scrollable Resultsets with Callable Statements" New topic
Author

Does DB2 support Scrollable Resultsets with Callable Statements

Reshma Sreenivasulu
Greenhorn

Joined: Dec 08, 2005
Posts: 8
Hi,

Does DB2 support Scrollablilty on Resultsets returned from Callable Statements?

This may be an oft repeated question...but could anyone please answer....?

Thanks.


Reshma
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 26496
    
  78

Reshma,
It would depend on the driver and version of db2. I know some db2 drivers don't even support scrollable resultsets for PreparedStatements.

The best bet would be to check the driver documentation or try it.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Does DB2 support Scrollable Resultsets with Callable Statements
 
Similar Threads
LockMode.UPGRADE produces false sql ?
callable statement
DB2 Query Batch?
Closing Statement object prior to committing
DB2 version 8 Type 4 Data Source