Scrollable « result « Java Database Q&A

1. Scrollable Result Sets

I am trying to use scrolleble result set.But at the rs.moveToInsertRow();// i m getting sqlexception: The exception is : Balance is 1000 Account is1 Balance is 1000 Account is2 Balance is 1000 Account is3 Balance is 1000 Account is4 Balance is 1000 Account is5 java.sql.SQLException: Invalid operation for read only resultset: moveToInsertRo w at oracle.jdbc.dbaccess.DBError.throwSqlException( at oracle.jdbc.dbaccess.DBError.throwSqlException( at oracle.jdbc.driver.BaseResultSet.moveToInsertRow( 46) at ...

2. Failed scrollable result set

hi all, I want to know whether db2 database support scrollable result set? I am using db2 6.1 and it resulted in error when I tried to implemented it even by putting ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY inside the createstatement. Is there any other version db2 that support this or is there another way to implement scrollable result set in db2? Thanks

4. scrollable result sets

I was hoping somebody might be able to help me with this. I keep encountering an error of the form java.lang.NullPointerException at oracle.jdbc.driver.ScrollableResultSet.close( This error is as a result of changing the format of the JDBC result set. Initially my code looked lke this: Statement stmt1 = cont.conn.createStatement(); //no errors OracleResultSet ors1 = (OracleResultSet)stmt1.executeQuery(query1); Now the code is as follows: Statement ...

5. CLI0627E The result set is not scrollable.

You were looking for something in your configuration that was different between the two sites. Now you have found something. If it were me I would change the non-working site to be configured the same as the working site. Even though I have no idea whether that difference is the problem or not.