Re: Serial key - Mailing list pgsql-jdbc

Thanks Chris!

Just wanted to confirm what all I can do.

I will ofcourse go with the best way of generating id beforehand.

-----Original Message-----
From: Chris Smith [mailto:cdsmith@twu.net]
Sent: 13 February 2004 17:46
To: Bhushan Bhangale; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Serial key


Bhushan Bhangale wrote:
> I have a table in which the primary key is of type SERIAL. I insert a
> record and then I want the generated id because of this, so that I
> can use the id to insert records in child table.
>
> I know about a solution in which generate a id before hand and then
> use the id to insert in table and also in child tables.

IMO, that's definitely the best way to go.

> The other stuff which I read in JDK 1.4 is of getGeneratedKeys().
>
> The problem is I have to use JDK 1.3.1.
>
> Is there any solution for this problem?

Incidentally, using 1.4 wouldn't help you because the PostgreSQL JDBC driver
doesn't implement getGeneratedKeys anyway.  The only other approach is to
use
some unique set of columns in the table other than your numeric key, and
immediately follow your insert statement with a select.  This only works if
your records are unique without regard to the generated key.  As an example,
you'd do:

    insert into mytable (name, department, position, hiredate)
        values('jdoe', 'eng', 'manager', DATE '10-12-1994');

    select empid from mytable where
        name = 'jdoe' AND
        department = 'eng' AND
        position = 'manager' AND
        hiredate = DATE '10-12-1994';

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________