You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4j-user@logging.apache.org by Rongmei Rao <Ra...@mmsi.com> on 2001/10/12 21:20:37 UTC
JDBCAppender
Hello,
I downloaded the log4J verison 1.1.3 and also the JDBCAppender deveopled
by Thomas Fenner(from log4J web site third-party software). Then I
created a log4j_test.xml and Log4JTest.java. I comipled the Log4JTest
without problem. But when I ran the Log4JTest, an exception was thrown.
11.10.2001 16:28:50 - info
11.10.2001 16:28:50 - error
11.10.2001 16:28:50 - fatal
log4j:ERROR JDBCAppender::configure(), java.sql.SQLException:
[Microsoft][ODBC Microsoft Access Driver]Optional feature not
implemented
I do not know what was wrong. Here is the log4j_test.xml.
<?xml version=3D"1.0" encoding=3D"UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j=3D'http://jakarta.apache.org/log4j/'
disableOverride=3D"false" debug=3D"true">
<appender name=3D"JDBC"
class=3D"com.klopotek.utils.log.JDBCAppender">
<param name=3D"url" value=3D"jdbc:odbc:logtest"/>
<param name=3D"username" value=3D"test" />
<param name=3D"password" value=3D"test" />
=09
<param name=3D"table" value=3D"logtest" />
<param name=3D"column" value=3D"id~ID~MyIDHandler" />
<param name=3D"column" value=3D"prio~PRIO" />
<param name=3D"column" value=3D"cat~CAT" />
<param name=3D"column" value=3D"thread~THREAD" />
<param name=3D"column" value=3D"msg~MSG" />
<param name=3D"column"
value=3D"info~DYNAMIC~MyColumnHandler" />
<param name=3D"column" value=3D"created_on~TIMESTAMP" />
<param name=3D"column" value=3D"created_by~STATIC~me" />
<param name=3D"buffer" value=3D"1" />
<param name=3D"commit" value=3D"Y" />
<layout class=3D"org.apache.log4j.PatternLayout">
<param name=3D"ConversionPattern" value=3D"%m"
/>
</layout>
</appender>
<appender name=3D"SYSTEMOUT"
class=3D"org.apache.log4j.ConsoleAppender">
<param name=3D"target" value=3D"System.out" />
<layout class=3D"org.apache.log4j.PatternLayout">
<param name=3D"ConversionPattern" value=3D"
%d{dd.MM.yyyy HH:mm:ss} - %m\n" />
</layout>
</appender>
<root>
<appender-ref ref=3D"SYSTEMOUT" />
<appender-ref ref=3D"JDBC" />
</root>
</log4j:configuration>
Thanks in advance.
Rongmei
---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: log4j-user-help@jakarta.apache.org
Re: JDBCAppender
Posted by Christopher Taylor <cs...@java-internals.com>.
Do you have to use Access? MySQL is available on Windows, so you could use
that instead.
That error is a JDBC-ODBC bridge error.
-Chris
----- Original Message -----
From: "Rongmei Rao" <Ra...@mmsi.com>
To: <lo...@jakarta.apache.org>
Sent: Saturday, October 13, 2001 4:20 AM
Subject: JDBCAppender
Hello,
I downloaded the log4J verison 1.1.3 and also the JDBCAppender deveopled
by Thomas Fenner(from log4J web site third-party software). Then I
created a log4j_test.xml and Log4JTest.java. I comipled the Log4JTest
without problem. But when I ran the Log4JTest, an exception was thrown.
11.10.2001 16:28:50 - info
11.10.2001 16:28:50 - error
11.10.2001 16:28:50 - fatal
log4j:ERROR JDBCAppender::configure(), java.sql.SQLException:
[Microsoft][ODBC Microsoft Access Driver]Optional feature not
implemented
I do not know what was wrong. Here is the log4j_test.xml.
<?xml version=3D"1.0" encoding=3D"UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j=3D'http://jakarta.apache.org/log4j/'
disableOverride=3D"false" debug=3D"true">
<appender name=3D"JDBC"
class=3D"com.klopotek.utils.log.JDBCAppender">
<param name=3D"url" value=3D"jdbc:odbc:logtest"/>
<param name=3D"username" value=3D"test" />
<param name=3D"password" value=3D"test" />
=09
<param name=3D"table" value=3D"logtest" />
<param name=3D"column" value=3D"id~ID~MyIDHandler" />
<param name=3D"column" value=3D"prio~PRIO" />
<param name=3D"column" value=3D"cat~CAT" />
<param name=3D"column" value=3D"thread~THREAD" />
<param name=3D"column" value=3D"msg~MSG" />
<param name=3D"column"
value=3D"info~DYNAMIC~MyColumnHandler" />
<param name=3D"column" value=3D"created_on~TIMESTAMP" />
<param name=3D"column" value=3D"created_by~STATIC~me" />
<param name=3D"buffer" value=3D"1" />
<param name=3D"commit" value=3D"Y" />
<layout class=3D"org.apache.log4j.PatternLayout">
<param name=3D"ConversionPattern" value=3D"%m"
/>
</layout>
</appender>
<appender name=3D"SYSTEMOUT"
class=3D"org.apache.log4j.ConsoleAppender">
<param name=3D"target" value=3D"System.out" />
<layout class=3D"org.apache.log4j.PatternLayout">
<param name=3D"ConversionPattern" value=3D"
%d{dd.MM.yyyy HH:mm:ss} - %m\n" />
</layout>
</appender>
<root>
<appender-ref ref=3D"SYSTEMOUT" />
<appender-ref ref=3D"JDBC" />
</root>
</log4j:configuration>
Thanks in advance.
Rongmei
---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: log4j-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: log4j-user-help@jakarta.apache.org