When I execute a
Code:
HQL: FROM user IN class eg.User WHERE user.userName = ?
,Hibernate translates it to
Code:
SQL:select user.user_uid as user_uid, user.version as version, user.name as name, user.userName as userName from cl_users user where (user.userName=? )
. This sql can't be executed rightly in Oracle9i.
When i execute this
Code:
SQL:select usr.user_uid as user_uid, usr.version as version, usr.name as name, usr.userName as userName from cl_users usr
. It can be executed correctly.So I think the world user maybe a keyworld in Oracle SQL. But how can i write the HQL to populate this sql.