[logback-user] DBAppender issue

[Ceki Gülcü]

Hi Stephen,

You should use the DBAppender located in logback-classic. The fully 
qualified class name is ch.qos.logback.classic.db.DBAppender. The 
DBAppender you are using is from logback-access which does HTTP 
access-logging.

See also http://logback.qos.ch/manual/appenders.html#DBAppender

HTH
--
Ceki

On 06/06/2011 11:36 PM, Stephen Schaeffer wrote:
> <appender name="DB" class="ch.qos.logback.access.db.DBAppender">
> <connectionSource
> class="ch.qos.logback.core.db.DriverManagerConnectionSource">
> <driverClass>com.mysql.jdbc.Driver</driverClass>
> <url>jdbc:mysql://localhost:3306/logback_db</url>
> <user>logback</user>
> <password>logback</password>
> </connectionSource>
> </appender>
>
>
>
> On Jun 6, 2011, at 5:29 PM, Ceki Gülcü wrote:
>
>> On 06/06/2011 11:26 PM, Stephen Schaeffer wrote:
>>> java.lang.ClassCastException: ch.qos.logback.classic.spi.LoggingEvent
>>> cannot be cast to ch.qos.logback.access.spi.AccessEvent
>>> at ch.qos.logback.access.db.DBAppender.subAppend(DBAppender.java:36)
>>> at ch.qos.logback.core.db.DBAppenderBase.append(DBAppenderBase.java:107)
>>> at
>>> ch.qos.logback.core.UnsynchronizedAppenderBase.doAppend(UnsynchronizedAppenderBase.java:88)
>>> at
>>> ch.qos.logback.core.spi.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:64)
>>> at ch.qos.logback.classic.Logger.appendLoopOnAppenders(Logger.java:285)
>>> at ch.qos.logback.classic.Logger.callAppenders(Logger.java:272)
>>> at
>>> ch.qos.logback.classic.Logger.buildLoggingEventAndAppend(Logger.java:473)
>>> at ch.qos.logback.classic.Logger.filterAndLog_0_Or3Plus(Logger.java:427)
>>> at ch.qos.logback.classic.Logger.info(Logger.java:631)
>>>
>>> Steph
>>>
>>> On Jun 6, 2011, at 5:18 PM, Ceki Gülcü wrote:
>>>
>>
>> Thanks. Could you provide your configuration file as well?
>> --
>> Ceki
>> _______________________________________________
>> Logback-user mailing list
>> Logback-user at qos.ch <mailto:Logback-user at qos.ch>
>> http://qos.ch/mailman/listinfo/logback-user
>>
>
> *Stephen Schaeffer*
> IntercontinentalExchange | ICE
> 2100 RiverEdge Pkwy | 5th Floor | Atlanta, GA 30328
> Tel: 203.599.1881
> stephen.schaeffer at theice.com <mailto:stephen.schaeffer at theice.com>