[cvsnt] sessionid as foreign key

Tony Hoyle tony.hoyle at march-hare.com
Wed Jul 18 22:23:32 BST 2007

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.

bwhicks at aep.com wrote:
> Hey guys, hoping someone can help here. 
> I have audit logging enabled on a linux server. It is using 
> ODBC to connect to a DB2 database. It was working fine for a while, but 
> now all of a sudden it is inserting "0" for the session ID in tables other 
> than the sessionlog table (i.e. the taglog table). This is obviously 
> wrong, so I did a trace and where it shows the SQL statement being used to 
> insert the data, it shows a 0 being inserted there, too. 
> Is CVS not getting the right sessionID from previous queries or something? 
> What could be the problem?
It gets the session id from a 'select identity_val_local()' appended to 
the session insert string (the whole string is something like 'begin 
atomic; insert into xxxxx; select identity_val_local(); end').

I can't think of a reason why that would suddenly stop working if it 
worked before unless there's a way to switch that functionality off 


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