[cvsnt] Re: Repository auditing with Oracle

[Olaf Groeger]

> The identity columns are always called ID - a habit I picked up years
> ago and don't plan on breaking in the future - so you could use the
> column name reliably in the code to identify them.   The trick is
> getting the correct one after the insert (since on a busy server many
> clients may be creating rows at the same time).

No, the trick is to ask the database for an ID and use this ID for the
insert. The autoincrement feature of some DBs is only a convenient for
this, but performs the same internally. No matter how many clients are
connected, the database guarantees that a sequence-generated ID is valid.

Olaf