Re: tag not prasing

Subject:

Text:
: Hi, sorry, was a stupid problem, I had two related project in Eclipse and it was loading a jdbcappender version of last year instead of the correct one. : Delete this thread if you want. : Thanks. : Gaetano : : Unfortunately I cannot reproduce this, even if I use exactly your sql string. : : Danko : : : 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

Optionale URL:
Link Titel:
Optionale Bild-URL: