aspose file tools*
The moose likes JDBC and the fly likes OJDBC resultset type and concurrency problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "OJDBC resultset type and concurrency problem" Watch "OJDBC resultset type and concurrency problem" New topic

OJDBC resultset type and concurrency problem

go shangai

Joined: Nov 27, 2007
Posts: 1

we are using a stored procedure in oracle in order to get some info out of the database. This stored procedures has one IN param (id) and one OUT param (OracleTypes.CURSOR)
stm = conn.prepareCall("(ExamenPackage.usp_getExam(?,?)}, OracleResultSet.TYPE_SCROLL_SENSITIVE, OracleResultSet.CONCUR_UPDATABLE);

rs = stm.getCursor(2);

Notice above, we specify the type of the rs as SENSITIVE and the cocurrancy as UPDATABLE.
For some reason JDBC determins that the specified type & concurrancy is unsuitable and makes the resultset TYPE_FORWARD_ONLY & CONCUR_READ_ONLY.

Which gives us a problem when we try to perform rs.last();

Does anybody know the solution to our problem?
(Hoping it is possible to change the type of resultset to the correct type).
I agree. Here's the link:
subject: OJDBC resultset type and concurrency problem
Similar Threads
java stored procedure problems
What am i doing wrong here? ( Stored Procedure REF CURSOR Problem)
Displaying Image from database on to the screen
Need a disconnected resultset taking more time