The following bug has been logged online:

Bug reference: 1233
Logged by: David Bucciarelli

Email address: dbucciarelli (AT) tradesoft (DOT) it

PostgreSQL version: 7.4.3

Operating system: Linux Suse 9.0

Description: JDBC driver: moveToCurrentRow fails

Details:

The method moveToCurrentRow in the ResultSet class of the JDBC driver fails
with the following message:

"Result Set not updateable. The query that generated this result set must
select only one table, and must select all primary keys from that table. See
the JDBC 2.1 API Specification, section 5.6 for more details."

even if the query _include_ all primary keys and selects only one table (the
same code works fine with other JDBC drivers: i.e. MySql).

I guess this happen because the code at line 679 of the
org.postgresql.jdbc2.AbstractJdbc2ResultSet.moveTo CurrentRow should be:

if ( !isUpdateable() )

instead of:

if (!updateable)

Thanks and my best regards,
David Bucciarelli




---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Fixed in 7.4 and 8.0 branches. Thanks for the fix and sorry for the
delay, I've been travelling.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster