commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Moandji Ezana <mwa...@gmail.com>
Subject Re: [DbUtils] Returning the newly-generated primary key after an insert
Date Sun, 29 Jan 2012 17:48:30 GMT
I don't mind, but it's a very limited implementation. I don't know if it's
abywhere near general-purpose for your needs.

I'll post it and let you decide.

Moandji
On 29 Jan 2012 18:21, "William Speirs" <wspeirs@apache.org> wrote:

> Interesting... would you be willing to donate your QueryRunner
> implementation? If so, open a JIRA ticket[1] with your request for this
> functionality, and upload your code.
>
> Thanks...
>
> Bill-
>
> [1] https://issues.apache.org/jira/browse/DBUTILS
>
> On Sun, Jan 29, 2012 at 11:19 AM, Moandji Ezana <mwanji@gmail.com> wrote:
>
> > On Sun, Jan 29, 2012 at 6:05 PM, William Speirs <wspeirs@apache.org>
> > wrote:
> >
> > > That is a question more specific to the database you're using, than
> > > DBUtils. For some databases this means writing a stored procedure which
> > > performs the insert, and then a special select to get the primary key.
> > You
> > > can of course use DBUtils to call this stored proc and read the primary
> > > key.
> >
> >
> > As Simone mentioned, I'd like to use Statement#getGeneratedKeys(), which
> > requires passing Statement.RETURN_GENERATED_KEYS to
> > Connection#prepareStatement(). It doesn't seem possible to do this with
> the
> > current API.
> >
> > I've written my own QueryRunner for the time being, but it seems like a
> > common enough requirement to be in the library itself.
> >
> > Moandji
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message