Optimistic Locking Progress report 5 - problems with Oracle 9i DATE/TIMESTAMP lockings

From: Mike Kienenberger (mkienen..laska.net)
Date: Tue Feb 10 2004 - 20:18:09 EST

  • Next message: Andrus Adamchik: "Re: Optimistic Locking Progress report 5 - problems with Oracle 9i DATE/TIMESTAMP lockings"

    I now have optimistic locking working with both Oracle and OpenBase.
    The downsides are that it works only by running batch updates as individual
    queries since Oracle prepared statement sql depends on the nullity of the
    data.

    The other problem I'm still having is that it doesn't work well with DATE or
    TIMESTAMP db-types (sql types 91 and 93). For OpenBase, this is expected
    since there's some bugs with OpenBase date types.

    However, I can't explain away the issues with Oracle and DATE/TIMESTAMP
    columns. Sometimes they work. Sometimes they don't. Disabling optimistic
    locking on those fields always works. I originally had the columns marked
    as DATE, but have switched them to TIMESTAMP with only moderate
    improvements.

    I'm connecting to

    Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.2.0 - Production

    And using the

    Oracle9i 9.2.0.3 JDBC Driver for JDK1.4

    Any ideas?

    -Mike

    This archive was generated by hypermail 2.0.0 : Tue Feb 10 2004 - 20:18:13 EST