Why does the HQL-statement not work.

murxx · **Joined:** Mon Feb 16, 2004 7:11 am **Posts:** 13

Hello everybody!

I was trying to use the HQL language to select some objects from the database. My code looks like this:

Code:

Query q = session.createQuery("SELECT userrole FROM UserRole as userrole WHERE userrole.username = :username");
q.setString("username",username);

But this throws a javax.servlet.ServletException: unexpected token: as [SELECT userrole FROM UserRole as userrole WHERE userrole.username = :username] at me.

Why does it do that? Didn't I keep the query as simple as possible.
I tried to do the same with the Criteria-class and that works.

I'm dazzled.

bertrand · **Posted:** Tue Feb 17, 2004 8:18 am

Remove the as keyword from your query and write it as follows:

Code:

SELECT userrole FROM UserRole userrole WHERE userrole.username = :username

tcollins · **Posted:** Tue Feb 17, 2004 8:25 am

I'm not sure if this will help you but here are some suggestions...

(Inlcuded in the HibernateExtensions distribution)

userrole.username

userrole.userName

Hope this helps.

emmanuel · **Posted:** Tue Feb 17, 2004 10:23 am

You can use 'as'
Be sure that UserRole is mapped and that the file is referenced in hibernate.cfg.xml
Try the fully qualified class name.

gavin · **Posted:** Tue Feb 17, 2004 1:01 pm

Hibernate does not know about the UserRole class.