I see... Thanks! :-D
Ivan Ooi <firstname.lastname@example.org> writes:
> Hi all,
> I got one question about auto incremental column and
> Let says, I got 3 connections doing insert at the same time on one of the
> table with an auto incremental column.
> Will Derby able to return correct value back to each client using
> IDENTITY_VAL_LOCAL() ?
Yes, Derby will return the correct value to each
client. IDENTITY_VAL_LOCAL() returns the most recently generated
identity value in a single-row insert on the same connection, and the
return value should not be affected by concurrent activity on other
For details, see