Solved

Scrollable ResultSet using Stored Procedure

Posted on 2001-08-28
4
286 Views
Last Modified: 2008-02-01
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?

T.I.A.
0
Comment
Question by:kbrungs
4 Comments
 
LVL 3

Expert Comment

by:daitt
ID: 6444698
Did you try (TYPE_SCROLL_INSENSITIVE, CONCUR_READ_ONLY) ?
I think you cannot use sensitive scrollable resultset when it created by a StoredProc because to check whether the change can affect the resultset or not, the server must run the StoredProc again.
Just my guess,
daitt
0
 

Author Comment

by:kbrungs
ID: 6444786
Yes, I tried all supported combinations. It doesn't matter what I define the statement to be, after casting the cursor to an ResultSet it is TYPE_FORWARD_ONLY.
Thanks nevertheless,
Klaus
0
 
LVL 5

Expert Comment

by:vemul
ID: 7755812
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- To be PAQ'ed and points refunded

Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

vemul
Cleanup Volunteer
0
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 7846985
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is the latest versions eclipse neon 2 140
Java DateChooser? 3 29
How to monitor the number of connections/threads being utilized on Tomcat 6.0 8 56
arguments to jar 5 15
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now