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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
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
