[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-964) ORA-00936 with joined subclass / Oracle

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-964.
------------------------------


Closing stale resolved issues

> ORA-00936 with joined subclass / Oracle
> ---------------------------------------
>
>                 Key: HHH-964
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-964
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.1 beta 2
>         Environment: Hibernate 3.1 beta 3, Oracle 9i Release 2 (9.2.0.1)
>            Reporter: Heiko Hüter
>            Assignee: Steve Ebersole
>            Priority: Blocker
>             Fix For: 3.1 rc 1
>
>         Attachments: testCase.zip
>
>
> if i do a delete from SubObjekt where propertyA='1234' bulk -delete i get an ORA-00936 error. The entity SubObjekt is a joined-subclass of the type SuperObjekt. The generated sql looks like :
> insert into HT_SUB_OBJEKT select del.ID as ID from SYSADM5.SUB_OBJEKT del, SYSADM5.SUPER_OBJEKT del_1_ where  and del.ID=del_1_.IDPROPERTY_A='1234'
> The problem is the unnecessary and directly after the where clause.
> the attached zip files contains a runnable junit test for the problem. You just need to have an running oracle instance with user TEST (password TEST) and granted roles CONNECT, RESOURCE
> I tested the existence of this bug with 3.1 beta 2 and 3.

-- 
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