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).
subject: OJDBC resultset type and concurrency problem