Userdefind property

[Parmar, Dipakkumar]

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]>