You are viewing a plain text version of this content. The canonical link for it is here.

Posted to log4cxx-user@logging.apache.org by Prakash Kadam <pk...@nulinkinc.com> on 2005/02/22 05:49:38 UTC

Help me for ODBCAppender

Hi All
 I am using the ODBC stuff of logg4cxx.and facing the problems.i am using the postgresql at server side.
So how can write xml configuration File for ODBCAppender.
i write the configurator but still having the error's check out this
 
 
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>
<appender name="JDBC" class="ODBCAppender">
        <param name="connection" value="dbname=it2005 user=postgres password='' host=ocean"/>
        <param name="URL" value="unixodbc:postgresql:ocean/5432:it2005"/>
        <param name="User" value="postgres"/>
        <param name="Password" value="''"/>
        <layout class="org.apache.log4j.PatternLayout">
                <param name="ConversionPattern" value="INSERT INTO jdbctest VALUES (%d %c %p %m)"/>
        </layout>
        <param name="buffer" value="200" />
        <param name="commit" value="true" />
</appender>
<root>
        <appender-ref ref="JDBC" />
</root>
</log4j:configuration>