Hello Morten, Could you please try using logback 0.9.11? It should be much more helpful in diagnosing the problems you are encountering. Morten Egelund Rasmussen wrote:
Hi all,
Does anybody have a working example on how to log to Oracle with a connection pool on a Tomcat server?
I have the following:
In Tomcat's server.xml:
<Resource name="jdbc/logger" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="foo" username="foo" password="foobar" maxActive="50" maxIdle="5" initialSize="10" maxWait="-1" removeAbandoned="true" validationQuery="select 1 from dual"/>
In Tomcat's context.xml:
<ResourceLink name="jdbc/logger" global="jdbc/logger" type="javax.sql.DataSource"/>
I have defined the following Logback appenders:
<appender name="db" class="myAppenderClass"> <connectionSource class="ch.qos.logback.core.db.JNDIConnectionSource"> <param name="jndiLocation" value="java:comp/env/jdbc/logger" /> </connectionSource> </appender>
<appender name="db2" class="myAppenderClass"> <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource"> <driverClass>oracle.jdbc.driver.OracleDriver</driverClass> <url>foo</url> <user>foo</user> <password>foobar</password> </connectionSource> </appender>
.....where "myAppenderClass" is an appender class as described here: http://jira.qos.ch/browse/LBCORE-15
Using the "db" appender gives nothing, but using the "db2" appender gives lots of output. What am I missing?
Any ideas?
~Morten :-/ _______________________________________________ Logback-user mailing list Logback-user@qos.ch http://qos.ch/mailman/listinfo/logback-user
-- Ceki Gülcü Logback: The reliable, generic, fast and flexible logging framework for Java. http://logback.qos.ch