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

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@3a763a76 - Driver name=Oracle JDBC driver 09:19:13,326 |-INFO in ch.qos.logback.core.db.DriverManagerConnectionSource@3a763a76 - Driver version=11.1.0.7.0-Production 09:19:13,326 |-INFO in ch.qos.logback.core.db.DriverManagerConnectionSource@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 ------------------------------------------------------------------------------------------------------------------------------------
participants (1)
-
Sumanth Donthi