Hi,
I have to add Log4J's JDBCAppender with Stripes Framework.
So I created commons-loggin.properties and log4j.properties inside WEB-INF\CLASSES\ directory.
My log4J.properties contains:
log4j.rootLogger=debug,R
log4j.appender.R.Driver=com.mysql.jdbc.Driver
log4j.appender.R=org.apache.log4j.jdbc.JDBCAppende r
log4j.appender.R.URL=jdbc:mysql://localhost:3306/test
log4j.appender.R.user=root
log4j.appender.R.password=root
log4j.appender.R.sql=INSERT INTO testlogs (logdate,loglevel,location,message) VALUES ('%d','-%C','-%L','-%m')
log4j.appender.R.layout=org.apache.log4j.PatternLa yout
And I created my Logger object inside my ActionBean.
When I have started my Tomcat, I found the following error:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: 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 'BeforeAfterMethodInterceptor', for lifecycle stages: [RequestInit, ActionBeanRes' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2985)
I would be glad, if anyone kindly help me to resolve this issue