Serial key

Hi,

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.

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?

Thanks
Bhushan

________________________________________________________________________
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
________________________________________________________________________