日期:2014-05-18  浏览次数:20903 次

不知道是什么问题,高手请进!
登录验证总调不通,我用的是struts+hibernate!
调试错误信息如下;
begin   tx
net.sf.hibernate.JDBCException:   Could   not   execute   query
at   net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1515)
at   net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at   ems.emsbean.login.LoginAction.execute(LoginAction.java:53)
at   org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at   org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at   weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
at   weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
at   weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
at   weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
at   weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at   weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at   weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
at   weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
at   weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at   weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
Caused   by:   java.sql.SQLException:   ORA-00936:   缺少表达式

at   oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at   oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at   oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at   oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at   oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
at   oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:500)
at   oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
at   oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532)
at   oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
at   oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
at   oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946)
at   com.mchange.v2.c3p0.impl.C3P0PreparedStatement.executeQuery(C3P0PreparedStatement.java:188)
at   com.mchange.v2.c3p0.impl.C3P0PooledConnection$2.executeQuery(C3P0PooledConnection.java:473)
at   net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
at   net.sf.hibernate.loader.Loader.getResultSet(Loader.java:795)
at   net.sf.hibernate.loader.Loader.doQuery(Loader.java:189)
at   net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at   net.sf.hibernate.loader.Loader.doList(Loader.java:950)
at   net.sf.hibernate.loader.Loader.list(Loader.java:941)
at   net.sf.hibernate.hql.QueryTranslator.list(Que