You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2012/10/25 21:21:13 UTC
[jira] [Commented] (CAY-1751) FK pointing to an UNIQUE field.
Problems to insert registers
[ https://issues.apache.org/jira/browse/CAY-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13484392#comment-13484392 ]
Andrus Adamchik commented on CAY-1751:
--------------------------------------
So I created a 3.1 project based on your 3.0 mapping (the parts we are talking about should be compatible), and switched from Oracle to Derby to simplify my environment. The error is reproducible in this setup... Next I did a small fix to the test, registering object before setting its relationship. Doesn't make much difference here I think, but just a good practice in general:
@@ -103,12 +104,10 @@ public class Main {
DataObject treeType = treeTypes.get(0);
DataObject enclosure = enclosures.get(0);
- DataObject fruitTree = new CayenneDataObject();
- fruitTree.setObjectId(new ObjectId("FruitTree"));
+ DataObject fruitTree = (DataObject) context.newObject("FruitTree");
fruitTree.writeProperty("plantingDate", new Date());
fruitTree.writeProperty("toEnclosure", enclosure);
fruitTree.writeProperty("toTreeType", treeType);
- context.registerNewObject(fruitTree);
At this point the error is still reproducible. Finally I changed the mapping to add "fake" PKs to 2 entities and specify which side is the master, and which is dependent:
diff --git a/src/main/resources/FieldDomainMap.map.xml b/src/main/resources/FieldDomainMap.map.xml
index e76fd96..530f8b2 100644
--- a/src/main/resources/FieldDomainMap.map.xml
+++ b/src/main/resources/FieldDomainMap.map.xml
@@ -14,7 +14,7 @@
</db-key-generator>
</db-entity>
<db-entity name="FRUIT_TREES">
- <db-attribute name="CODE_TYPE_TREE" type="NUMERIC" isMandatory="true" length="3"/>
+ <db-attribute name="CODE_TYPE_TREE" type="NUMERIC" isPrimaryKey="true" isMandatory="true" length="3"/>
<db-attribute name="ID_ENCLOSURE" type="NUMERIC" isMandatory="true" length="12"/>
<db-attribute name="ID_FRUIT_TREES" type="NUMERIC" isPrimaryKey="true" isMandatory="true" length="12"/>
<db-attribute name="PLANTING_DATE" type="DATE" isMandatory="true"/>
@@ -24,7 +24,7 @@
</db-key-generator>
</db-entity>
<db-entity name="TREE_TYPES">
- <db-attribute name="CODE_TYPE_TREE" type="NUMERIC" isMandatory="true" length="3"/>
+ <db-attribute name="CODE_TYPE_TREE" type="NUMERIC" isPrimaryKey="true" isMandatory="true" length="3"/>
<db-attribute name="DESCRIPTION_TYPE_TREE" type="VARCHAR" length="30"/>
<db-attribute name="ID_TREE_TYPE" type="NUMERIC" isPrimaryKey="true" isMandatory="true" length="12"/>
<db-key-generator>
@@ -51,7 +51,7 @@
<db-relationship name="toTreeType" source="FRUIT_TREES" target="TREE_TYPES" toMany="false">
<db-attribute-pair source="CODE_TYPE_TREE" target="CODE_TYPE_TREE"/>
</db-relationship>
- <db-relationship name="toFruitTree" source="TREE_TYPES" target="FRUIT_TREES" toMany="true">
+ <db-relationship name="toFruitTree" source="TREE_TYPES" target="FRUIT_TREES" toDependentPK="true" toMany="true">
<db-attribute-pair source="CODE_TYPE_TREE" target="CODE_TYPE_TREE"/>
</db-relationship>
<obj-relationship name="toFruitTree" source="Enclosure" target="FruitTree" db-relationship-path="toFruitTree"/>
--
This fixed the problem. The following SQL is generated in the last commit:
INFO: INSERT INTO "FRUIT_TREES" ("CODE_TYPE_TREE", "ID_ENCLOSURE", "ID_FRUIT_TREES", "PLANTING_DATE") VALUES (?, ?, ?, ?)
INFO: [batch bind: 1->CODE_TYPE_TREE:1, 2->ID_ENCLOSURE:200, 3->ID_FRUIT_TREES:200, 4->PLANTING_DATE:'2012-10-25 22:13:46.071']
> FK pointing to an UNIQUE field. Problems to insert registers
> ------------------------------------------------------------
>
> Key: CAY-1751
> URL: https://issues.apache.org/jira/browse/CAY-1751
> Project: Cayenne
> Issue Type: Improvement
> Components: Core Library, Database integration
> Affects Versions: 3.0.2
> Environment: Eclipse + Java 5 + Junit + Cayenne 3.0.2 (Generic Persistent Class) + Oracle 10g Database
> Reporter: Felipe Martín Santos
> Priority: Minor
> Labels: features, patch
> Fix For: 3.0.2, 3.1 (final)
>
> Attachments: cay1751.tar.gz, cayenne.xml, FieldDomainMap.map.xml, FieldDomainNode.driver.xml, fruits.sql, FruitTest.java
>
>
> I need insert a new record and the table where insert have 2 FK not null:
> If I relate TABLE_A (FK) with TABLE_B (PK) Cayenne works well but if the relationship is between TABLE_A (FK) with TABLE_C (An UNIQUE field), cayenne can´t extract de value of that UNIQUE value, and the insert sentence generated live that field null and I get next error:
> java.sql.SQLIntegrityConstraintViolationException: ORA-01400. Can not perform an insert NULL
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira