JDBC Result Set Related Problem

[Prakash Rai]

package com.p14;

import java.sql.*;
import com.jdbcCentralConnetion.*;

public class test {
	public static void main(String[] args) {
		Connection con = null;
		Statement st = null;
		ResultSet rs = null;
		try {
			con = JdbcUtil.getOracleConnection();
			// con=JdbcUtil.getMysqlConnection();
			st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
			String sql = "select * from books";
			rs = st.executeQuery(sql);
			String bid = null;
			String bn = null;
			String au = null;
			String pub = null;
			String co = null;
			String is = null;
			String edi = null;
			while (rs.next()) {
				bid = rs.getString(1);
				bn = rs.getString(2);
				au = rs.getString(3);
				pub = rs.getString(4);
				co = rs.getString(5);
				edi = rs.getString(6);
				is = rs.getString(7);
				System.out.println(bid + "\t" + bn + "\t" + au + "\t" + pub
						+ "\t" + co + "\t" + edi + "\t" + is);
			}
			System.out.println("Check ...");
			// inserting row***
			rs.moveToInsertRow();
			rs.updateString(1, "ac01");
			rs.updateString(2, "JDBC");
			rs.updateString(3, "SP");
			rs.updateString(4, "ahs");
			rs.updateString(5, "111");
			rs.updateString(6, "100");
			rs.updateString(7, "1111-11");
			rs.insertRow();
			System.out.println("Check 2****");
			// updating row***
			rs.first();
			rs.updateInt(5, 400);
			rs.updateString(6, "9");
			rs.updateRow();

			// deleting row***
			rs.beforeFirst();
			while (rs.next()) {
				bid = rs.getString(1);
				if (bid.equals("B-1")) {
					rs.deleteRow();
				}
			}
			System.out.println("****After updating****");
			rs.beforeFirst();
			while (rs.next()) {
				System.out.println(rs.getString(1) + "\t" + rs.getString(2)
						+ "\t" + rs.getString(3) + "\t" + rs.getString(4)
						+ "\t" + rs.getString(5) + "\t" + rs.getString(6)
						+ "\t" + rs.getString(7));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

1. When I am Connection with Mysql its is working fine.
2. But In case of Oracle10 it is giving Problem Even though result Set is of Updatable type.

java.sql.SQLException: Invalid operation for read only resultset: moveToInsertRow
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.BaseResultSet.moveToInsertRow(BaseResultSet.java)
at com.p14.test.main(test.java:38)


Please someone go through it.. Thanks In advance...

[Avi Abrami]

Prakash,
Please refer to Oracle documentation for the database you are using.
There should be a book entitled "JDBC Developer's Guide".
In that book there should be a section entitled "Resultset Limitations and Downgrade Rules".
You should find there an explanation for the behaviour you describe.

Good Luck,
Avi.

[sai rama krishna]

Are you running trhough IDE. Try to put a break point and identify where the error is exactly coming and modify code if needed to suit oracle database.