[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1573) one-to-many fails on oracle if field starts with underscore

[Marco R. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1573?pa=
ge=3Dcomments#action_23380 ]=20

Marco Reimann commented on HHH-1573:
------------------------------------

Since I also encountered this problem I created a TestCase to reproduce it =
based on the 3.2 CR2 Release and a fix that in my opinion solves the proble=
m.=20

To run the test, unpack leadingunderscore.zip into the Hibernate3/test/org/=
hibernate/test directory.

Could you please check this out and include the fix in one of the next rele=
ases?

Thanks

Marco Reimann

> one-to-many fails on oracle if field starts with underscore
> -----------------------------------------------------------
>
>          Key: HHH-1573
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/H=
HH-1573
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.1.2
>     Reporter: Stephen Friedrich
>  Attachments: leadingunderscore.zip, org.hibernate.util.StringHelper.patc=
h
>
>
> Hibernate generates SQL that is invalid on Oracle, because it has fields =
in the select clause that start with an underscore.
> This is my field declaration:
>     @OneToMany(cascade =3D CascadeType.ALL, fetch =3D FetchType.EAGER, ma=
ppedBy =3D "_user")
>     private Set<Permission> _permissions =3D new HashSet<Permission>();
> And this is the generated SQL:
> select
> =09_permissio0_.user_id as user4_2_,
> =09_permissio0_.id as id2_,=20
> =09_permissio0_.id as id40_1_,=20
> =09_permissio0_.version as version40_1_,=20
> =09_permissio0_.guid as guid40_1_,=20
> =09_permissio0_.user_id as user4_40_1_,=20
> =09_permissio0_2_.company_reference_id as company2_42_1_,=20
> case
> =09when _permissio0_1_.permission_id is not null then 1=20
> =09when _permissio0_2_.permission_id is not null then 2=20
> =09when _permissio0_.id is not null then 0
> end
> as
> =09clazz_1_,
> =09companyref1_.id as id43_0_,
> =09companyref1_.version as version43_0_,
> =09companyref1_.guid as guid43_0_,
> =09companyref1_.db_user_name as db4_43_0_,=20
> =09companyref1_.company_name as company5_43_0_=20
> from=20
> =09permissions _permissio0_=20
> =09left outer join admin_permissions _permissio0_1_ on _permissio0_.id=3D=
_permissio0_1_.permission_id=20
> =09left outer join company_permissions _permissio0_2_ on _permissio0_.id=
=3D_permissio0_2_.permission_id=20
> =09left outer join company_references companyref1_ on _permissio0_2_.comp=
any_reference_id=3Dcompanyref1_.id=20
> where _permissio0_.user_id=3D?
> When executed Oracle gives this error: "ORA-00911: Ung=C2=B3ltiges Zeiche=
n" ("invalid character" in german)
> If I remove the underscore in front of every occurence of "_permissio..."=
 then I can execute the SQL fine on the command line ("?" replaced by 1).
> This has been reported on the forum, but nobody answered. See last post i=
n=20
> http://forums.hibernate.org/viewtopic.php?t=3D929011&highlight=3Dora00911=
&sid=3Dc501920d028c78899884f5bfac8e827e

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