问题描述
执行程序的时候报出这个问题，麻烦各位帮我看看：2011-01-2009:00:56,062WARN[org.hibernate.util.JDBCExceptionReporter]-SQLError:933,SQLState:420002011-01-2009:00:56,062ERROR[org.hibernate.util.JDBCExceptionReporter]-ORA-00933:SQL命令未正确结束2011-01-2009:00:56,078WARN[org.apache.struts.action.RequestProcessor]-UnhandledExceptionthrown:classorg.springframework.dao.InvalidDataAccessResourceUsageException2011-01-2009:00:56,093ERROR[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SSHTEST].[action]]-Servlet.service()forservletactionthrewexceptionjava.sql.SQLException:ORA-00933:SQL命令未正确结束atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)atoracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)atoracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212)atoracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:795)atoracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)atoracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835)atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123)atoracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)atoracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328)atorg.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)atorg.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)atorg.hibernate.loader.Loader.getResultSet(Loader.java:1787)atorg.hibernate.loader.Loader.doQuery(Loader.java:674)atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)atorg.hibernate.loader.Loader.doList(Loader.java:2220)atorg.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)atorg.hibernate.loader.Loader.list(Loader.java:2099)atorg.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)atorg.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)atorg.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)atorg.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)atorg.hibernate.impl.QueryImpl.list(QueryImpl.java:79)atmain.com.rpc.persist.StuInfoDAO$1.doInHibernate(StuInfoDAO.java:63)atorg.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)atorg.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:342)atmain.com.rpc.persist.StuInfoDAO.getStuinfo(StuInfoDAO.java:61)atmain.com.rpc.biz.StuInfoHandlerImpl.getStuinfo(StuInfoHandlerImpl.java:38)atmain.com.rpc.web.StuInfoAction.doQuery(StuInfoAction.java:34)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)atjava.lang.reflect.Method.invoke(Method.java:585)atorg.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)atorg.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)atorg.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)atorg.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)atorg.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)atorg.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)atorg.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:707)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:820)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)atorg.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)atorg.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)atorg.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)atorg.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)atjava.lang.Thread.run(Thread.java:595)代码：publicList<User>getStuinfo(finalintfirstSize,finalintpageSize){HibernateTemplateht=this.getHibernateTemplate();List<User>list=ht.executeFind(newHibernateCallback(){publicObjectdoInHibernate(Sessionsession)throwsHibernateException,SQLException{returnsession.createQuery("fromUser").setFirstResult(firstSize).setMaxResults(pageSize).list();}});returnlist;
解决方案
解决方案二：
java.sql.SQLException:ORA-00933:SQL命令未正确结束检查一下你的sql语句
解决方案三：
看看你的sql语句有没有
解决方案四：
检查SQl语句，不过貌似你用的是Hibernate框架，用HQL语句么？
解决方案五：
自己先在数据库查询器里面验证你的SQL语句是否可以正常执行问SQL问题起码要贴出表结构你的SQL语句和数据库版本