Re: getGeneratedKeys()

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: getGeneratedKeys()
Date: 2003-12-30 23:56:23
Message-ID: 20031230235623.A27715@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


On 30/12/2003 23:18 henr-and(at)dsv(dot)su(dot)se wrote:
> > Can you do the insert using a function instead, and return the currval
> > on the underlying sequence?
> >
> > John
> >
>
> I'm not sure what you mean. A stored procedure?
>
> The good thing about getGeneratedKeys() is that you don't have to write
> DB-specific code.

I always thought that auto-generated keys _are_ db specific. Where are
they defined in SQL92/99?

Back to your problem: Does your app have to support different DBMSs or is
it PostgreSQL-only?

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message henr-and 2003-12-31 00:08:14 Re: getGeneratedKeys()
Previous Message Marcus Andree S. Magalhaes 2003-12-30 23:28:21 Re: getGeneratedKeys()