File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes resultset type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "resultset type" Watch "resultset type" New topic

resultset type

krishna prasad gunasekaran
Ranch Hand

Joined: Jul 25, 2006
Posts: 158
good day,
i use connection.preparecall to call a procedure that returns some rows.
my java code has to do something with the last row returned. so, in order to perform that logic, i could comeup with only two options

1. we have to find out the total rows returned which can be done in the procedure. is there a way to find the total rows returned by the cursor, without doing looping and fetching.

2. use resultset.isLast(). i have used the following code.
callableStatement = connection.prepareCall("{call Pkg_test.prget(?,?,?)}", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
but somehow the type is reset to TYPE_FORWARD_ONLY by the driver. why is my type not feasible. due to this, i couldn't use isLast().

have a nice day,
krishna prasad

have a great day,
krishna prasad
Rob Spoor

Joined: Oct 27, 2005
Posts: 20180

Why not use ORDER BY to change the order around so the last item now is the first item then, also combined with a limitation on the number of rows (TOP 1 in MS SQL Server, LIMIT 0 in MySQL).

How To Ask Questions How To Answer Questions
I agree. Here's the link:
subject: resultset type
It's not a secret anymore!