I am having issues with managing a Many to Many relationship. I have a user_address table which is comprised of the user and address class primary keys.
Below is the pertinent information:
Hibernate version:
3.2 and Annotations
Mapping documents:
package com.xxxx.users;
import org.hibernate.annotations.Cascade;
import javax.persistence.*;
import java.io.Serializable;
import java.util.List;
import java.util.ArrayList;
@Entity
@Table(schema = "MCWAGNER", name = "xxxx_USERS")
public class xxxxUsersEntity implements Serializable {
private Long uid;
private String lastName;
private String firstName;
private List<AddressEntity> address = new ArrayList<AddressEntity>();
@Id
@Column(name = "USER_ID", nullable = false, length = 10)
@GeneratedValue(generator="UsrSeq")
@SequenceGenerator(name="UsrSeq",sequenceName="USER_SEQUENCE")
public Long getUid() {
return uid;
}
public void setUid(Long uid) {
this.uid = uid;
}
@Basic
@Column(name = "LAST_NAME", nullable = false, length = 20)
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
@Basic
@Column(name = "FIRST_NAME", nullable = false, length = 20)
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
@ManyToMany(targetEntity = AddressEntity.class,
cascade ={CascadeType.PERSIST})
@JoinTable(
name = "USER_ADDRESS",
joinColumns = {@JoinColumn(name = "USR_ID")},
inverseJoinColumns = {@JoinColumn(name = "ADR_ID")}
)
public List<AddressEntity> getAddress() {
return address;
}
public void setAddress(List<AddressEntity> address) {
this.address = address;
}
}
package com.xxxx.users;
import javax.persistence.*;
import java.io.Serializable;
import java.util.List;
import java.util.ArrayList;
@Entity
@Table(schema = "MCWAGNER", name = "ADDRESS")
public class AddressEntity implements Serializable {
private Long aid;
private String city;
private String street;
private String zip;
private String state;
private List<xxxxUsersEntity> users = new ArrayList<XxxxUsersEntity>();
@Id
@Column(name = "ADDRESS_ID", nullable = false, length = 10)
@GeneratedValue(generator="AdrSeq")
@SequenceGenerator(name="AdrSeq",sequenceName="ADDRESS_SEQUENCE")
public Long getAid() {
return aid;
}
public void setAid(Long aid) {
this.aid = aid;
}
@Basic
@Column(name = "STREET", nullable = false, length = 50)
public String getStreet() {
return street;
}
public void setStreet(String street) {
this.street = street;
}
@Basic
@Column(name = "CITY", nullable = false, length = 20)
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
@Basic
@Column(name = "STATE", nullable = false, length = 2)
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
@Basic
@Column(name = "ZIP", nullable = false, length = 5)
public String getZip() {
return zip;
}
public void setZip(String zip) {
this.zip = zip;
}
@ManyToMany(targetEntity = xxxxUsersEntity.class)
@JoinTable(
name = "USER_ADDRESS",
joinColumns = {@JoinColumn(name = "ADR_ID")},
inverseJoinColumns = {@JoinColumn(name = "USR_ID")}
)
public List<xxxxUsersEntity> getUsers() {
return users;
}
public void setUsers(List<xxxxUsersEntity> users) {
this.users = users;
}
}
Code between sessionFactory.openSession() and session.close():
xxxxUsersEntity user = new xxxxUsersEntity();
user.setLastName("Ratcliffe");
user.setFirstName("John");
AddressEntity address = new AddressEntity();
address.setStreet("1234 Powatan Circle");
address.setCity("Jamestown");
address.setState("VA");
address.setZip("23606");
user.getAddress().add(address);
session.save(user);
System.out.println("Record Inserted");
Full stack trace of any exception that occurs:
Exception in thread "main" org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: com.xxxx.users.AddressEntity
at org.hibernate.engine.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:219)
at org.hibernate.type.EntityType.getIdentifier(EntityType.java:397)
at org.hibernate.type.ManyToOneType.nullSafeSet(ManyToOneType.java:78)
at org.hibernate.persister.collection.AbstractCollectionPersister.writeElement(AbstractCollectionPersister.java:755)
at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1143)
at org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:26)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:145)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.xxxx.users.AddUser.main(AddUser.java:29)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
Name and version of the database you are using:
Oralce 10g 10.2.0
Login
FAQ
Search
