[logback-dev] [Bug 57] 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


nojspam at losgibsons.us changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |nojspam at losgibsons.us




------- Comment #3 from nojspam at losgibsons.us  2008-01-11 05:16 -------
I think that we can fix this problem by making different prepareStatement()
calls in DBAppenderBase depending upon the value of
cnxSupportsGetGeneratedKeys.
For example, this seemed to fix the problem for me with Oracle 10:

PreparedStatement insertStatement;
if(cnxSupportsGetGeneratedKeys) {
  insertStatement = connection
      .prepareStatement(getInsertSQL(), new String[] { "EVENT_ID" } );
} else {
  insertStatement = connection
      .prepareStatement(getInsertSQL());
}


-- 
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.