h2 db , log4j

h2database URL : http://www.h2database.com/




log4J.xml

<appender name="jdbcAppender" class="org.apache.log4j.jdbc.JDBCAppender">
<param name="URL" value="jdbc:h2:file:~/db/oasis" />
<param name="Driver" value="org.h2.Driver" />
<param name="User" value="oasis" />
<param name="Password" value="" />
<layout class="org.apache.log4j.EnhancedPatternLayout">
            <param name="ConversionPattern"
              value="INSERT INTO OASIS_LOG (SYSTEM_NAME, LOG_DATE, LOG_LEVEL, MESSAGE, THROWABLE) VALUES ('%C', '%d{yyyy-MM-dd HH:mm:ss.SSS}', '%p', '%m', '%throwable{10}');"
            />
        </layout>
</appender>



log file name : oasis.h2.db