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=bbop=viewtopicp=3858296#3858296
Reply to the post :
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=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