[logback-dev] [Bug 57] New: Problems getting autogenerated Keys in Oracle with Oracle JDBC 10.2.03

[bugzilla-daemon at pixie.qos.ch]

http://bugzilla.qos.ch/show_bug.cgi?id=57

           Summary: Problems getting autogenerated Keys in Oracle with
                    Oracle JDBC 10.2.03
           Product: logback-core
           Version: unspecified
          Platform: PC
        OS/Version: Windows
            Status: NEW
          Severity: critical
          Priority: P1
         Component: Appender
        AssignedTo: logback-dev at qos.ch
        ReportedBy: klaus at ungers-online.com


I've encountered troubles logging StackTrace/MDC entries with die DBAppender on
our plattform! We are using Oracle 9.2.0.6.0 on a Solaris Box with Oracle JDBC
Driver 10.2.0.3!

I've debugged the processing of LogMessages into DBAppenderBase.append()!

There I found a call "con.prepareStatement(getInsertSQL())" which is followed
by a call "subAppend(...)"

As far as I understand Oracle Drivers return generatedKeys only, if you use the
right prepareStatement() methods, which is in my understanding the following:

PreparedStatement prepareStatement(String sql, int autoGeneratedKeys)
                                   throws SQLException
@see
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#prepareStatement(java.lang.String,%20int)
which is available since JDK 1.4


-- 
Configure bugmail: http://bugzilla.qos.ch/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.