Ah, I didn't look that closely at it. That would indeed be an issue.
On Jan 13, 2008 10:37 AM, Andrus Adamchik <andru..bjectstyle.org> wrote:
> > 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:48:17 EST