Scrollable « result « Java Database Q&A

1.	Blob
2.	cassandra
3.	column
4.	Connection
5.	Cursor
6.	dao
7.	Data Type
8.	Database
9.	Database Product
10.	DataSource
11.	Date
12.	db2
13.	derby
14.	Development
15.	Driver
16.	Exception
17.	file
18.	hadoop
19.	hbase
20.	hsqldb
21.	ibatis
22.	JDBC
23.	memcached
24.	mongodb
25.	MS Access
26.	mysql
27.	ODBC
28.	Operation
29.	oracle
30.	postgresql
31.	Record
32.	result
33.	Resultset
34.	Schema
35.	SQL
36.	sqlite
37.	SQLserver
38.	Statement
39.	stored procedure
40.	sybase
41.	Table
42.	Transaction
43.	Trigger

Java Database Q&A » result » Scrollable

1. Scrollable Result Sets coderanch.com

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(DBError.java:114) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) at oracle.jdbc.driver.BaseResultSet.moveToInsertRow(BaseResultSet.java:4 46) at ...

2. Failed scrollable result set coderanch.com

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

3. Scrollable result sets and physical reads... coderanch.com

4. scrollable result sets coderanch.com

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(ScrollableResultSet.java:149) 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. coderanch.com

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.