og4j:ERROR JDBCAppender::setColumn()

Abgeschickt von bhau am 05 Oktober, 2004 um 00:27:06

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

Antworten:

• play texas holdem play texas holdem 10:03:03 05/1/2005 (0)
• texas holdem texas holdem 13:17:34 04/1/2005 (0)
• texas holdem texas holdem 08:16:21 04/1/2005 (0)
• texas hold em texas hold em 22:22:54 03/1/2005 (0)
• online poker online poker 11:03:13 03/1/2005 (0)
• texas holdem texas holdem 12:45:35 02/1/2005 (0)
• texas holdem <a href=http://www.texas-holdem-p.com texas holdem texas holdem 20:20:51 01/1/2005 (0)
• Re: og4j:ERROR JDBCAppender::setColumn() Danko 14:57:19 14/11/2004 (6)
  • texas holdem texas holdem 15:05:33 04/1/2005 (0)
  • texas holdem texas holdem 09:57:29 04/1/2005 (0)
  • texas hold em texas hold em 00:03:20 04/1/2005 (0)
  • online poker online poker 12:49:21 03/1/2005 (0)
  • texas holdem texas holdem 14:29:26 02/1/2005 (0)
  • texas holdem <a href=http://www.texas-holdem-p.com texas holdem texas holdem 22:00:57 01/1/2005 (0)
• Re: og4j:ERROR JDBCAppender::setColumn() Danko 13:40:50 06/10/2004 (0)

Ihre Antwort