Re: Help: ResultSet..insertRow() not coping with explicit - Mailing list pgsql-jdbc

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