[logback-user] Logback Oracle problem.

[Søren Davidsen]

Hi List,

I am using logback 0.9.7, and having problems with getting logged into an Oracle database using the DBAppender.

I am using c3p0 as a datasource like this, and the tables are created as per the provided .sql files from the distribution:

        <appender name="DATABASE" class="ch.qos.logback.classic.db.DBAppender">
               <connectionSource class="ch.qos.logback.core.db.DataSourceConnectionSource">
                        <dataSource class="com.mchange.v2.c3p0.ComboPooledDataSource">
                                <driverClass>oracle.jdbc.OracleDriver</driverClass>
                                <jdbcUrl>jdbc:oracle:thin:@xxx:yy:ZZ</jdbcUrl>
                                <user>ppppp</user>
                                <password>qqqqqq</password>
                                <param name="acquireRetryAttempts" value="1" />
                                <param name="acquireIncrement" value="1" />
                                <param name="minPoolSize" value="1" />
                                <param name="maxPoolSize" value="2" />
                                <param name="maxConnectionAge" value="600" />
                        </dataSource>
                </connectionSource>
        </appender>

It works very sporadic, only some log-statements are put into the database (I have not yet found any pattern in which), and exceptions are never put into logging_event_exceptions

Is there something I need to do or something else I'm missing?

Thanks,
Soren