[
https://issues.apache.org/jira/browse/CAY-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13486110#comment-13486110
]
Felipe Martín Santos commented on CAY-1751:
-------------------------------------------
Ok, I've tested with both: the proposed example and my real code... Now I can
insert records in the database. :-) Thank you very very very much....
But now I've a problem when I get a FruiTree Object from the database. If I
navigate to Enclosure.... There's not a problem, but when I navigate to
TreeTypes.... ERROR oooooops!!
Here the code:
SelectQuery treeQuery = new SelectQuery("FruitTree");
List<DataObject> trees = context.performQuery(treeQuery);
DataObject tree = trees.get(0);
DataObject enclosure = (DataObject)tree.readProperty("toEnclosure");
Object description = enclosure.readProperty("descriptionEnclosure");
DataObject treeType = (DataObject)tree.readProperty("toTreeType");
Object codeTreeType = treeType.readProperty("codeTypeTree"); // here comes the
error
Object descriptionTreeType = treeType.readProperty("descriptionTypeTree");
org.apache.cayenne.FaultFailureException: [v.3.0.2 Jun 11 2011 09:26:09] Error
resolving fault for ObjectId: <ObjectId:TreeType, CODE_TYPE_TREE=1> and state
(hollow). Possible cause - matching row is missing from the database.
at org.apache.cayenne.BaseContext.prepareForAccess(BaseContext.java:171)
at
org.apache.cayenne.CayenneDataObject.readProperty(CayenneDataObject.java:219)
at
org.apache.cayenne.CayenneDataObject.readSimpleProperty(CayenneDataObject.java:203)
at
org.apache.cayenne.CayenneDataObject.readNestedProperty(CayenneDataObject.java:132)
at
org.apache.cayenne.CayenneDataObject.readNestedProperty(CayenneDataObject.java:154)
at
es.juntadeandalucia.agapa.gis.ide.dataset.sigpac.test.FruitTest.test(FruitTest.java:150)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at
org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
at
org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
> 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
> 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
