I'm trying to figure out how to use the ODBCAppender using sqlite3.  What
would the xml look like?  What would be in the param of URL? Is that even
needed?

For example:

 <appender name="testSqliteAppender"
class="org.apache.log4j.odbc.ODBCAppender">

 <param name="URL" value="Driver={sqlite3};Server=localhost
;Port=5432;Database=errorlog;Uid=sqlite3;Pwd=abc123;"/>

  <layout class="org.apache.log4j.PatternLayout">

  <param name="ConversionPattern" value="INSERT INTO errorlog (errormessage)
VALUES ('%d - %c - %p -%m')"/>

  </layout>

  </appender>

Reply via email to