JDBCAppender issue

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

JDBCAppender issue

mymail-3
Ok,

I switched over to JDBC logging to my database a couple days ago.  Setup
the tables in the DB, granted permissions to the DB user, and it all works
great...except for a lag time in the login process now.  It is taking
about 20 seconds to login.  The login process is quite simple ? takes the
inputs from the form (usename/password) then does a compare with the
database, sets some environment variables, etc.  Then returns.  There are
some log4j debug messages in there, but not many more than any other
process or task.

I switched out the new JDBC version of my log4j.properties file and went
back to my RollingFileAppender version and it?s back to ~ 1 second to
login.

It?s not a huge deal since the RollingFiles are just as convenient for me,
but it would be really nice to be using the JDBC and be able to do some
queries on it.

Just wondering if anyone else was experiencing this or if (again) it is
just me. :)

Here is my JDBC version:

Log4j.logger.org.mysite=debug, orgcp

Log4j.appender.orgcp=org.apache.log4j.jdbc.JDBCAppender
Log4j.appender.orgcp.URL =
jdbc:mysql://localhost:3306/cporg_logs?autoReconnect=true
Log4j.appender.orgcp Driver=com.mysql.jdbc.Driver
Log4j.appender.orgcp User=cporg_logs
Log4j.appender.orgcp Password=password
Log4j.appender.orgcp Sql=INSERT INTO orgcp (level,date_time,class,message)
VALUES (?%5p?, ?%d?, %F:%L:%C?, ?%m%n?)

Layout=org.apache.log4j.PatternLayout


My RollingFile looks like this:

log4j.logger.org.mysite = debug, orgcp

log4j.appender.orgcp=org.apache.log4j.RollingFileAppender
log4j.appender.orgcp.File=/home/cpadmin/cplogs/orgcp.log

log4j.appender.orgcp.MaxFileSize=100KB
log4j.appender.orgcp.MaxBackupIndex=10

log4j.appender.orgcp.layout=org.apache.log4j.PatternLayout
log4j.appender.orgcp.layout.ConversionPattern=%5p [%d{dd MMM yyyy
HH:mm:ss,SSS}] (%F:%L:%C) - %m%n


Anyone see anything glaringly wrong?

TIA



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]