[cvsnt] sessionid as foreign key
tony.hoyle at march-hare.com
Wed Jul 18 22:23:32 BST 2007
bwhicks at aep.com wrote:
> Hey guys, hoping someone can help here.
> I have audit logging enabled on a 2.5.03.2382 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