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

bugzilla-daemon at pixie.qos.ch bugzilla-daemon at pixie.qos.ch
Fri Jan 11 05:16:31 CET 2008


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.



More information about the logback-dev mailing list