Error when persisting deep object graph
---------------------------------------
Key: OPENJPA-1805
URL: https://issues.apache.org/jira/browse/OPENJPA-1805
Project: OpenJPA
Issue Type: Bug
Affects Versions: 2.0.1
Environment: Windows XP SP3, Postgres database
Reporter: Rade Martinović
I have following model:
*Report*,
*ReportSection* and
*ReportSectionProperty*.
*Report* has zero to many *ReportSections*, *ReportSection* has zero to many
*ReportSectionPropert*-ies. This would qualifie as three levels deep object
graph.
I create new *Report*, then add some sections to it, then add some properties
to it. When I try to persist *Report*, I get following error:
<pre><code>Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR:
insert or update on table "report_section" violates foreign key constraint
"fk_report_section_report"
Detail: Key (id_node)=(186) is not present in table "report". {prepstmnt
20859482 INSERT INTO core.report_section (index_section, name,
report_section_type, id_node) VALUES (?, ?, ?, ?) [params=?, ?, ?, ?]} [code=0,
state=23503]</code></pre>
So, OpenJPA is persisting object graph, but somehow it started from the middle.
id_node 186 is indeed the next id of the Report table but, obviously that
object is not saved when ReportSection is being saved.
If I put em.persist(report) then em.flush() between each operation of adding
sections or properties, everything works. Is this the way to go?
If I don't add any properties to sections, persisting Report works, even
without em.flush().
I use OpenJPA 2.0.1 as JPA provider.
----------
Maybe some relevant parts of the code:
Report.java
<pre><code>public class Report{
@OneToMany(targetEntity = ReportSection.class, cascade =
CascadeType.ALL, mappedBy="report")
private List<ReportSection> reportSections;
public void addReportSection(ReportSection section){
synchronized (this) {
if (getReportSections() == null)
reportSections = new ArrayList<ReportSection>();
reportSections.add(section);
section.setReport(this);
}
}
}</code></pre>
ReportSection.java
<pre><code>public class ReportSection{
@ManyToOne
@JoinColumn(name="id_node")
private Report report;
@OneToMany(targetEntity=ReportSectionProperty.class,
cascade=CascadeType.ALL, mappedBy="reportSection")
private List<ReportSectionProperty> reportSectionProperties;
public void setReport(Report report) {
this.report = report;
}
public void addReportSectionProperty(ReportSectionProperty
reportSectionProperty){
synchronized (this) {
if (getReportSectionProperties() == null)
reportSectionProperties = new
ArrayList<ReportSectionProperty>();
reportSectionProperties.add(reportSectionProperty);
reportSectionProperty.setReportSection(this);
}
}
}<code></pre>
ReportSectionProperty
<pre><code>public class ReportSectionProperty{
@ManyToOne(cascade=CascadeType.ALL)
@JoinColumn(name="id_report_section")
private ReportSection reportSection;
public void setReportSection(ReportSection reportSection) {
this.reportSection = reportSection;
}
}<code></pre>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
