[MonetDB-users] primary key retrieval

m h sesquile at gmail.com
Mon Dec 3 17:26:48 CET 2007


On Dec 3, 2007 6:48 AM, Lange Marcus <marcus.lange at saabgroup.com> wrote:
>
>
>
> Hello,
>
> How do I retrieve the primary key id value after inserting something new
> into the database ?

Hey Marcus, I had a similar question using python a few days back.
The subject was "python cursor missing lastrowid attribute?"  That
might help.

The basic answer is that this is not supported (due to concurrency
issues).  The workaround is to pregenerate PKs using sequences.

> I am writing a simple Java app. (using JDBC) and would like to get this info
> back into my program.
>
> Thanks for any help!
>

Good luck

-matt




More information about the users-list mailing list