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 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3858296#3858296 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3858296 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
