Eclipse Community Forums: EclipseLink » Validation exception on spurious insert during a query transaction

Home » Eclipse Projects » EclipseLink » Validation exception on spurious insert during a query transaction(Confusing insert during a transaction that simply loads and returns an object.)

Show: Today's Messages :: Show Polls :: Message Navigator

Validation exception on spurious insert during a query transaction [message #1062087]

Wed, 05 June 2013 20:12

Jon Whitney

Messages: 1
Registered: June 2013

Junior Member

Hi,

I'm pretty new to Eclipse Link, and I'm very confused by some of the behavior.

I'm using EL with Postgres, and Spring transactions. Here's a simplified version of my code:

1. The entity model

entity A
basic id
one-to-many B myBs

entity B
basic id

2. The sequence that succeeds

A myA = new A();

TransactionAction ta = new TransactionAction() {
public void doTransaction() {
em.persist(myA);
}
};

TransactinAction ta2 = new TransactionAction() {
public A doTransaction() {
String query = "select a from A a";
Query q = em.createQuery(query);
List list = q.getResultList();
return (A) list.get(0);
}
};

executeTransaction(ta);

A fromDB = executeTransaction(ta2);

3. The sequence that fails

If I do exactly the sequence above, but the "myA" object has an instance of B inside it. When I do that, I see an attempt to re-insert the instance of A when ta2 commits.

I'm very confused as to why, in a transaction that has simply loaded an object, there is an attempt to persist it at all. Notice that none of the code of ta2 does anything to persist the object, it's just loaded and returned.

Any help would be much appreciated!

Report message to a moderator

Re: Validation exception on spurious insert during a query transaction [message #1062256 is a reply to message #1062087]

Thu, 06 June 2013 18:26

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

How have you defined the A->B relationship, and is B inserted correctly or does it represent an existing entity? Is there a back reference from B to A? Do you set the id value or does it get generated through sequencing?

[Updated on: Thu, 06 June 2013 18:29]

Report message to a moderator

Previous Topic:	OnetoOne mapping issue
Next Topic:	Determine 'create' or 'update' Entity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 14:56:13 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter