[logback-user] DbAppender does not write log messages to Oracle

[Sumanth Donthi]

Ceki,

Thanks for the reply. I get the following exception. DBAppenderBase.java(line 
99) points me to EVENT_ID column in DB. I've used oracle.sql dialect found under
logback-0.9.27\logback-classic\src\main\java\ch\qos\logback\classic\db\dialect 
directory.

---------------------------------------------------------------------------------------------------------------------------------

09:19:09,951 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - 
Adding ReconfigureOnChangeFilter as a turbo filter
09:19:09,951 |-INFO in ch.qos.logback.core.joran.action.StatusListenerAction - 
Adding status listener of type 
[ch.qos.logback.core.status.OnConsoleStatusListener]
09:19:09,951 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About 
to instantiate appender of type [ch.qos.logback.classic.db.DBAppender]
09:19:09,966 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming 
appender as [DB2]
09:19:13,326 |-INFO in 
ch.qos.logback.core.db.DriverManagerConnectionSource at 3a763a76 - Driver 
name=Oracle JDBC driver
09:19:13,326 |-INFO in 
ch.qos.logback.core.db.DriverManagerConnectionSource at 3a763a76 - Driver 
version=11.1.0.7.0-Production
09:19:13,326 |-INFO in 
ch.qos.logback.core.db.DriverManagerConnectionSource at 3a763a76 - 
supportsGetGeneratedKeys=true
09:19:13,326 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - 
Setting level of ROOT logger to TRACE
09:19:13,326 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - 
Attaching appender named [DB2] to Logger[ROOT]
09:19:13,326 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - 
End of configuration.

09:19:15,998 |-ERROR in ch.qos.logback.classic.db.DBAppender[DB2] - problem 
appending event java.lang.ArrayIndexOutOfBoundsException: Array index out of 
range: 14
at java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 14
at at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
at at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
at at 
oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)

at at 
oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
at at 
oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)

at at 
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)

at at 
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)

at at 
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)

at at ch.qos.logback.core.db.DBAppenderBase.append(DBAppenderBase.java:99)
at at 
ch.qos.logback.core.UnsynchronizedAppenderBase.doAppend(UnsynchronizedAppenderBase.java:88)

at at 
ch.qos.logback.core.spi.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:64)

at at ch.qos.logback.classic.Logger.appendLoopOnAppenders(Logger.java:285)
at at ch.qos.logback.classic.Logger.callAppenders(Logger.java:272)
at at ch.qos.logback.classic.Logger.buildLoggingEventAndAppend(Logger.java:473)
at at ch.qos.logback.classic.Logger.filterAndLog_0_Or3Plus(Logger.java:427)
at at ch.qos.logback.classic.Logger.info(Logger.java:631)
at at com.boeing.siai.lf4j.impl.AIAudit.audit(AIAudit.java:63)
at at com.boeing.siai.lf4j.test.AITester.main(AITester.java:35)
09:19:18,591 |-ERROR in ch.qos.logback.classic.db.DBAppender[DB2] - problem 
appending event java.lang.ArrayIndexOutOfBoundsException: Array index out of 
range: 14

------------------------------------------------------------------------------------------------------------------------------------



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://qos.ch/pipermail/logback-user/attachments/20110113/eb1adc97/attachment.html>