Scrollable ResultSet using proc out cursor

From: Klaus Brungs <klaus.brungs_at_intertransact.com>
Date: Thu, 23 Aug 2001 10:51:35 +0200
Message-ID: <9m2g32$bvbpo$1@ID-75788.news.dfncis.de>

We are trying to get a Scrollable ResultSet from a Stored Procedure, but the ResultSet we get is TYPE_FORWARD, no matter what I set. I have used following Code to get it:

cS = conn.prepareCall("{ call IWS_KLB.Pkg_TestSelect.TestSelect4 (?) }",

                           ResultSet.TYPE_SCROLL_SENSITIVE,
                           ResultSet.CONCUR_UPDATABLE );

cS.registerOutParameter( 1, OracleTypes.CURSOR); cS.execute();
ResultSet rset = (( OracleCallableStatement)cS).getCursor(1);

The Environment I'm working in is:
Oracle 8.1.7.2.0 for Solaris 8
JDK 1.3 under Windows2000
JDBC Driver Version 9.0.1 Thin

When I use a select statement instead of "{ call IWS_KLB.Pkg_TestSelect.TestSelect4 (?) }" it works just fine.

Is there a problem about casting a cursor into a Scrollable ResultSet? Any ideas?
The whole issue is forcing us to do a completely diffrent way of coding on the servlets side.
T.I.A. Received on Thu Aug 23 2001 - 03:51:35 CDT