?
Solved

Scrollable ResultSet using Stored Procedure

Posted on 2001-08-28
4
Medium Priority
?
293 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
Suggested Courses

649 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