Eclipse Community Forums: EclipseLink

Home » Eclipse Projects » EclipseLink » EclipseLink-48(Multiple writable mappings exist for the field)

Wed, 12 September 2012 01:59

Eclipse User

Hi,
I have the following:

@Embeddable
public final class Oid {
private byte[] oid;
}

public abstract class Base {

@EmbeddedId
private Oid oid;

}

@Entity
public class A extends Base {

private String txt1;
private String txt2;

@OneToOne(cascade = CascadeType.ALL)
@PrimaryKeyJoinColumn
private B aB;

}

@Entity
public class B extends Base {

private String msg1;
private String msg2;

}

What do I need to fix for not getting the following error:

Exception [EclipseLink-48] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DescriptorException
Exception Description: Multiple writable mappings exist for the field [TSI01_A.OID]. Only one may be defined as writable, all others must be specified read-only.
Mapping: org.eclipse.persistence.mappings.OneToOneMapping[aB]
Descriptor: RelationalDescriptor(A --> [DatabaseTable(TSI01_A)])
Runtime Exceptions:

I use the OID as primary key for the Entity Class A as well as for B.

Any help is welcome.

best regards,

Igor

Re: EclipseLink-48 [message #911812 is a reply to message #911685]

Wed, 12 September 2012 07:24

Eclipse User

So, you want the B to share the same oid as the A? Or do you want to use a foreign key?
Either way, your use of @PrimaryKeyJoinColumn is wrong.

Either remove this (and a foreign key will be used).

Or use a mappedBy in the A relationship, and add OneToOne back in B that uses the @PrimaryKeyJoinColumn(name="OID"), or @JoinColumn(name="OID",insertable=false,updateable=false)

See,
http://en.wikibooks.org/wiki/Java_Persistence/Identity_and_Sequencing#Primary_Keys_through_OneToOne_and_ManyToOne_Relationships

http://en.wikibooks.org/wiki/Java_Persistence/OneToOne

Re: EclipseLink-48 [message #911906 is a reply to message #911812]

Wed, 12 September 2012 11:02

Eclipse User

Hi James,

thank you for your answer.

I did the first solution you told me with mappedBy in the A relationship, and add OneToOne back in B that uses the PrimaryKeyJoinColumn(name="oid_adresse").

So far it worked and I got the table generated.

CREATE TABLE A (
OID RAW(13) NOT NULL,
oid_adresse RAW(13) NULL,
PRIMARY KEY (OID));

CREATE TABLE B(
oid_adresse RAW(13) NOT NULL,
PRIMARY KEY (oid_adresse));

as well as

ALTER TABLE A ADD CONSTRAINT FK_A_oid_adresse FOREIGN KEY (oid_adresse) REFERENCES B (oid_adresse);

ALTER TABLE B ADD CONSTRAINT FK_B_oid_adresse FOREIGN KEY (oid_adresse) REFERENCES A (oid_adresse)

When I try to use persist(A), I get the following exception:

java.lang.IllegalStateException: During synchronization a new object was found through a relationship that was not marked cascade PERSIST: B@1050aad.
[java] at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.discoverUnregisteredNewObjects(RepeatableWriteUnitOfWork.java:303)
[java] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.calculateChanges(UnitOfWorkImpl.java:706)
[java] at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:431)
[java] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:798)

I did do on B the following annotation:

public class B extends Base {

...

@OneToOne(cascade = CascadeType.ALL)
@PrimaryKeyJoinColumns({
@PrimaryKeyJoinColumn(name="oid_adresse",
referencedColumnName="oid_adresse")
})
public A getA() {
return a;
}
}

What's still missing?

best regards,

Igor

Re: EclipseLink-48 [message #916049 is a reply to message #911906]

Tue, 18 September 2012 09:05

Eclipse User

Ensure you relationship to B in A is cascade persist.

Previous Topic:	"updatable = false" column getting updated
Next Topic:	Problem filtering with NOT IN clause

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 07 06:36:25 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter