Re: Logging changes?

From: Michael Gentry (blacknex..mail.com)
Date: Sun Jan 13 2008 - 10:30:42 EST

  • Next message: Andrus Adamchik: "Re: Logging changes?"

    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:31:14 EST