performing auditing in java with sql server DB - before and/or after do not get audited

Posted by Domingos on Stack Overflow See other posts from Stack Overflow or by Domingos
Published on 2010-12-21T08:52:52Z Indexed on 2010/12/21 8:53 UTC
Read the original article Hit count: 208

Filed under:
|
|

When auditing, sometimes the before value does not get audited, other times the after value does not get audited, other times both values do not get audited at all. After researching, I found out that only values from a specific codes table get audited. the code was: compareCodesTableInteger(audit, int, int, objectBefore, objectAfter, stringDescription, stringCodesTable); I then changed it to: compareCodesTableInteger(audit, int, int, objectBefore, objectAfter, stringDescription, booleanCheck ? stringCodesTableIfTrue : stringCodesTableIfFalse); Description: if objectBefore AND objectAfter are both from stringCodesTableIfTrue OR from stringCodesTableIfFalse, auditing takes place as expected. The problem is: most of the times, objectBefore is from stringCodesTableIfTrue, and objectAfter is from stringCodesTableIfFalse, or vice-versa. In this scenario auditing fails. How do I go around this? Please assist

© Stack Overflow or respective owner

Related posts about java

Related posts about sql-server