Abgeschickt von Danko am 06 Oktober, 2004 um 13:40:50:
Antwort auf: og4j:ERROR JDBCAppender::setColumn() von bhau am 05 Oktober, 2004 um 00:27:06:
Hi,
I will check, but I am very busy right now. Will take at least a week.
Danko
: Hi,
: I am getting this error don't know how to resolve.
: TIA
: --Bhau
: 4e3bdc15 SystemErr R log4j:ERROR JDBCAppender::setColumn(), table or procedure has to be set before !
: [10/4/04 17:11:22:043 CST] 4e3bdc15 SystemErr R log4j:ERROR JDBCAppender::setColumn(), table or procedure has to be set before !
: My Config File:
: ## JDBCAppender log4j.properties file
: log4j.rootCategory=DEBUG, JDBC, stdout
: log4j.appender.JDBC=org.apache.log4j.jdbcplus.JDBCAppender
: #log4j.appender.JDBC.BufferSize=4096
: log4j.appender.JDBC.dbclass=oracle.jdbc.driver.OracleDriver
: log4j.appender.JDBC.url=jdbc:oracle:thin:@server1:1521:schema
: log4j.appender.JDBC.username=user
: log4j.appender.JDBC.password=password
: log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout
: #log4j.appender.JDBC.sql=INSERT INTO AUDIT_LOG (ID,USER_ID,MOD_DT,USER_IP,COMMENTS,REFERENCE,DOMAIN_ID,AUDIT_EVENT,AMOUNT) VALUES (3,11,sysdate,'2.7.1.1','Test Message','Test',1111,'Test Event',123)
: log4j.appender.JDBC.layout.ConversionPattern=[%t] %m##%d{dd.MM.yyyy}#%d{HH:mm:ss}
: log4j.appender.JDBC.table=AUDIT_LOG
: log4j.appender.JDBC.column=id~INC
: log4j.appender.JDBC.column=mod_dt~TIMESTAMP
: log4j.appender.JDBC.column=audit_event~CAT
: log4j.appender.JDBC.column=comments~MSG
: log4j.appender.JDBC.column=reference~THREAD
: log4j.appender.JDBC.column=amount~DYNAMIC~AmountColumnHandler
: log4j.appender.JDBC.column=user_id~DYNAMIC~UserIDColumnHandler
: log4j.appender.JDBC.column=user_ip~DYNAMIC~UserIPColumnHandler
: log4j.appender.JDBC.buffer=1
: #log4j.appender.JDBC.commit=Y
: log4j.appender.stdout=org.apache.log4j.ConsoleAppender
: log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
: # Pattern to output the caller's file name and line number.
: log4j.appender.stdout.layout.ConversionPattern=%5p [%t] %c %M (%F:%L) - %m%n
: #log4j.looger.com.test = WARN