connection not restored with MySQL

Subject:

Text:
: Hi, : We are using the lates version of JDBCAppender with MySQL database 5.0. The problem is that when database connection is lost it seems that connection is not restored correctly. Strange thing is that some things are still logged but most are not. : Here is the stracktrace: : log4j:ERROR error during logging. INSERT INTO access_log (user_id, ip, action_type, object_id, created_utc) VALUES ('N/A', '192.100.104.28', 'test', '307', STR_TO_DATE('12.10.2006 22:34:23', '%d.%m.%Y %H:%i:%s')) : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: : ** BEGIN NESTED EXCEPTION ** : java.net.SocketException : MESSAGE: Broken pipe : STACKTRACE: : java.net.SocketException: Broken pipe : at java.net.SocketOutputStream.socketWrite0(Native Method) : at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) : at java.net.SocketOutputStream.write(SocketOutputStream.java:136) : at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65) : at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) : at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) : at com.mysql.jdbc.Statement.executeUpdate(Statement.java:935) : at com.mysql.jdbc.Statement.executeUpdate(Statement.java:873) : at org.apache.log4j.jdbcplus.JDBCLogger.executeUpdateWhenNotEmpty(JDBCLogger.java:923) : at org.apache.log4j.jdbcplus.JDBCLogger.appendSQL(JDBCLogger.java:907) : at org.apache.log4j.jdbcplus.JDBCLogger.append(JDBCLogger.java:557) : at org.apache.log4j.jdbcplus.JDBCAppender.flush_buffer(JDBCAppender.java:887) : at org.apache.log4j.jdbcplus.JDBCAppender.append(JDBCAppender.java:867) : at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230) : at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65) : at org.apache.log4j.Category.callAppenders(Category.java:203) : : We are using following configuration: : log4j.appender.jdbc=org.apache.log4j.jdbcplus.JDBCAppender : log4j.appender.jdbc.url=jdbc:mysql://192.168.10.11/db?autoReconnect=true&tinyInt1isBit=false&useUnicode=true&characterEncoding=latin1&mysqlEncoding=latin1 : log4j.appender.jdbc.dbclass=com.mysql.jdbc.Driver : log4j.appender.jdbc.username=db : log4j.appender.jdbc.password=db : log4j.appender.jdbc.sql=INSERT INTO access_log (user_id, ip, action_type, object_id, created_utc) VALUES ('@MDC:userId@', '@MDC:ip@', '@MSG@', '@MDC:actionObjectId@', STR_TO_DATE('@LAYOUT@', '%d.%m.%Y %H:%i:%s')) : log4j.appender.jdbc.layoutPartsDelimiter=# : log4j.appender.jdbc.buffer=0 : log4j.appender.jdbc.commit=true : log4j.appender.jdbc.quoteReplace=true : log4j.appender.jdbc.Threshold=debug : log4j.appender.jdbc.layout=org.apache.log4j.PatternLayout : log4j.appender.jdbc.layout.ConversionPattern=%d{dd.MM.yyyy} %d{HH:mm:ss} : : Thanks!

Optionale URL:
Link Titel:
Optionale Bild-URL: