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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
