Using compound primary key throws SQLException
----------------------------------------------
Key: HHH-5675
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5675
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.6.0, 3.6.0.CR2, 3.6.0.CR1, 3.5.6, 3.6.0.Beta4, 3.6.0.Beta3, 3.5.5,
3.6.0.Beta2, 3.6.0.Beta1, 3.5.4, 3.5.3, 3.5.2, 3.5.1, 3.5.0-Final
Environment: Hibernate 3.6.0, MySql
Reporter: Ralf Pöhlmann
Priority: Critical
Using compound primary keys via @IdClass causes an exception when calling persist:
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: could not insert:
[de.methodpark.stages.model.UserAssignment]
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214)
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147)
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1153)
at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:678)
at
com.sun.enterprise.container.common.impl.EntityManagerWrapper.persist(EntityManagerWrapper.java:258)
Same code works when switching JPA provider to EclipseLink.
@Entity
@Table(name = "user_assignment")
@IdClass(value = UserAssignmentId.class)
public class UserAssignment implements Serializable {
@Id
private Long userId;
@Id
private Long elementId;
@ManyToOne(fetch = FetchType.LAZY, optional = false)
@JoinColumn(name = "element_id", referencedColumnName = "id")
private Element element;
@ManyToOne(fetch = FetchType.LAZY, optional = false)
@JoinColumn(name = "user_id", referencedColumnName = "id")
private User user;
}
public class UserAssignmentId implements Serializable {
public UserAssignmentId() { }
@Column(name = "user_id", insertable = false, updatable = false)
public Long userId;
@Column(name = "element_id", insertable = false, updatable = false)
public Long elementId;
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira