問大家一個比較弱的問題!(進來有分!)

[qinfen0628]

我在開發JSF+HIBERNATE（工具是Myeclipse）的時候為什麼老是出現這樣的異常呀：
(注：ehcache.jar我也加進去了!)

javax.faces.FacesException: #{loginBean.login}: javax.faces.el.EvaluationException: org.hibernate.exception.SQLGrammarException: could not execute query
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:78)
javax.faces.component.UICommand.broadcast(UICommand.java:312)
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)

請各位GG的幫我解釋一下 ，本人不勝感激！

[infowain]

大概是你的hql语句写错了，贴出来看看。

[interpb]

SQLGrammarException 语法错误

看看hql

[qinfen0628]

HQL語句為：
Query query = session

.createQuery("from User as u where u.username=? and u.password=?");

query.setString(0, username);

query.setString(1, password);