Re: Insert Row to ResultSet problem....java.sql.SQLException:

That was it, thanks.......DOH!

Jason

> -----Original Message-----
> From: Kris Jurka [mailto:books(at)ejurka(dot)com]
> Sent: Tuesday, December 16, 2003 07:20 PM
> To: 'Jason L. van Brackel'
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] Insert Row to ResultSet problem....java.sql.SQLException: No Primary Keys
>
>
>
> On Tue, 16 Dec 2003, Jason L. van Brackel wrote:
>
> > ResultSet addressInfo = null; // ResultSet for Address Info
> > sql = "SELECT * FROM address;";
> > addressInfo = migr.queryStatement(migr.postgreSQLConnection, sql);
> > addressInfo.moveToInsertRow();
> > ..... this is where I get this exception
> > java.sql.SQLException: No Primary Keys
> > at org.postgresql.jdbc2.AbstractJdbc2ResultSet.isUpdateable(AbstractJdbc2ResultSet.java:1363)
> > at org.postgresql.jdbc2.AbstractJdbc2ResultSet.moveToInsertRow(AbstractJdbc2ResultSet.java:697)
> > at com.cimconsultants.EFRMigration.MigrationUtil.main(MigrationUtil.java:62)
>
> I think the problem is the semicolon after address. It is confusing
> the driver into trying to update a table named "address;". Either
> remove the semicolon or put a space between it and the table name.
>
> Kris Jurka
>
>