SQL Code 803 - Multiple identical entries to insert whith ForeignKey Annotation
in Batch Flush with hierarchical self-reference
-------------------------------------------------------------------------------------------------------------------------------
Key: OPENJPA-1878
URL: https://issues.apache.org/jira/browse/OPENJPA-1878
Project: OpenJPA
Issue Type: Bug
Components: kernel
Affects Versions: 2.0.1
Environment: DB2 9.5 / LUW
Reporter: Johannes Mathes
Hi there,
I'm having trouble persisting an hierarchy:
I have an Entity TestDefinition which is hierarchical (tree). So there is a
root, e.g. ROOT and a child CHILD and a GRANDCHILD, forming a hierarchy:
ROOT->CHILD->GRANDCHILD.
The Entitiy has an optional foreign key relationship to its parent.
At the beginning I create the hierarchy and then attach the entries to the
entity manager via merge. The database knows the foreign key constraints and
enforces them. This is why I added the ForeignKey Tag to the parent-Attribute.
When I flush or commit, I get an sql code 803 and I can see that the batch
manager wants to insert the root multiple times! It seems that the engine is
confused by the hierarchy and does not know that the root has been allready
attached.
I see this multiple inserting also for other nodes, not just the root (in fact,
I have a bit deeper hierarchy as stated here).
The entity is definied as follows:
@Id
@Column(name = "TESD_ID", length = 255)
private String definition;
@ForeignKey
@ManyToOne(cascade = CascadeType.ALL, optional = true)
@Column(name = "TESD_PARENT_ID", length = 255)
private TestDefinition parent;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
