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

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Feb 10 2004 - 23:58:07 EST

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

    Mike,

    UtilDateType and its Oracle-specific subclass - OracleUtilDateType -
    maybe a suspect here. Try commenting out this line from your local
    version of OracleAdapter.java:

      map.registerType(new OracleUtilDateType());

    I am not completely sure that it has anything to do with your problems,
    but it is worth a try.

    Andrus

    On Feb 10, 2004, at 8:18 PM, Mike Kienenberger wrote:
    > 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.

    This archive was generated by hypermail 2.0.0 : Tue Feb 10 2004 - 23:58:13 EST