ResultSet.updateXXX() not work

From: Fannie <fifi129_at_netvigator.com>
Date: 22 Oct 2001 02:47:52 -0700
Message-ID: <b1cc698e.0110220147.14bc4003@posting.google.com>

I am using JDBC thin driver to connect Oracle 8.1.6 for testing JDBC 2.0
It's failed for resultset.updateXXX()
I am using the following script for testing

/***************************************************************************/

   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   String sql;

   Driver myDriver =
(Driver)Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

   try {

      conn=DriverManager.getConnection("jdbc:oracle:thin:XX/xxxx_at_abc:1521:ABC");
      DatabaseMetaData DBMetaData = conn.getMetaData();
      boolean support1 =
DBMetaData.supportsResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE);
      boolean support2 =
DBMetaData.supportsResultSetType(ResultSet.CONCUR_UPDATABLE);
      boolean support3 =

DBMetaData.supportsResultSetConcurrency(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
%>

<p><%=support1%></p>
<p><%=support2%></p>
<p><%=support3%></p>
<%
	stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("SELECT * FROM tbl_abc");

	int concurrency = rs.getConcurrency();
	int type = rs.getType();

%>

<p>concurrency: <%=concurrency%></p>
<p>type: <%=type%></p>
<%
	rs.moveToInsertRow();
	rs.updateString("a", "Test");
	rs.updateDate("b", java.sql.Date.valueOf("2001-06-01"));
	rs.updateInt("c", 123);
	rs.insertRow();
	rs.updateRow();
	} catch (SQLException e)
	{	System.out.println("SQLMessage: " + e.getMessage());
	}
	finally
	{	rs.close();
		stmt.close();
		conn.close();	}
/***************************************************************************/

The result are :
DatabaseMetaData.supportResultSetType &
DatabaseMetaData.supportResultSetConcurrency return true ResultSet.getType return 1004
ResultSet.getConcurrency return 1007

Is it means that the JDBC Driver support JDBC2.0 there is some problem for the database

Please help
Fannie Received on Mon Oct 22 2001 - 04:47:52 CDT