version 3.2

Please , i am desperate!!!!!

I have QueryEvent that has one-to-many relation with BusinessRules
(This is not bi-directional)
The Fk is in the BusinessRules to the QueryEvent

i want to run the following sql:


so i write the following Hql:


but hibernate generate the following illegal sql:


the problem is :
the section - and .
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=BUSINESS_RULES.Hjid and queryevent1_.Hjid=26)' at line 1

i tried with " exists " but than i got a sql exception that i cant update in a from clause (hibernate write the child again in the exists clause)

please , advice.

please!!!!!!!!
how can i delete a child in hql???? (the best will be if i can delete the child and the parent but i understood that hql dosnt support in cascade , so i get constraits violation)

Thank you

try this:

It generate the following sql :



as you can see this sql is illegall:


I write the following hql:


And it work.

Thank you.

solve the problem.

So, plllllllllllllllllease .
How can i delete child in hql????

try this:

10:40:55,230 DEBUG JDBCExceptionReporter:63 - could not execute update query [delete from BUSINESS_RULES where exists (select queryevent1_.Hjid, businessru2_.Hjid from QUERY_EVENTS queryevent1_ inner join BUSINESS_RULES businessru2_ on queryevent1_.Hjid=businessru2_.QueryEvent_BusinessRule_Hjid where Hjid=Hjid and queryevent1_.Hjid=34)]

java.sql.SQLException: Column 'Hjid' in where clause is ambiguous

a last try:

This the sql generate:


This is the exception:SqlException

Try with a slightly different form:

Hibernate generate new BusinessRule in the inner sql query.
this is the problem