Re: Support of getting generated keys in driver version 8.4devel - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Support of getting generated keys in driver version 8.4devel
Date
Msg-id Pine.BSO.4.64.0812311423300.10458@leary.csoft.net
Whole thread Raw
In response to Support of getting generated keys in driver version 8.4devel  (Miłosz Tylenda <mtylenda@gmail.com>)
List pgsql-jdbc

On Wed, 31 Dec 2008, Mi³osz Tylenda wrote:

> I am looking for getting generated keys support in the driver. The
> changelog says it has basic generated keys support. However,
> DatabaseMetaData.supportsGetGeneratedKeys() returns false

I intentionally left supportsGetGeneratedKeys false because we don't
support returning generated keys by column indexes.  Without knowing how
used that method is, I'm not sure if this is more or less helpful.  I'm
open to input if people think we should change it to true.

> and when I execute:
>
> con.prepareStatement("insert into tab0 values(default, 444)", new
> String[] {"id"});
>
> I am receiving:
>
> Caused by: org.postgresql.util.PSQLException: Returning autogenerated
> keys is not supported.

This was an oversight on my part.  I added support for the Statement
methods, but somehow not for PreparedStatement methods.  Shouldn't be too
tough to add, let me take a look and get back to you in a day or two.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Miłosz Tylenda
Date:
Subject: Support of getting generated keys in driver version 8.4devel
Next
From: Kris Jurka
Date:
Subject: Re: Trying to insert an array using a prepared statement.