`

org.springframework.orm.hibernate3.HibernateQueryException: could not locate na

阅读更多

2011-1-10 21:29:19 javax.faces.event.MethodExpressionActionListener processAction
严重: org.springframework.orm.hibernate3.HibernateQueryException: could not locate named parameter [gender];

 

 nested exception is org.hibernate.QueryParameterException: could not locate named parameter [gender]
 at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:657)
 at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
 at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
 at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
 at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedParam(HibernateTemplate.java:947)
 at com.rs.common.core.dao.AbstractDao.getObjectsByQuery(AbstractDao.java:196)
 at com.rs.common.core.dao.UserDaoImpl.getUserByQuery(UserDaoImpl.java:66)
 at com.rs.common.core.service.UserServiceImpl.getUserListPageByCriteria(UserServiceImpl.java:206)
 at com.rs.admin.web.common.accesscontrolmaintenance.controller.AclMemberTableControllerImpl.handleSearch(AclMemberTableControllerImpl.java:114)
 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:592)
 at org.apache.el.parser.AstValue.invoke(AstValue.java:191)
 at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
 at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
 at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:99)
 at javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
 at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:771)
 at javax.faces.component.UICommand.broadcast(UICommand.java:372)
 at com.icesoft.faces.component.panelseries.UISeries$RowEvent.broadcast(UISeries.java:617)
 at com.icesoft.faces.component.panelseries.UISeries.broadcast(UISeries.java:285)
 at com.icesoft.faces.component.paneltabset.PanelTabSet.broadcast(PanelTabSet.java:320)
 at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475)
 at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756)
 at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
 at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
 at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
 at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:18)
 at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.renderCycle(ReceiveSendUpdates.java:132)
 at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.service(ReceiveSendUpdates.java:74)
 at com.icesoft.faces.webapp.http.core.RequestVerifier.service(RequestVerifier.java:31)
 at com.icesoft.faces.webapp.http.common.standard.PathDispatcherServer.service(PathDispatcherServer.java:24)
 at com.icesoft.faces.webapp.http.servlet.BasicAdaptingServlet.service(BasicAdaptingServlet.java:16)
 at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:23)
 at com.icesoft.faces.webapp.http.servlet.SessionDispatcher.service(SessionDispatcher.java:53)
 at com.icesoft.faces.webapp.http.servlet.SessionVerifier.service(SessionVerifier.java:26)
 at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:23)
 at com.icesoft.faces.webapp.http.servlet.MainServlet.service(MainServlet.java:131)

 

 

解决方案:

 

检查你的Hql语句,时候参数设置了. 但是Hql语句中,没有绑定参数..

 

比如Hql语句如下:

private final static String SEARCH_EXISTS_USERLIST_BY_CRITERIA_HQL=" from User user where " +
 " (user.userId not in (:memberExistsUser)) ";

 

只有一个参数..

 

你却在,Map集合中,多添加了一个参数.

Map<String,Object> paramMap =  new HashMap<String,Object>();

paramMap.put("memberExistsUser","1","2","3");

paramMap.put("gender","testError");

 

could not locate named parameter [gender];

..

 

此错误提示,不能找到 参数 gender..

分享到:
评论

相关推荐

    org.springframework.orm.hibernate3.LocalSessionFactoryBean

    在开发基于Spring与Hibernate整合的应用时,可能会遇到“`org.springframework.orm.hibernate3.LocalSessionFactoryBean` not found”这样的错误提示。这个问题通常发生在尝试通过Spring管理Hibernate ...

    org.spring-framework-3.0.4. 所有jar

    org.springframework.orm-3.0.4.RELEASE.jar org.springframework.oxm-3.0.4.RELEASE.jar org.springframework.spring-library-3.0.4.RELEASE.libd org.springframework.test-3.0.4.RELEASE.jar org.spring...

    org.springframework.orm.hibernate4.HibernateOptimisticLockingFailureException

    标题中的"org.springframework.orm.hibernate4.HibernateOptimisticLockingFailureException"是一个具体的异常类型,源自Spring框架的Hibernate4模块。这个异常通常在乐观锁(Optimistic Locking)机制失败时抛出,...

    org.springframework.orm-3.0.0.M1.jar

    org.springframework.orm-3.0.0.M1.jar

    spring3.0.5 所有jar文件

    org.springframework.orm-3.0.5.RELEASE.jar org.springframework.oxm-3.0.5.RELEASE.jar org.springframework.test-3.0.5.RELEASE.jar org.springframework.transaction-3.0.5.RELEASE.jar org.springframework.web...

    spring3.1 官方全部jar包

    org.springframework.orm-3.1.RELEASE.jar org.springframework.oxm-3.1.RELEASE.jar org.springframework.spring-library-3.1.RELEASE.libd org.springframework.test-3.1.RELEASE.jar org.springframework....

    org.springframework.orm.jar.zip

    其中,`org.springframework.orm.jar`是Spring框架中的一个子模块,主要关注对象关系映射(ORM)集成,使得Java应用程序能够方便地与各种数据库进行交互。本文将深入探讨Spring ORM模块的核心概念、功能以及实际应用...

    hibernate错误解决方案

    当执行查询操作时,如果根据指定的ID没有找到对应的实体对象,Hibernate会抛出 `org.springframework.orm.ObjectRetrievalFailureException` 异常。例如,在以下场景中: ``` org.springframework.orm....

    org.springframework.orm-3.1.0.M2

    org.springframework.orm-3.1.0.M2

    spring3.1.1jar及其关联jar

    org.springframework.orm-3.1.1.RELEASE org.springframework.oxm-3.1.1.RELEASE org.springframework.test-3.1.1.RELEASE org.springframework.transaction-3.1.1.RELEASE org.springframework.web.portlet-3.1.1....

    org.springframework.beans-3.0.0.M4.jar

    org.springframework.beans-3.0.0.M4.jar

    org.springframework.orm-3.0.0.M4.jar

    org.springframework.orm-3.0.0.M4.jar

    Spring所需jar包

    org.springframework.orm-3.0.0.RELEASE.jar org.springframework.oxm-3.0.0.RELEASE.jar org.springframework.test-3.0.0.RELEASE.jar org.springframework.transaction-3.0.0.RELEASE.jar org.springframework.web...

    org.springframework.dao.InvalidDataAccessApiUsageException

    &lt;bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager"&gt; ``` 2. **使用 `@Transactional` 注解**: 在Service层或具体的业务逻辑方法上添加 `@...

    spring3.0.0相关jar包

    org.springframework.orm-3.0.0.RELEASE org.springframework.oxm-3.0.0.RELEASE org.springframework.spring-library-3.0.0.RELEASE org.springframework.test-3.0.0.RELEASE org.springframework.transaction-...

    spring-framework-3.0.0.M4-with-docs

    org.springframework.orm-3.0.0.M4.jar: 整合第三方的ORM框架,如hibernate,ibatis,jdo,以及spring的JPA实现 org.springframework.transaction-3.0.0.M4.jar: 为JDBC、Hibernate、JDO、JPA等提供的一致的声明式和...

    解决SpringDataJPA报错:org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null w

    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/...

    Spring高版本对ibatis的支持

    &lt;bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"&gt; &lt;value&gt;classpath:SqlMapConfig.xml &lt;bean id="dao" class="org.springframework.orm.ibatis....

    spring mvc 3.0.5工程所需包整合

    org.springframework.instrument-3.0.5.RELEASE.jar,org.springframework.jdbc-3.0.5.RELEASE.jar,org.springframework.jms-3.0.5.RELEASE.jar,org.springframework.orm-3.0.5.RELEASE.jar,org.springframework....

    SpringMVC开发jar包

    org.springframework.orm-3.1.0.RELEASE.jar org.springframework.oxm-3.1.0.RELEASE.jar org.springframework.test-3.1.0.RELEASE.jar org.springframework.transaction-3.1.0.RELEASE.jar org.springframework.web...

Global site tag (gtag.js) - Google Analytics