Re: Logging changes?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sun Jan 13 2008 - 10:37:41 EST

  • Next message: Andrus Adamchik (JIRA): "[JIRA] Closed: (CAY-716) DataContext.rollbackChangesLocally() is not implemented for nested DataContexts"

    > HSQLDB 1.8 has an identity column. To quote the documentation,
    > "Identity columns are autoincrement columns."

    As an aside, last time I checked, the generated values were not passed
    back via the java.sql.Statement.getGeneratedKeys() - the method we
    rely upon to init ObjectId's on commit. Maybe worth checkin again...

    Andrus

    On Jan 13, 2008, at 5:30 PM, Michael Gentry wrote:

    > HSQLDB 1.8 has an identity column. To quote the documentation,
    > "Identity columns are autoincrement columns."
    >
    > I'll look at Derby. Thanks!
    >
    >
    > On Jan 13, 2008 10:28 AM, Andrus Adamchik <andru..bjectstyle.org>
    > wrote:
    >> MySQL. But you can try Derby - it supports autoincremented PK (while
    >> HSQLDB does not).
    >>
    >> Andrus
    >>
    >>
    >> On Jan 13, 2008, at 5:13 PM, Michael Gentry wrote:
    >>
    >>> What database are you using? I'm guessing MySQL? I was trying to
    >>> set
    >>> up HSQLDB, but the modeler doesn't generate the SQL to use identity
    >>> columns so I'm not certain if Cayenne supports identity columns with
    >>> it? I suppose I can install MySQL later (I normally use
    >>> PostgreSQL).
    >>> I had MySQL running before upgrading to Leopard, which broke it.
    >>>
    >>> Thanks,
    >>>
    >>> /dev/mrg
    >>>
    >>> On Jan 2, 2008 11:41 AM, Andrus Adamchik <andru..bjectstyle.org>
    >>> wrote:
    >>>> Found one issue with the new logging today - insert queries with
    >>>> auto
    >>>> incremented PK incorrectly shift the labels to include the PK.
    >>>> E.g.,
    >>>> assuming auto-increment PK column name is "C2":
    >>>>
    >>>> INSERT INTO mytable (C1, C3, C4) VALUES (?, ?, ?)
    >>>> [bind: 1->C1:V1, 2->C2:V3, 3->C3:V4]
    >>>>
    >>>> At position #2, the PK label that is not used in the statement
    >>>> SQL is
    >>>> shown, and from there, all the values are off by one position.
    >>>>
    >>>> Andrus
    >>>>
    >>>>
    >>>>
    >>>> On Dec 28, 2007, at 5:07 PM, Michael Gentry wrote:
    >>>>
    >>>>> That's what I was hoping. Thanks for the update!
    >>>>>
    >>>>> /dev/mrg
    >>>>>
    >>>>> On Dec 28, 2007 9:53 AM, Andrus Adamchik <andru..bjectstyle.org>
    >>>>> wrote:
    >>>>>> I deployed this in production some time back. I am really happy
    >>>>>> with
    >>>>>> the new format - makes log analysis much easier.
    >>>>>>
    >>>>>> Cheers,
    >>>>>> Andrus
    >>>>>>
    >>>>>>
    >>>>>> On Nov 30, 2007, at 4:39 AM, Michael Gentry wrote:
    >>>>>>
    >>>>>>> Changes are checked in. Please let me know if you have
    >>>>>>> problems,
    >>>>>>> etc.
    >>>>>>>
    >>>>>>> Thanks,
    >>>>>>>
    >>>>>>> /dev/mrg
    >>>>>>>
    >>>>>>
    >>>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>
    >>
    >



    This archive was generated by hypermail 2.0.0 : Sun Jan 13 2008 - 10:38:13 EST