0 Replies Latest reply on Dec 12, 2004 7:56 PM by Craig Knell

    log4j jdbcAppender Configuration

    Craig Knell Newbie

      I am trying to add a new jdbcAppender to my default\conf\log4j.xml.

      I need to connect to Oracle 8i via Classes12.zip.

      I have tried putting the classes12.zip in a number of different directories to allow Log4j to access the database.

      The error i get is upon startup is:

      ==========================================================
      23:27:08,692 INFO [WebService] Using RMI server codebase: http://wsapp0120:8083/
      log4j error: Failed to excute sql
      java.sql.SQLException: No suitable driver
      at java.sql.DriverManager.getConnection(DriverManager.java:532)
      at java.sql.DriverManager.getConnection(DriverManager.java:171)
      at org.apache.log4j.jdbc.JDBCAppender.getConnection(JDBCAppender.java:197)
      at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:160)
      at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:235)
      at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:131)
      at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)
      at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderA
      ttachableImpl.java:57)
      at org.apache.log4j.Category.callAppenders(Category.java:187)
      at org.apache.log4j.Category.forcedLog(Category.java:372)
      at org.apache.log4j.Category.log(Category.java:864)
      at org.jboss.logging.Log4jLoggerPlugin.info(Log4jLoggerPlugin.java:160)
      at org.jboss.logging.Logger.info(Logger.java:171)
      at org.jboss.web.WebService.createService(WebService.java:293)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalCreate(ServiceMBeanSupport.ja
      va:238)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport
      .java:220)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja

      ====================================================


      Log4j.xml entries are :
      ==============================================







      <param name="ConversionPattern" value="INSERT INTO LOG (LOG_ID, TIMESTAMP, SERVER, MODULE_ID, COMPONENT, MODULE_SESSION_ID, DETAIL, DETAIL_NUMBER, DURATION, SEVERITY, LOG_TYPE_ID) VALUES ( SEQ_LOG_ID.NEXTVAL, SYSDATE, 'WSAPP', 2, '%F%L', '[%t]','%m', NULL, NULL, substr('%p',1,1), NULL)" />





      <appender-ref ref="CONSOLE" />
      <appender-ref ref="GDDLOG" />
      <appender-ref ref="FILE" />
      <appender-ref ref="App1Log" />



      Any suggestions greatly appreciated!

      Thanks