log4j JDBCAppender with Oracle problem

[Sagar Kale]

Hi

I am trying to configure log4j JdbcAppender with Oracle Database. My properties file is

log4j.rootLogger=C

log4j.logger.C=ERROR, A3
log4j.appender.A3=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.A3.Driver=oracle.jdbc.driver.OracleDriver
log4j.appender.A3.URL=jdbc:oracle:thin:scott/tiger@(description=(address_list=(address=(protocol=tcp)(host=myhost)(port=1521)))(source_route=yes)(connect_data=(sid=Ora9i)(SERVICE_NAME = Ora9i)) )
log4j.appender.A3.User=scott
log4j.appender.A3.Password=tiger
log4j.appender.A3.layout=org.apache.log4j.PatternLayout
log4j.appender.A3.layout.ConversionPattern=
       insert into MyLogTable(log_detail) values('%d [%t] %-5p %C - %m%n')

My Java class is

import org.apache.log4j.Logger;

public class Test1 {

	/**
	 * @param args
	 */
	
		private static Logger logger = Logger.getLogger("C");
	    public Test1() {
	        testLogging();
	    }
	    public void testLogging() {
	        logger.debug("starting testLogging method....");
	        for(int i=0;i<10;i++) {
	            logger.info("counting work ..."+i);
	        }
	        logger.debug("closing testLogging method....");
	        logger.error("some error occured....");
	    }
	    public static void main(String[] args) 
	    {
	        new Test1();
	    }

	

}

but after getting logger and trying log error, I get following



log4j:ERROR Failed to excute sql
java.sql.SQLException: ORA-01009: missing mandatory parameter

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)
at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:178)
at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:250)
at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:146)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
at org.apache.log4j.Category.callAppenders(Category.java:203)
at org.apache.log4j.Category.forcedLog(Category.java:388)
at org.apache.log4j.Category.debug(Category.java:257)
at com.test.test.Test1.testLogging(Test1.java:16)
at com.test.test.Test1.<init>(Test1.java:13)
at com.test.test.Test1.main(Test1.java:25)