help! JDBC code breaks with Connector/J v3

[Andy Carter]

I'm using updatable resultsets, selecting all columns from a table that definitely has a primary key and am not using joins. The prepared statement is created with ResultSet.CONCUR_UPDATABLE and ResultSet.FORWARD_ONLY options.

The code works perfectly with driver version 2.0.14 but breaks with 3.0.14 that our host is using!!

This error message is given:

Result Set not updatable.This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query 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.