[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3617) Using Query (Object) ocurr violates foreign key in transaction

[Clayton K. N. Passos (JIRA)]

Using Query (Object) ocurr violates foreign key in transaction
--------------------------------------------------------------

                 Key: HHH-3617
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3617
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.3.1
         Environment: "PostgreSQL 8.2.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.0 20080428 (Red Hat 4.3.0-8)"

Hibernate core 3.3.1 and the only required library
            Reporter: Clayton K. N. Passos
         Attachments: Car.hbm.xml, MainTest.java, Travel.hbm.xml

Using Query (Object) ocurr violates foreign key in transaction

Look MainTest and  Query object:

	Query query = session.createQuery(sb.toString());
	int row = query.executeUpdate();

I expect that the behavior be the even though  Session.delete(...), but it´s not true.

The exception occurs below:

Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not execute update query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
	at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
	at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283)
	at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1168)
	at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
	at com.MainTest.main(MainTest.java:54)
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "car" violates foreign key constraint "fk95cb6b3a78a8fea5" on table "travel"
  Detalhe: Key (idcar)=(1) is still referenced from table "travel".
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira