Error related to Hibernate Query

[Varun Nambuthiri]

Hi ,

This is the error that the stacktrace displays every time i try to execute the query


the code where this error pops up

Query q = session.createQuery("from user where username= :user and password =:pass");
q.setParameter("user",user);
q.setParameter("pass",pass);
loggedinUser = q.list();
System.out.println(loggedinUser);
u = (User)loggedinUser.get(0);
System.out.println(u);
System.out.println("------ after the DB process -----");

net.sf.hibernate.QueryException: in expected: u [from user u where u.username= :user and u.password =:pass]
at net.sf.hibernate.hql.FromParser.token(FromParser.java:102)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:293)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1493)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1464)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at com.emr.process.LoginProcess.checkUser(LoginProcess.java:39)
at com.emr.actions.LoginAction.execute(LoginAction.java:30)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

What does the error indicate ?

[rohit chavan]

 

Query q = session.createQuery("from user where username= :user and password =:pass");

You need to write the entire query that you can actually execute.
You should have used select * from user where username= :user and password =:pass in the above line.

[Varun Nambuthiri]

Hi ,

I did try that too . Same kind of error occurred . Will make the changes and post the updated stackTrace .

Thanks and Regards
Varun

[Bill Gorder]

First of all you are dealing with classes (case sensitive) is it really 'user' and not 'User'?

If that is not the problem then what kind of hibernate properties do you have set? Are things defined correctly in your cfg file?

Lastly try fully qualifying it (this should not be necessary but may be if your configurations are not correct)

Query q = session.createQuery("from com.xxx.yyy.zzz.user where username= :user and password =:pass");

*this assumes your class is user and not User

[Varun Nambuthiri]

Hey ,

Thanks Bill and Rohit , I have managed to solve it thanks to your advice Bill . I was using the table name in the DB (user) and not the class name (which was User) in the query .

so the query should have been

Query q = s.createQuery("from User where username = :username and password=:password");

I will say this one more , This place is the best !! Thank you guys .Hope one day i will have learnt enough to start giving back to Ranch ..

Thank you
Regards
Varun