FORWARD « Resultset « 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 » Resultset » FORWARD

1. Resultset returned by stored proc not forward only coderanch.com

2. ResultSet in forward direction error coderanch.com

Even if i change scroll insesnsitive to scroll sensitive no change in error .I think scroll-insensitive result set ignores changes that are made while it is open. It provides a static view of the underlying data it contains.If that was the case then why it work when i execute query using execute method

3. Forward only ResultSet coderanch.com

4. FORWARD_ONLY Resultset coderanch.com

Hi All, java version : 1.5.0_06 jdbc driver : ojdbc14dms.jar database : Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi public class RSTest { public static void main(String[] args) throws Exception { DriverManager.registerDriver(new OracleDriver()); Connection c = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:TEST","xxcm","xxcm"); String sql = "select papf.person_id,papf.effective_end_date,papf.person_type_id,papf.current_employee_flag,papf.sex " + " from per_all_people_f papf where employee_number like ? "; PreparedStatement ps = c.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE); ps.setString(1,"4583%"); ResultSet ...