Re: Primary Key Error Updating Rows in ResultSet - Mailing list pgsql-jdbc

On Tue, 30 Nov 2004, Peter Smith wrote:

> I'm getting the error 'java.sql.SQLException: No Primary Keys' when
> trying to update a resultset based on a table with a primary key.
>

It is not enough to have a primary key on the table, you must also select
those columns in your ResultSet.  Further, the code to determine the table
in question isn't very good and is easily fooled.  What is your exact
SELECT statement and primary key definition?

Kris Jurka