Message Title

Vlad Mihalcea created an issue

Issue Type:	Bug
Affects Versions:	5.0.12, 5.2.12, 5.3.0.Beta1
Assignee:	Unassigned
Components:	hibernate-core
Created:	22/Jan/2018 22:51 PM
Priority:	Major
Reporter:	Vlad Mihalcea

If we have the following many-to-many association:

 
                                                                @Entity(name = "Person")
public static class Person {

	@Id
	@GeneratedValue
	private Long id;

	@NaturalId
	private String registrationNumber;

	@ManyToMany(cascade = {CascadeType.PERSIST, CascadeType.MERGE})
	private List<Address> addresses = new ArrayList<>();

	public Person() {
	}

	public Person(String registrationNumber) {
		this.registrationNumber = registrationNumber;
	}

	public void addAddress(Address address) {
		addresses.add( address );
		address.owners.add( this );
	}
}

@Entity(name = "Address")
public static class Address {

	@Id
	@GeneratedValue
	private Long id;

	private String street;

	@Column(name = "`number`")
	private String number;

	private String postalCode;

	@ManyToMany(mappedBy = "addresses")
	private List<Person> owners = new ArrayList<>();

	public Address() {
	}

	public Address(String street, String number, String postalCode) {
		this.street = street;
		this.number = number;
		this.postalCode = postalCode;
	}
}
 
                                                            

Removing the Post works just fine:

 
                                                                Person _person1 = doInJPA( this::entityManagerFactory, entityManager -> {
	Person person1 = new Person( "ABC-123" );
	Person person2 = new Person( "DEF-456" );

	Address address1 = new Address( "12th Avenue", "12A", "4005A" );
	Address address2 = new Address( "18th Avenue", "18B", "4007B" );

	person1.addAddress( address1 );
	person1.addAddress( address2 );

	person2.addAddress( address1 );

	entityManager.persist( person1 );
	entityManager.persist( person2 );

	return person1;
} );

doInJPA( this::entityManagerFactory, entityManager -> {
	Person person1 = entityManager.find( Person.class, _person1.id );

	entityManager.remove( person1 );
} );
 
                                                            

However, removing the Address throws a ConstraintViolationException:

 
                                                                Address _address1 = doInJPA( this::entityManagerFactory, entityManager -> {
	Person person1 = new Person( "ABC-123" );
	Person person2 = new Person( "DEF-456" );

	Address address1 = new Address( "12th Avenue", "12A", "4005A" );
	Address address2 = new Address( "18th Avenue", "18B", "4007B" );

	person1.addAddress( address1 );
	person1.addAddress( address2 );

	person2.addAddress( address1 );

	entityManager.persist( person1 );
	entityManager.persist( person2 );

	return address1;
} );

doInJPA( this::entityManagerFactory, entityManager -> {
	Address address1 = entityManager.find( Address.class, _address1.id );

	entityManager.remove( address1 );
} ); 
 
                                                            

and this is the stacktrace:

 
                                                                Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3356)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3593)
	at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:99)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:599)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:473)
	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
	at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1440)
	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:496)
	at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3216)
	at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2422)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:171)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:264)
	at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:86)
	... 18 more
Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FKM7J0BNABH2YR0PE99IL1D066U: PUBLIC.PERSON_ADDRESS FOREIGN KEY(ADDRESSES_ID) REFERENCES PUBLIC.ADDRESS(ID) (2)"; SQL statement:
delete from Address where id=? [23503-196]
 
                                                            

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira