tag not prasing


[ Antworten ] [ Ihre Antwort ] [ Forum www.mannhaupt.com ]

Abgeschickt von Gaetano am 15 Juli, 2005 um 19:17:48

Hi, I'm using log4j 1.2.9 and your jdbcappender.
It seems that it can't parse some tags. But maybe am I in error with something...

In log4j.properties I have:

log4j.appender.tmdb=org.apache.log4j.jdbcplus.JDBCAppender
log4j.appender.tmdb.url=jdbc:mysql://localhost:3306/transfer
log4j.appender.tmdb.dbclass=com.mysql.jdbc.Driver
log4j.appender.tmdb.username=root
log4j.appender.tmdb.password=root
log4j.appender.tmdb.sql=INSERT INTO transfer (esito_operazione, log_priority, idstep,transfer_id,fid,data,url,command,path_file_origine,size_origine,path_file_destinazione,size_destinazione, message) VALUES ('@PRIO@', @IPRIO@, '@MDC:transfer.step@','@MDC:transfer.staticIdentifier@','@MDC:transfer.dynamicIdentifier@','@TIMESTAMP@','@MDC:transfer.url@','@MDC:transfer.command@', '@MDC:transfer.sourceFilePath@', '@MDC:transfer.sourceFileSize@', '@MDC:transfer.destFilePath@', '@MDC:transfer.destFileSize@', '@MSG@')
log4j.appender.tmdb.layout=org.apache.log4j.PatternLayout
log4j.appender.tmdb.layout.ConversionPattern=[%t] %m##%d{dd.MM.yyyy}#%d{HH:mm:ss}
log4j.appender.tmdb.layoutPartsDelimiter=#
log4j.appender.tmdb.buffer=1
log4j.appender.tmdb.commit=true
log4j.appender.tmdb.quoteReplace=true

What I obtain is:

log4j:ERROR JDBCAppender::flush_buffer(), : INSERT INTO transfer (esito_operazione, log_priority, idstep,transfer_id,fid,data,url,command,path_file_origine,size_origine,path_file_destinazione,size_destinazione, message) VALUES ('INFO', @IPRIO@, '1121447379030','gmazzeoTest','21','2005-07-15 19:09:39.077','','it.aiswts.libs.transfer.process.EndTransferService', '', '0', '', '0', 'Fine servizio')
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@, '1121447379030','gmazzeoTest','21','2005-07-15 19:09:39.077'"

As you can see the @IPRIO@ tag isn't replaced by the corect value. I also saw that the @INC@ tag in some positions is parsed, while for example at the end of the query not.

Do you know why happens this?

Thank you.
Cheers.
Gaetano



Antworten:



Ihre Antwort

Name:
E-Mail:

Subject:

Text:

Optionale URL:
Link Titel:
Optionale Bild-URL:


[ Antworten ] [ Ihre Antwort ] [ Forum www.mannhaupt.com ]