Cannot add or update a child row when using @EmbeddedId

[daphna deutsch]

Hello,

I have the following objects:

User Object:

public class User implements Serializable {

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(unique = true, nullable = false)
	private int id;

	@OneToMany(fetch = FetchType.EAGER, mappedBy = "user", cascade = CascadeType.ALL)
	private List<UserReason> userReasons;


....

	public List<UserReason> getUserReasons() {
		return userReasons;
	}

	public void setUserReasons(List<UserReason> userReasons) {
		this.userReasons = userReasons;
	}

	public UserReason addUserReason(UserReason userReason) {
		if (userReasons == null) {
			userReasons = new ArrayList<UserReason>();
		}
		userReasons.add(userReason);
		userReason.setUser(this);

		return userReason;
	}

	public UserReason removeUserReason(UserReason userReason) {
		if (userReasons != null) {
			userReasons.remove(userReason);
		}
		userReason.setUser(null);

		return userReason;
	}

}

UserReason Object:

public class UserReason implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private UserReasonPK id;

	// bi-directional many-to-one association to User
	@ManyToOne
	@JoinColumn(name = "userId")
	private User user;

....

And UserReasonPK object:

public class UserReasonPK implements Serializable {
	// default serial version id, required for serializable classes.
	private static final long serialVersionUID = 1L;

	@Column(insertable = false, updatable = false)
	private int userId;

	@Column(unique = true, nullable = false)
	private int reasonId;

....

I want to be able to add userReason to the list, and that Hibernate will automatically update the reference between the parent & child object.

When using the above code, when trying to start the server, i'm getting the error message:

Repeated column in mapping for entity: com.commit.safebeyond.model.UserReason column: userId (should be mapped with insert="false" update="false")

Please notice that i mapped the userId in UserReasonPK with insertable = false, updatable = false.

If i change it, and add this on the User property in UserReason object, server is up, but when trying to insert new User i'm getting the following error:

Hibernate: insert into UserReasons (reasonId, userId) values (?, ?)
WARN    2015-01-01 13:25:17,488 [http-nio-8080-exec-2] org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - SQL Error: 1452, SQLState: 23000
ERROR   2015-01-01 13:25:17,488 [http-nio-8080-exec-2] org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - Cannot add or update a child row: a foreign key constraint fails (`SafeBeyond`.`UserReasons`, CONSTRAINT `FK_UserReasons_Users` FOREIGN KEY (`userId`) REFERENCES `Users` (`id`))
INFO    2015-01-01 13:25:17,490 [http-nio-8080-exec-2] org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl  - HHH000010: On release of batch it still contained JDBC statements
Jan 01, 2015 1:25:17 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [Jersey REST Service] in context with path [/safe-beyond-server] threw exception [org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`SafeBeyond`.`UserReasons`, CONSTRAINT `FK_UserReasons_Users` FOREIGN KEY (`userId`) REFERENCES `Users` (`id`))
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

[Frits Walraven]

Hi Daphna,

The problem is that you have the userId in both the EmbeddedId as in the relationship to the User Entity. If I remember it well you can use the @MapsId annotation to indicate that the userId is mapped to the User Entity:

public class UserReason implements Serializable {  
    private static final long serialVersionUID = 1L;  
  
    @EmbeddedId  
    private UserReasonPK id;  
  
    // bi-directional many-to-one association to User  
    @ManyToOne  
    @MapsId("userId")
    @JoinColumn(name = "userId")  
    private User user; 
    ...
}

Regards,
Frits

[daphna deutsch]

Hi Frits,
thanks for you help.
it did fix the problem!

Daphna

[daphna deutsch]

daphna deutsch wrote:Hello,

I have the following objects:

User Object:

public class User implements Serializable {

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(unique = true, nullable = false)
	private int id;

	@OneToMany(fetch = FetchType.EAGER, mappedBy = "user", cascade = CascadeType.ALL)
	private List<UserReason> userReasons;


....

	public List<UserReason> getUserReasons() {
		return userReasons;
	}

	public void setUserReasons(List<UserReason> userReasons) {
		this.userReasons = userReasons;
	}

	public UserReason addUserReason(UserReason userReason) {
		if (userReasons == null) {
			userReasons = new ArrayList<UserReason>();
		}
		userReasons.add(userReason);
		userReason.setUser(this);

		return userReason;
	}

	public UserReason removeUserReason(UserReason userReason) {
		if (userReasons != null) {
			userReasons.remove(userReason);
		}
		userReason.setUser(null);

		return userReason;
	}

}

UserReason Object:

public class UserReason implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private UserReasonPK id;

	// bi-directional many-to-one association to User
	@ManyToOne
	@JoinColumn(name = "userId")
	private User user;

....

And UserReasonPK object:

public class UserReasonPK implements Serializable {
	// default serial version id, required for serializable classes.
	private static final long serialVersionUID = 1L;

	@Column(insertable = false, updatable = false)
	private int userId;

	@Column(unique = true, nullable = false)
	private int reasonId;

....

I want to be able to add userReason to the list, and that Hibernate will automatically update the reference between the parent & child object.

When using the above code, when trying to start the server, i'm getting the error message:

Repeated column in mapping for entity: UserReason column: userId (should be mapped with insert="false" update="false")

Please notice that i mapped the userId in UserReasonPK with insertable = false, updatable = false.

If i change it, and add this on the User property in UserReason object, server is up, but when trying to insert new User i'm getting the following error:

Hibernate: insert into UserReasons (reasonId, userId) values (?, ?)
WARN    2015-01-01 13:25:17,488 [http-nio-8080-exec-2] org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - SQL Error: 1452, SQLState: 23000
ERROR   2015-01-01 13:25:17,488 [http-nio-8080-exec-2] org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - Cannot add or update a child row: a foreign key constraint fails (`TEST`.`UserReasons`, CONSTRAINT `FK_UserReasons_Users` FOREIGN KEY (`userId`) REFERENCES `Users` (`id`))
INFO    2015-01-01 13:25:17,490 [http-nio-8080-exec-2] org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl  - HHH000010: On release of batch it still contained JDBC statements
Jan 01, 2015 1:25:17 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [Jersey REST Service] in context with path [/TEST-server] threw exception [org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`TEST`.`UserReasons`, CONSTRAINT `FK_UserReasons_Users` FOREIGN KEY (`userId`) REFERENCES `Users` (`id`))
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)