FAQ
Inserting new record in table with PK columns of UUID and trigger to generate new UUIDs
---------------------------------------------------------------------------------------

Key: CAY-747
URL: https://issues.apache.org/cayenne/browse/CAY-747
Project: Cayenne
Issue Type: Improvement
Components: Cayenne Core Library
Affects Versions: 2.0 [STABLE]
Environment: Windows XP, NetBeans 5.0, MySQL 5.0
Reporter: Heino Grøndahl Sørensen
Priority: Minor


I have a table with a primary key column containing UUIDs, represented as strings in the database.
I have added a trigger on before insert to create a new UUID, using the UUID() function.
I have set the PK Generation Stategy to Database-Generated and the Auto-incremented is set to the name of the column.
When I insert a new record into the table I get an exception on commitChanges.
Here is an bit of the stack trace.

org.apache.cayenne.CayenneRuntimeException: [v.2.0.2 January 14 2007] One and only one PK row is expected, instead got 0
at org.apache.cayenne.access.DataDomainFlushObserver.nextGeneratedDataRows(DataDomainFlushObserver.java:87)
at org.apache.cayenne.access.DataNodeQueryAction.nextGeneratedDataRows(DataNodeQueryAction.java:79)
at org.apache.cayenne.access.jdbc.BatchAction.processGeneratedKeys(BatchAction.java:265)
at org.apache.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(BatchAction.java:208)
at org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:81)
at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:59)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:273)
at org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:219)
at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:141)
at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:794)
at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:765)
at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:820)
at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:762)
at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1226)
at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1130)

If I look in the actual table in the database, the record is there (!).
Seems like the trigger-assigned UUID is not read from the database.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedFeb 7, '07 at 8:30p
activeFeb 7, '07 at 8:30p
posts1
users1
websitecayenne.apache.org

People

Translate

site design / logo © 2021 Grokbase