Re: JDBC 3.0 support? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: JDBC 3.0 support?
Date
Msg-id 1052300635.14269.142.camel@inspiron.cramers
Whole thread Raw
In response to Re: JDBC 3.0 support?  (Hanasaki JiJi <hanasaki@hanaden.com>)
List pgsql-jdbc
INSERT .... RETURNING will work here, but in the meantime

select nextval('sequence_name');
insert into (id,....) values ( result from above, ....)
continue working

Dave
On Tue, 2003-05-06 at 23:13, Hanasaki JiJi wrote:
> Any suggestions for architecture/implemenation in the following situation:?
>     - insert a new row
>     - primary key is an autoinc / sequence column
>     - no other column is sure to be unique
>     - need to continue working with the data of the row
>         after the insert and possibly do an update
>
> Barry Lind wrote:
> > Hanasaki,
> >
> > The driver is already 3.0 compliant for that.  It correctly returns
> > false to DatabaseMetaData.supportsGetGeneratedKeys() indicating that
> > postgresql does not support this functionality.  This isn't likely to
> > change unless some significant new functionality is introduced in the
> > server to do this.  There isn't really anything the driver can do here
> > since the functionality doesn't exist in the database to automatically
> > return this information.
> >
> > thanks,
> > --Barry
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: JDBC 3.0 support?
Next
From: Curt Sampson
Date:
Subject: Re: Postgres Issue with JDBC