[Resolvido]Configuração Log4j jdbcAppender

Assuntos Gerais
#1

Pessoal, boa tarde…

Estou tentando utilizar o jdbcAppender do log4j e estou tendo problemas no deploy da minha aplicação jsf…

O erro que está ocorrendo:

log4j:ERROR Failed to excute sql
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 '' at line 1
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
	at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
	at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)
	at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:178)
	at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:250)
	at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:146)
	at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
	at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
	at org.apache.log4j.Category.callAppenders(Category.java:206)
	at org.apache.log4j.Category.forcedLog(Category.java:391)
	at org.apache.log4j.Category.log(Category.java:856)
	at org.apache.commons.logging.impl.Log4JLogger.info(Log4JLogger.java:133)
	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4701)
	at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5204)
	at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5199)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

O arquivo log4j.properties:

!--------------------------Apender para gravar os logs no banco de dados-------------------------------------!

log4j.rootLogger = DEBUG, DB
log4j.appender.DB=org.apache.log4j.jdbc.JDBCAppender

# Set JDBC URL
log4j.appender.DB.URL=jdbc:mysql://localhost:3306/jmasiste_webtransp
# Set Database Driver
log4j.appender.DB.driver=com.mysql.jdbc.Driver


# Set database user name and password
log4j.appender.DB.user=jmasiste_root
log4j.appender.DB.password=*********

# Set the SQL statement to be executed.
log4j.appender.DB.sql=INSERT INTO LOGS_010 
                      VALUES('%x','%d','%C','%p','%m')
                      
# Define the layout for file appender
log4j.appender.DB.layout=org.apache.log4j.PatternLayout

Alguém poderia dar um help?

#2

Bom dia,

Consegui resolver o problema seguindo o exemplo de configuração que tem no livro Pro Apache log4j.

Obrigado.

#3