Logback DBAppender url

Posted by pedro mendes on Stack Overflow See other posts from Stack Overflow or by pedro mendes
Published on 2010-03-31T14:10:56Z Indexed on 2010/03/31 14:13 UTC
Read the original article Hit count: 838

Filed under:
|

I'm trying to use Logback's DBAppender. My logback.xml has the following appender:

</appender>
    <appender name="DatabaseAppender" class="ch.qos.logback.classic.db.DBAppender">
        <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">
            <driverClass>oracle.jdbc.OracleDriver</driverClass>
            <url>jdbc:oracle:thin:@URL:PORT:SERVICEID</url>
            <user>USER</user>
            <password>PASS</password>
    </connectionSource>
</appender>

the url given works with other java classes in the same project but it fails with logback giving the following error

ORA-00904: "ARG3": invalid identifier

        at java.sql.SQLException: ORA-00904: "ARG3": invalid identifier

where ARG3 is the <url>jdbc:oracle:thin:@URL:PORT:SERVICEID</url>

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about logback