Re: og4j:ERROR JDBCAppender::setColumn()

Abgeschickt von Danko am 14 November, 2004 um 14:57:19:

Antwort auf: og4j:ERROR JDBCAppender::setColumn() von bhau am 05 Oktober, 2004 um 00:27:06:

It is not possible to use .column configuration options in property file configuration. That is, because there would be multiple values for the same key which is not allowed in property files. Please use xml file or source code configuration.

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

Antworten:

• 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)

Ihre Antwort