[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] Order of mapping initialization error in EclipseLink 2.3?
|
Hi Tom,
I've filed the bug report:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=347010
Thanks for the help!
- Zeb
On 05/24/2011 04:57 PM, Tom Ware wrote:
Hi Zeb,
Thanks for the recreation. I can see the problem now. Please file
a bug and attach the recreation.
In your example, I can workaround the problem by explicitly severing
the relationship.
e.g.
em = factory.createEntityManager();
tx = em.getTransaction();
tx.begin();
a = em.find(A.class, id);
b = em.find(A.class, id2);
a.remove(b);
em.remove(a);
em.remove(b);
-Tom
Zeb Ford-Reitz wrote:
I managed to isolate the problem in a simple example (source code
attached). I used an H2 database for my test. When using EclipseLink
2.2 the example runs as expected (or at least I don't see any error
messages), but with EclipseLink 2.3 I receive the "Referential
integrity constraint violation" message that I mentioned earlier.
Please let me know if there's anything more I can do to help isolate
and fix this bug, as we are hoping to see it fixed or to have a
workaround for Eclipse's Indigo release.
- Zeb
On 05/20/2011 03:44 PM, Tom Ware wrote:
Finally got a chance to look at the logging. It's pretty hard to
tell what is going on. It looks like you are doing a bunch more
than just adding/removing in this code and you have a bunch more
mappings than just the ones you describe below.
Is it possible to isolate the case to just include the mappings you
are describing? i.e. Ideally only populate the part of the object
that includes the problem and show me the SQL resulting from that
population and from the remove called on that object.
The other mappings involved in this can have an impact on the order
of the SQL and potentially what happens at predelete. That is why
it would be ideal to have something as specific as possible.
-Tom
Zeb Ford-Reitz wrote:
I've attached the snippets to this mail. Sorry that the "add" log
is so huge. I was unsure of exactly where the important data starts
and ends, so I left it pretty much as-is so that there would be no
missing information.
Thanks for looking into this.
On 05/18/2011 02:07 PM, Tom Ware wrote:
Can you please turn on FINEST logging and send the snippet of
logging that occurs when you add ExecTestCasePO to a
SpectTestCasePO and the snippet of logging that occurs starting at
the remove, through to the exception.
- to set logging, set persistence unit property
eclipselink.logging.level to FINEST
Zeb Ford-Reitz wrote:
A description with some code is easier for the moment. I'm
experiencing the problem in the Eclipse project Jubula (see
https://bugs.eclipse.org/bugs/show_bug.cgi?id=345106), so maybe
that could count as a recreation (although it's far from small or
automated). We're using JPA 2.0 with annotations in an OSGi
environment.
The root of a class hierarchy is the NodePO class, which has a
unidirectional list of children:
@ManyToMany(fetch = FetchType.EAGER,
cascade = CascadeType.ALL,
targetEntity = NodePO.class)
@JoinTable(name = "NODE_LIST",
joinColumns = @JoinColumn(name = "PARENT"),
inverseJoinColumns = @JoinColumn(name = "CHILD"))
@OrderColumn(name = "IDX")
List<INodePO> getHbmNodeList() {
return m_nodeList;
}
I am attaching an image of the class hierarchy for NodePO. In
this hierarchy are the classes SpecTestCasePO (NodePO ->
ParamNodePO -> TestCasePO -> SpecTestCasePO) and ExecTestCasePO
(NodePO -> ParamNodePO -> TestCasePO -> ExecTestCasePO). This is
the multiple levels of inheritance that I was talking about.
I can successfully add an ExecTestCasePO to a SpectTestCasePO's
node list and persist those changes. I can also successfully call
EntityManager.remove(). However, an attempt to commit the removal
causes a foreign key violation in NODE_LIST.
Thanks for your time. Please let me know if you need more
information.
On 05/17/2011 08:03 PM, Tom Ware wrote:
I am not aware of an existing problem. Can you provide us with
more information? (ideally an recreation, but otherwise a
description of your class structure, the mappings and the code
you are running)
Zeb Ford-Reitz wrote:
Hello,
I'm encountering a problem with EclipseLink 2.3 RC1 that I did
not encounter in EclipseLink 2.2.
The problem involves multiple levels of inheritance and
"preDeleteMappings". The resulting error is a foreign key
violation in a join table when committing the removal an entity
with a ManyToMany association.
The source of the problem seems to be missing
preDeleteMappings, which would remove the necessary entry from
the join table before removing the entity itself. Essentially,
the order in which the mappings are initialized (and
post-initialized) causes several of our entites to contain the
preDeleteMappings from their corresponding direct parents, but
*not* from all of their ancestors.
Is this a known issue? If so, is it expected to be fixed in the
near future? If not, can anyone suggest a workaround?
Thanks for your time.
With best regards,
Zeb Ford-Reitz
------------------------------------------------------------------------
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
------------------------------------------------------------------------
------------------------------------------------------------------------
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
------------------------------------------------------------------------
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
------------------------------------------------------------------------
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
--
BREDEX GmbH
Mauernstr. 33
38100 Braunschweig
Tel.: +49-531-24330-0
Fax: +49-531-24330-99
http: www.bredex.de
Geschäftsführer: Hans-J. Brede, Achim Lörke, Ulrich Obst
Amtsgericht Braunschweig HRB 2450
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature