Re: Error while retrieving generated keys - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Error while retrieving generated keys
Date
Msg-id 1B82A631-0DB7-4D4D-A506-8571342C8907@fastcrypt.com
Whole thread Raw
In response to Re: Error while retrieving generated keys  ("Gary Greenberg" <gary@icontrol.com>)
List pgsql-jdbc

On 9-Mar-07, at 4:14 PM, Gary Greenberg wrote:

See my responses inline:

 

-----Original Message-----
From: Heikki Linnakangas [mailto:hlinnaka@gmail.com] On Behalf Of Heikki Linnakangas
Sent: Friday, March 09, 2007 11:31 AM
To: Gary Greenberg
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Error while retrieving generated keys

 

Gary Greenberg wrote:

> I see it now. It should have been, however, mentioned in documentation for

> the JDBC driver.

 

Agreed, this question has come up many times recently. Would you like to

write a paragraph or two explaining the situation and the workaround?

 

I don't know about an easy workaround. Especially while using frameworks.

I am using Spring framework with Hibernate mapping and a lot of low level Java code is hidden from me. I do not have a particular desire to go back to plain JDBC calls. If I have to, I'd replace INSERT statement with a call to a stored function returning key value. But as said in my original email it is a lot of additional hassle.


Hibernate deals with this just fine. You just have to specify the correct KeyGenerator.

 

> In essence it means that PostgreSQL has fallen into the third world of

> database engines.

...

 > I am really disappointed that PostgreSQL is becoming a fossil.

 

;-) Now you're exaggerating.

Am I? Who, in his right mind will go back from using JPA or Hibernate to plain old JDBC calls?

Should we go to managing transactions manually, OR mapping, etc?

It would be exaggerating if I’d offer to go back to punch cards or coding in assembler. (I do remember it).

> If there are no plans to make this feature work in the very near future,

> I'll be pushing for replacement of the engine.

 

Ken Johanson posted a preliminary patch in February, but there was a

bunch of issues with it. This is an open source project, so if you'd

like to see it happen, patches are more than welcome.

I can look up at this patch and see if I can contribute to fix it. Unfortunately I am on tight project schedule.

How do I download the patch, though?

--

   Heikki Linnakangas

   EnterpriseDB   http://www.enterprisedb.com



pgsql-jdbc by date:

Previous
From: "Mike Clements"
Date:
Subject: Re: Fetching generated keys
Next
From: Oliver Jowett
Date:
Subject: Re: Error while retrieving generated keys