All, I'm unable to get my JDBC Appender to work properly. Below is the log4j.xml file. I created a table in oracle named TESTLOG with an attribute of MESSAGE with value of VARCHAR(255). When I run the program, the message are logged to the file, but not inserted into the table. It also doesn't throw any exceptions. <appender name="FILE" class="org.apache.log4j.FileAppender"><param name="File" value="c:/log4jTesting/log/file.log" /><param name="Append" value="false" /><layout class="org.apache.log4j.PatternLayout"><param name="ConversionPattern" value="%m%n" /></layout></appender><appender name="JDBC" class="org.apache.log4j.jdbc.JDBCAppender"><param name="BufferSize" value="4096" /><param name="Driver" value="oracle.jdbc.driver.OracleDriver" /><param name="URL" value="jdbc:oracle:thin:@oradev1:1521:apccat" /><param name="User" value="catp1" /><param name="Password" value="catp1" /><param na me="sql" value="INSERT INTO LOGTEST( MESSAGE ) VALUES( '%m' )" /><layout class="org.apache.log4j.PatternLayout"><param name="ConversionPattern" value="%m" /></layout></appender><category name="TestLog4J"><priority value="DEBUG" /><appender-ref ref="FILE" /><appender-ref ref="JDBC" /></category>-Gus
_______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web!
