[logback-user] Problem with JNDIConnectionSource

[Andreas Zielke]

Hi *,

I apologize, if this get's posted twice. My first post (through
Nabble) shows up in Nabble, but I got a "You may not post" message.

Anyway, I'm trying to get logback (0.9.24) to log to my Oracle
Database (11g) from an Enterprise Application running on an Oracle
Weblogic (11g).

I'm getting the following error:

2010-09-23 11:25:34      INFO      LoggerContext      Could NOT find
resource [logback.groovy]
2010-09-23 11:25:34     INFO     LoggerContext     Could NOT find
resource [logback-test.xml]
2010-09-23 11:25:34     INFO     LoggerContext     Found resource
[logback.xml] at
[file:/export/home/zielk_an/workspace_produktion_trunk/trunk/base/project_base/bin/logback.xml]
2010-09-23 11:25:34     INFO     ConfigurationAction     debug attribute not set
2010-09-23 11:25:34     INFO     AppenderAction     About to
instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
2010-09-23 11:25:34     INFO     AppenderAction     Naming appender as [STDOUT]
2010-09-23 11:25:34     INFO     NestedComplexPropertyIA     Assuming
default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for
[encoder] property
2010-09-23 11:25:34     INFO     NestedComplexPropertyIA     Pushing
component [encoder] on top of the object stack.
2010-09-23 11:25:34     INFO     AppenderAction     About to
instantiate appender of type [ch.qos.logback.classic.db.DBAppender]
2010-09-23 11:25:34     INFO     AppenderAction     Naming appender as [DB]
2010-09-23 11:25:34     INFO     NestedComplexPropertyIA     Pushing
component [connectionSource] on top of the object stack.
2010-09-23 11:25:34     INFO     JNDIConnectionSource     Driver
name=Oracle JDBC driver
2010-09-23 11:25:34     INFO     JNDIConnectionSource     Driver
version=11.1.0.7.0-Production
2010-09-23 11:25:34     INFO     JNDIConnectionSource
supportsGetGeneratedKeys=true
2010-09-23 11:25:34     INFO     RootLoggerAction     Setting level of
ROOT logger to DEBUG
2010-09-23 11:25:34     INFO     AppenderRefAction     Attaching
appender named [STDOUT] to Logger[ROOT]
2010-09-23 11:25:34     INFO     AppenderRefAction     Attaching
appender named [DB] to Logger[ROOT]
2010-09-23 11:25:41     ERROR     DBAppender     problem appending event

java.sql.SQLException: prepareStatement, Exception = 14
    at weblogic.jdbc.wrapper.XAConnection.invocationExceptionHandler(XAConnection.java:190)
    at weblogic.jdbc.wrapper.XAConnection.prepareStatement(XAConnection.java:1113)
    at weblogic.jdbc.common.internal.ConnectionEnv.makeStatement(ConnectionEnv.java:1361)
    at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:1114)
    at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:793)
    at ch.qos.logback.core.db.DBAppenderBase.append(DBAppenderBase.java:99)
    at ch.qos.logback.core.UnsynchronizedAppenderBase.doAppend(UnsynchronizedAppenderBase.java:91)
    at ch.qos.logback.core.spi.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:64)
    at ch.qos.logback.classic.Logger.appendLoopOnAppenders(Logger.java:283)
    at ch.qos.logback.classic.Logger.callAppenders(Logger.java:270)
    at ch.qos.logback.classic.Logger.buildLoggingEventAndAppend(Logger.java:471)
    at ch.qos.logback.classic.Logger.filterAndLog_0_Or3Plus(Logger.java:425)
    at ch.qos.logback.classic.Logger.info(Logger.java:629)

Has anyone experienced similar problems? Could it be related to the
weblogic JDBC wrapper?

Any help is appreciated & thanks for any hints.

Kind regards,
  Andreas