commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From William Speirs <wspe...@apache.org>
Subject Re: [DbUtils] Returning the newly-generated primary key after an insert
Date Sun, 29 Jan 2012 16:21:52 GMT
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