We've expanded our news coverage and improved our search! Visit
oreilly.com for the latest or search for all things across O'Reilly!
Article:
 |
|
Stored Procedures for Java Programmers
|
Subject: |
|
JDBC support for Cursors |
Date: |
|
2003-08-15 10:45:59 |
From: |
|
gokulsingh
|
|
<extract>Because returning cursors from procedures is not directly supported by JDBC, we use Types.OTHER to declare the return type of the procedure and then cast from the call to getObject().</extract>
JDBC does support returning of Cursors as ResultSet. The javadocs state the following :
"A CallableStatement can return one ResultSet or multiple ResultSet objects. Multiple ResultSet objects are handled using operations inherited from Statement."
I have worked with stored procedures on DB2 where a open cursor in the stored procedure was returned as a result set via the method CallableStatement.executeQuery().
|
1 to 1 of 1
1 to 1 of 1