Hi I have been trying to write user define property in log message but could not succeed.
Config snippet: <appender name="jdbc" class="org.apache.log4j.jdbc.JDBCAppender"> <param name="Threshold" value="DEBUG"/> <param name="URL" value="blah"/> <param name="user" value="blah"/> <param name="password" value="blah"/> <!-- DOES NOT WORK--> <param name="sql" value=" INSERT INTO qual_audittrail(message, user_id) VALUES ('%m', '%userid')"/> <!-- DOES WORK --> <param name="sql" value=" INSERT INTO qual_audittrail(message) VALUES ('%m')"/> </appender> Code snippets static Logger logger = Logger.getLogger("AuditTrail"); static public void write(String msg, long userId) { System.setProperty("userid", String.valueOf(userId)); logger.info(msg); } Thanks Deepak -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>