JBOSS 點滴

          豐豐的博客

          導航

          <2009年10月>
          27282930123
          45678910
          11121314151617
          18192021222324
          25262728293031
          1234567

          統計

          公告

          我想成功,在老之前!

          常用鏈接

          留言簿(6)

          隨筆分類

          隨筆檔案

          文章分類

          文章檔案

          相冊

          收藏夾

          blogjava

          搜索

          最新評論

          閱讀排行榜

          評論排行榜

          Not all named parameters have been set:

          org.hibernate.QueryException: Not all named parameters have been set: [testv] [select ps.id.hsxmCode,ps.id.spwjCode,ps.mc,ps.lx,ps.parentCode,ps.sfdc,ps.jhStart,ps.jhEnd,ps.sjStart,ps.sjEnd,ps.shdw,ps.shzt,ps.wcbl,ps.flagWc from PubSpwj as ps  where 1=1  and ps.id.hsxmCode=:hsxmCode  and ps.shzt=:testv  order by ps.id.spwjCode]
           at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:115)
           at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:102)
           at org.hibernate.impl.QueryImpl.list(QueryImpl.java:70)
           at com.hs.busimanage.buildprocess.business.EditBProcessBO.queryProcessList(EditBProcessBO.java:78)
           at com.hs.busimanage.buildprocess.struts.action.BProcessListAction.queryBProcessList(BProcessListAction.java:85)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:585)
           at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
           at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
           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.doPost(ActionServlet.java:525)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
           at com.hs.util.common.HSCharsetFilter.doFilter(HSCharsetFilter.java:24)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
           at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
           at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
           at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
           at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
           at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
           at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
           at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
           at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
           at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
           at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
           at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

          解決辦法:在BO里賦查詢條件語句:
            if(testv!=null&&!testv.equals("")) query.setParameter("testv",testv);
             ls=query.list();

          posted on 2009-10-29 17:51 半導體 閱讀(5761) 評論(0)  編輯  收藏


          只有注冊用戶登錄后才能發表評論。


          網站導航:
           
          主站蜘蛛池模板: 泰宁县| 深水埗区| 古丈县| 岗巴县| 浙江省| 梓潼县| 荥经县| 新乡市| 抚顺县| 嘉禾县| 灵台县| 九台市| 黄浦区| 东山县| 枝江市| 岗巴县| 曲松县| 康马县| 万盛区| 独山县| 雷山县| 乌兰县| 施甸县| 嘉祥县| 梅河口市| 峨边| 富宁县| 方正县| 巴青县| 漠河县| 临泽县| 泗阳县| 石河子市| 上犹县| 天气| 马鞍山市| 那曲县| 剑川县| 航空| 印江| 藁城市|