你直接用getNamedQuery("getList"),试试看

解决方案 »

  1.   

    to 2楼,用getNamedQuery("getList")报下面的错。org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.doList(Loader.java:1596)
    at org.hibernate.loader.Loader.list(Loader.java:1577)
    at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:112)
    at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1414)
    at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:153)
    at com.ssh.dao.PopedomDAO.popedomlist(PopedomDAO.java:70)
    at com.ssh.struts.action.PopedomAction.execute(PopedomAction.java:52)
    at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
    at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
    at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
    at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown Source)
    at com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown Source)
    at com.microsoft.jdbc.base.BasePreparedStatement.preImplExecute(Unknown Source)
    at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
    at com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown Source)
    at com.microsoft.jdbc.base.BasePreparedStatement.execute(Unknown Source)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
    at org.hibernate.dialect.SybaseDialect.getResultSet(SybaseDialect.java:142)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:127)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1269)
    at org.hibernate.loader.Loader.doQuery(Loader.java:391)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
    at org.hibernate.loader.Loader.doList(Loader.java:1593)
    ... 27 more
      

  2.   

    请问现在哪里有hibernate3.1以上版本下载?在官方网站找不到下载?谢谢
      

  3.   

    to 5楼 
    再myEclipse中就有集成的。
      

  4.   

    {?=call getList()}
    你这句什么意思啊?
      

  5.   

    {?=call   getList()} 和这里Query q=session.getNamedQuery("call getList()");的向对应的,
    我是参照这里做的http://www.javaeye.com/topic/24870我的数据库中储存过程如下create proc getList
    as 
    select * from popedom
      

  6.   

         up up up