Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

OJDBC resultset type and concurrency problem

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

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).
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic