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