• Post Reply Bookmark Topic Watch Topic
  • New Topic

OJDBC resultset type and concurrency problem

 
go shangai
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

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).
 
Maybe he went home and went to bed. And took this tiny ad with him:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!