Hibernate generates the folloging query:
select _u.user_group_id as x0_0_ from LTDS.USERGROUP _u where (_u.name='argosys' )

(Oracle version 9i, Hibernate 2.1.2)


Oracle reports ORA-00911 error code, Invalid Character.


If I remove the underscore on table alias and paste the following query into SQL*Plus it works: (Fails as well with '_' in SQL*Plus)

select u.user_group_id as x0_0_ from LTDS.USERGROUP u where (u.name='argosys' )

I am suprised, since Hibernate does not use '_' as first char for other aliases that it generates. One hint, USERGROUP table is a "superclass" to two other tables <joined-subclass>.

Thanks.

Sorry, Hibernate never generated this query, instead I had this query defined in a <query> inside the hbm.xml file.

Please disregard this post.