Re: Help: ResultSet..insertRow() not coping with explicit

On Wed, 24 Sep 2003, Jim Wright wrote:
> ---
> src/interfaces/jdbc/org/postgresql/test/jdbc2/UpdateableResultTest.java.~1.7.~
> 2002-09-11 07:38:45.000000000 +0200
> +++
> src/interfaces/jdbc/org/postgresql/test/jdbc2/UpdateableResultTest.java
> 2003-09-24 07:19:39.000000000 +0200
> @@ -66,6 +66,17 @@
>
> rs.close();
>
> + rs = st.executeQuery( "select oid, * from updateable");
> +
> + assertNotNull( rs );
> + rs.moveToInsertRow();
> + rs.updateInt( 1, 1 );
> + rs.updateString( 2, "jim" );
> + rs.updateString( 3, "4gotenit" );
> + rs.insertRow();
> +
> + rs.close();
> +
> rs = st.executeQuery("select id1, id, name, name1 from
> updateable, second" );
> try
> {
>

Here the updateInt(1,1) is trying to update the oid column which is not
allowed and giving the error you see.

Kris Jurka