<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <base href="https://hibernate.atlassian.net" />
<title>Message Title</title>
</head>
<body class="jira" style="color: #333; font-family: Arial, sans-serif; font-size: 14px; line-height: 1.429">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f5f5f5; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<!-- header here -->
<tr>
<td id="header-pattern-container" style="padding: 0px; border-collapse: collapse; padding: 10px 20px">
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="header-avatar-image-container" valign="top" style="padding: 0px; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px"> <img id="header-avatar-image" class="image_fix" src="https://secure.gravatar.com/avatar/26fdb5f69d52c0ed360334c09247fb72?d=mm&s=48" height="32" width="32" border="0" style="border-radius: 3px; vertical-align: top" />
</td>
<td id="header-text-container" valign="middle" style="padding: 0px; border-collapse: collapse; vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px"> <a class="user-hover" rel="dadrus" id="email_dadrus" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=dadrus" style="color:#6c797f;; color: #3b73af; text-decoration: none">Dimitrij Drus</a> <strong>created</strong> an issue
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="email-content-container" style="padding: 0px; border-collapse: collapse; padding: 0 20px">
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-spacing: 0; border-collapse: separate">
<tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<td class="email-content-rounded-top mobile-expand" style="padding: 0px; border-collapse: collapse; color: #fff; padding: 0 15px 0 16px; height: 15px; background-color: #fff; border-left: 1px solid #ccc; border-top: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom: 0; border-top-right-radius: 5px; border-top-left-radius: 5px; height: 10px; line-height: 10px; padding: 0 15px 0 16px; mso-line-height-rule: exactly">
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff">
<table class="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td class="page-title-pattern-first-line " style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; padding-top: 10px"> <a href="https://hibernate.atlassian.net/browse/HHH" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-9458" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-static-bug-8845f69c-800e-4adf-8e53-bf18a49a5ecd" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom" /></a> <a href="https://hibernate.atlassian.net/browse/HHH-9458" style="color: #3b73af; text-decoration: none">HHH-9458</a>
</td>
</tr>
<tr>
<td style="vertical-align: top;; padding: 0px; border-collapse: collapse; padding-right: 5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" class="page-title-pattern-header-container"> <span class="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size: 20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-9458" style="color: #3b73af; text-decoration: none">Referential integrity violation on removal of subtree</a> </span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand wrapper-special-margin" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff; padding-top: 10px; padding-bottom: 5px">
<table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Issue Type:
</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-bug-8845f69c-800e-4adf-8e53-bf18a49a5ecd" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom" /> Bug
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Affects Versions:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
4.2.7
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Assignee:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
Unassigned
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Attachments:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
hibrnate-issue.zip
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Components:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
core
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Created:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
23/Oct/2014 06:13 AM
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Priority:
</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-major-b4c921bc-2c93-4ef2-8cc3-237871876a22" height="16" width="16" border="0" align="absmiddle" alt="Major" style="vertical-align: text-bottom" /> Major
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Reporter:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="dadrus" id="email_dadrus" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=dadrus" style="color:#6c797f;; color: #3b73af; text-decoration: none">Dimitrij Drus</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand issue-description-container" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff; padding-top: 5px; padding-bottom: 10px">
<table class="text-paragraph-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 2px">
<tr>
<td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0px; border-collapse: collapse; padding: 0 0 10px 0">
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Starting with hibernate-core 4.2.7 there is an issue with updating the contents of the DB given the following tree structure:</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">TopLevel <span class="error">[1]</span> <</p>
<del>
> <span class="error">[0..1]</span> LeafA <span class="error">[1]</span> <
</del>> <span class="error">[*]</span> LeafB
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Where the TopLevel is the top level element to access the aggregate structure. It can reference zero or one LeafA object. LeafA is a composite which can contain zero or multiple LeafB objects. All relationships are bidirectional.</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Previous to hibernate-core 4.2.7 it was possible to remove the association from TopLevel to LeafA (by just setting the corresponding objects to null at the corresponding ends of the association) which led to the deletion of the entire subtree (LeafA <->* LeafB) from the DB. From hibernate-core 4.2.7 and up hibernate tries to delete only the LeafA entity without deleting the associated LeafB objects. This leads to a referntial integrity violation thrown by the DB.</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">The attached zip file contains a complete working Maven project to reproduce the issue. Just change the hibernate-core dependency to version above 4.2.6 and the issue described above will raise.</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Here is the resulting stack trace as well:<br /> javax.persistence.RollbackException: Error while committing the transaction<br /> at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:92)<br /> at com.example.AggregateTest.executeInTransaction(AggregateTest.java:62)<br /> at com.example.AggregateTest.testTopLevelObjectCreationAndMidLevelAggregateRemoval(AggregateTest.java:252)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.lang.reflect.Method.invoke(Method.java:606)<br /> at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)<br /> at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)<br /> at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)<br /> at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)<br /> at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)<br /> at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30)<br /> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)<br /> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)<br /> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)<br /> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)<br /> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)<br /> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)<br /> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)<br /> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)<br /> at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30)<br /> at org.junit.runners.ParentRunner.run(ParentRunner.java:300)<br /> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)<br /> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<br /> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)<br /> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)<br /> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)<br /> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)<br /> Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement<br /> at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)<br /> at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)<br /> at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:80)<br /> ... 28 more<br /> Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement<br /> at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129)<br /> at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)<br /> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)<br /> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)<br /> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)<br /> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3360)<br /> at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3560)<br /> at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:102)<br /> at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:393)<br /> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:385)<br /> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:300)<br /> at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:339)<br /> at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)<br /> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1240)<br /> at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404)<br /> at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)<br /> at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)<br /> at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75)<br /> ... 28 more<br /> Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_QOIW1SGTYIQDFUN53S5BJIP5S: PUBLIC.ABSTRACTAGGREGATE FOREIGN KEY(PARENT_ID) REFERENCES PUBLIC.ABSTRACTAGGREGATE(ID) (8)"<br /> Referential integrity constraint violation: "FK_QOIW1SGTYIQDFUN53S5BJIP5S: PUBLIC.ABSTRACTAGGREGATE FOREIGN KEY(PARENT_ID) REFERENCES PUBLIC.ABSTRACTAGGREGATE(ID) (8)"; SQL statement:<br /> delete from AbstractAggregate where ID=? and VERSION=? <span class="error">[23503-182]</span><br /> at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)<br /> at org.h2.message.DbException.get(DbException.java:179)<br /> at org.h2.message.DbException.get(DbException.java:155)<br /> at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:426)<br /> at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:443)<br /> at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:318)<br /> at org.h2.table.Table.fireConstraints(Table.java:908)<br /> at org.h2.table.Table.fireAfterRow(Table.java:926)<br /> at org.h2.command.dml.Delete.update(Delete.java:100)<br /> at org.h2.command.CommandContainer.update(CommandContainer.java:78)<br /> at org.h2.command.Command.executeUpdate(Command.java:254)<br /> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:157)<br /> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:143)<br /> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)<br /> ... 41 more</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff">
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">
<tr>
<td id="actions-pattern-container" valign="middle" style="padding: 0px; border-collapse: collapse; padding: 10px 0 10px 24px; vertical-align: middle; padding-left: 0">
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td class="actions-pattern-action-icon-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 0px; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-9458#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="cid:jira-generated-image-static-comment-icon-437d35e7-ca53-4cec-9f49-0cfa6e7ecf4b" alt="Add Comment" title="Add Comment" height="16" width="16" border="0" style="vertical-align: middle" /> </a>
</td>
<td class="actions-pattern-action-text-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 4px; padding-left: 5px"> <a href="https://hibernate.atlassian.net/browse/HHH-9458#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<tr>
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0px; border-collapse: collapse; color: #fff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #fff; border-top: 0; border-left: 1px solid #ccc; border-bottom: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="footer-pattern" style="padding: 0px; border-collapse: collapse; padding: 12px 20px">
<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0px; border-collapse: collapse; color: #999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px">
This message was sent by Atlassian JIRA <span id="footer-build-information">(v6.4-OD-07-004#64005-<span title="29a0beaca7c693975974e1d5d9f869ecb60599fc" data-commit-id="29a0beaca7c693975974e1d5d9f869ecb60599fc}">sha1:29a0bea</span>)</span>
</td>
<td id="footer-pattern-logo-desktop-container" valign="top" style="padding: 0px; border-collapse: collapse; padding-left: 20px; vertical-align: top">
<table style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="footer-pattern-logo-desktop-padding" style="padding: 0px; border-collapse: collapse; padding-top: 3px"> <img id="footer-pattern-logo-desktop" src="cid:jira-generated-image-static-footer-desktop-logo-266def98-bfbc-45b3-bfdb-112f0cbba0f7" alt="Atlassian logo" title="Atlassian logo" width="169" height="36" class="image_fix" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>