log4j not closing database connections

From:

Dave V <dversch@patmedia.net>

Newsgroups:

comp.lang.java.programmer

Date:

Wed, 13 Jun 2007 13:54:47 -0700

Message-ID:

<1181768087.976328.138290@i38g2000prf.googlegroups.com>

Hi,

    I'm using log4j with a configuration file. I use it to log to a
database table. The logging works great. The only problem is that I
end up with a bunch of connections left open all the time. How can I
get these connections to close?

    My code looks like something this:

///////////////////////////////////////
public class myClass{
    private static Logger coSuccessLog = null ;
    private static Logger coErrorLog = null;

    public void logTest() throws Exception {

          try {
              InputStream boInputStream =
this.getClass().getResourceAsStream("/log4j_lai.properties");
              Properties boLog4jProps = new Properties();
              boLog4jProps.load(boInputStream);
              PropertyConfigurator.configure(boLog4jProps);
              coErrorLog =
Logger.getLogger("error."+this.getClass().getName());
              coSuccessLog =
Logger.getLogger("success."+this.getClass().getName());
              Class.forName("oracle.jdbc.OracleDriver");
          } catch (ClassNotFoundException ex) {
              throw ex;
          } catch (IOException ex) {
               throw ex;
          }

          coSuccessLog.info(new java.util.Date() + "made it into
logTest.");
    }
}

/////////////////////////////////////// The config file looks like
this:///////////////////////////////////
log4j.category.error=info, R
log4j.appender.R=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.R.URL=jdbc:oracle:thin:@qeweb.lordabbett.com:1521:qeweb
log4j.appender.R.user=mi
log4j.appender.R.password=mi
log4j.appender.R.sql=INSERT INTO LAI_ERROR_LOG (ERROR_LOG_ID,
APPLICATION, MSG, RECORD_TYPE, CREATED_DATE) VALUES
(LAI_ERROR_ID_SEQ.Nextval, 'LAISearch', '%m', 'E', SYSDATE)
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.category.success=info, S
log4j.appender.S=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.S.URL=jdbc:oracle:thin:@qeweb.lordabbett.com:1521:qeweb
log4j.appender.S.user=mi
log4j.appender.S.password=mi
log4j.appender.S.sql=INSERT INTO LAI_ERROR_LOG (ERROR_LOG_ID,
APPLICATION, MSG, RECORD_TYPE, CREATED_DATE) VALUES
(LAI_ERROR_ID_SEQ.Nextval, 'LAISearch', '%m', 'I', SYSDATE)
log4j.appender.S.layout=org.apache.log4j.PatternLayout
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    Anyone have a clue? Obviously I don't!

Thanks,
Dave