Hi i am trying to delete record from the table. The query i am passing to createQuery is...

DELETE from T_Appl_Acct_Grp_Dtl where ( group_Id = 1 and role_Code = 'HSP' and level1 = '0041' and level2 is null and level3 is null and level4 is null) OR (group_Id = 1 and role_Code = 'HSP' and level1 = '0041' and level2 = '34545' and level3 = '35345' and level4 is null)

after executing the query. The hibernate generated the query like this...

delete from RA00.T_APPL_ACCT_GRP_DTL where GROUP_ID=1 and ROLE_CODE='HSP' and LEVEL1='0041' and (LEVEL2 is null) and (LEVEL3 is null) and (LEVEL4 is null) or GROUP_ID=1 and ROLE_CODE='HSP' and LEVEL1='0041' and LEVEL2='34545' and LEVEL3='35345' and (LEVEL4 is null)

The brackets are miss placed and this cause some proplem while deleteing the records from the table.


can any one help me in this please...

what version of hibernate ?

if not latest 3.1.x or 3.2.x then please verify against such version and if the problem persists then submit a runnable failing testcase to jira.