• Post Reply Bookmark Topic Watch Topic
  • New Topic

Callable Statement and Scrollable ResultSet

 
Narasimhan Balasubramanian
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all ,
This is the way i create a Callable Statement
<b>CallableStatement cs =
conn.prepareCall("{call procedure_name}", ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);</b>
I register the out parameters
and retrieve the parameters to a resultSet
<b>rs = (ResultSet)cs.getObject(1);</b>
I expect the result set to be scroll insensitive but when i do a
rs.previous();

it throws a SQLException
<b>java.sql.SQLException: Invalid operation for forward only resultset </b>
I believe it is a set up issue, we are using JDK1.2.2, now what versions of JDBC do i need to have to make this work ? We are using Oracle 9i, could this create a problem. Are there any other version checks that i need to make ?
TIA
Narsi
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!