> 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