Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Callable Statement and Scrollable ResultSet  RSS feed

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 ?
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!