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

From Miłosz Tylenda
Subject Re: Support of getting generated keys in driver version 8.4devel
Date
Msg-id 35a0a1a4-cb6e-491c-9a34-39c942bbb814@z27g2000prd.googlegroups.com
Whole thread Raw
In response to Support of getting generated keys in driver version 8.4devel  (Miłosz Tylenda <mtylenda@gmail.com>)
Responses Re: Support of getting generated keys in driver version 8.4devel
List pgsql-jdbc
> 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.

Kris, my picture is that I work with Apache OpenJPA - an object-
relational mapper. OpenJPA checks whether generated keys are supported
by calling DatabaseMetaData.supportsGetGeneratedKeys(). If true, the
generated keys are retrieved from PreparedStatement by giving column
names. If false, a second query is executed to get the value of
sequence associated with serial column. So, in the OpenJPA context,
supportsGetGeneratedKeys returning true would be more helpful, but I
can also imagine a case where it would break things.

Greetings,
Milosz


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: help please
Next
From: Peter Eisentraut
Date:
Subject: Re: German translation fixes