[cvsnt] Re: Repository auditing with Oracle

Olaf Groeger Olaf.Groeger at gmx.de
Tue Jan 10 06:39:41 GMT 2006


Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.


> 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




More information about the cvsnt mailing list
Download the latest CVSNT, TortosieCVS, WinCVS etc. for Windows 8 etc.
@CVSNT on Twitter   CVSNT on Facebook