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

Components: core Versions: 3.1.2 Reporter: Stephen Friedrich Attachments: leadingunderscore.zip, org.hibernate.util.StringHelper.patch 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 = CascadeType.ALL, fetch = FetchType.EAGER, mappedBy = "_user") private Set<Permission> _permissions = new HashSet<Permission>(); And this is the generated SQL: select _permissio0_.user_id as user4_2_, _permissio0_.id as id2_, _permissio0_.id as id40_1_, _permissio0_.version as version40_1_, _permissio0_.guid as guid40_1_, _permissio0_.user_id as user4_40_1_, _permissio0_2_.company_reference_id as company2_42_1_, case when _permissio0_1_.permission_id is not null then 1 when _permissio0_2_.permission_id is not null then 2 when _permissio0_.id is not null then 0 end as clazz_1_, companyref1_.id as id43_0_, companyref1_.version as version43_0_, companyref1_.guid as guid43_0_, companyref1_.db_user_name as db4_43_0_, companyref1_.company_name as company5_43_0_ from permissions _permissio0_ left outer join admin_permissions _permissio0_1_ on _permissio0_.id=_permissio0_1_.permission_id left outer join company_permissions _permissio0_2_ on _permissio0_.id=_permissio0_2_.permission_id left outer join company_references companyref1_ on _permissio0_2_.company_reference_id=companyref1_.id where _permissio0_.user_id=? When executed Oracle gives this error: "ORA-00911: Ung³ltiges Zeichen" ("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 in http://forums.hibernate.org/viewtopic.php?t=929011&highlight=ora00911...