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

Callable Statement and Scrollable ResultSet

Narasimhan Balasubramanian
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

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