<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
The cause exception lost in the exception chain
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/javatwo">Dave Chen</a> in <i>Beginner's Corner</i> - <a href="http://community.jboss.org/message/535442#535442">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>public void commit() {<br/>  try {<br/>     userTransaction.commit();<br/>   } catch (Throwable t) {<br/>     t.printStackTrace();<br/>   }<br/> }<br/> </p><p>In case of org.hibernate.exception.ConstraintViolationException, on the terminal the error message:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not delete: [mypackage.Foo#1]<br/>        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)<br/>        at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)<br/>        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)<br/>        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)<br/>        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)<br/>        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)<br/>        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)<br/>        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)<br/>        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)<br/>        at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:162)<br/>...<br/>Caused by: org.hibernate.exception.ConstraintViolationException: could not delete: [package.Foo#1]<br/>        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)<br/>        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br/>        at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)<br/>        at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)<br/>        at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)<br/>        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)<br/>        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)<br/>        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)<br/>        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)<br/>        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)<br/>        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)<br/>        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)<br/>        at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)<br/>        ... 58 more<br/>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails ...<br/>        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/>        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br/>        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br/>        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br/>        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br/>        at com.mysql.jdbc.Util.getInstance(Util.java:381)<br/>        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)<br/>        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<br/>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)<br/>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)<br/>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)<br/>        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)<br/>        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)<br/>        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)<br/>        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)<br/>        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)<br/>        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)<br/>        at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:874)<br/>        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)<br/>        at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)<br/>        ... 68 more</p><p>but the caught Throwable is javax.transaction.RollbackException, it did not have ConstraintViolation information. We like to show the constraint violation information to users. How to get the real cuase of the exception?  we use JBOSS 5.1.0GA. Thanks!</p><p>Dave</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/535442#535442">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Beginner's Corner at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>