Hi James, As you suggested, I've written some JDBC code to insert a record and it does NOT hang. The response is very fast.
So it seems like it's a JDBCAppender-related thing only. Any ideas on what might be happening here or how I can investigate further? ( I urgently need to solve this -- it's running on a live production system. )-: Frank. ----- Original Message ----- From: "James Stauffer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 15, 2004 9:29 PM Subject: RE: Strange behaviour with JDBCAppender -- long time lags before control returns to code > If you write your own JDBC code to insert a record does it hang that long? > > -----Original Message----- > From: Frank Burns [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 15, 2004 9:54 AM > To: [EMAIL PROTECTED] > Subject: Strange behaviour with JDBCAppender -- long time lags before > control returns to code > > > Hi, > > Can anyone shed some light on what might be happening here? > > I was using the JDBCAppender that comes with log4j 1.2.8 to perform logging > to database tables. > > This worked well except if no logging events occurred for some time then the > database logging ceased. I believe this was because the connection to the > database was timing out. > > In an attempt to cure this I used the JDBCAppender from Thomas Fenner and > updated by Danko Mannhaupt -- see . > > This now works fine for my app running on my development linux installation, > where it is logging to a mySQL database located on the same machine. > > However, on the live linux implementation, where the database is on a > different server, when no events occur for some time, the logging to the > database still takes place immediately (the timestamp logged in the database > shows this) BUT it takes up to FIFTEEN MINUTES for control to return to the > code following this logging statement > > successfulLoginLogger.info(username.toUpperCase() + " logged in."); > > Any ideas what's happening and how to solve it? > > Thanks. > > Frank Burns. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]