Expected positional parameter count: 1, actual parameters: [] [select count(*) from ClaimVoucher whe

最新推荐文章于 2021-04-19 11:37:49 发布
最新推荐文章于 2021-04-19 11:37:49 发布
阅读量980 收藏
点赞数
分类专栏： Hibernate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jack_zhs/article/details/86028490
版权

ssh项目做一个分页功能的查询总记录数时遇到报错信息：

Struts Problem Report

Struts has detected an unhandled exception:

Messages:
  1. Expected positional parameter count: 1, actual parameters: [] [select count(*) from ClaimVoucher where creator.sn = ?]
  2. Expected positional parameter count: 1, actual parameters: [] [select count(*) from ClaimVoucher where creator.sn = ?]; nested exception is org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [select count(*) from ClaimVoucher where creator.sn = ?]
File:org/hibernate/impl/AbstractQueryImpl.java
Line number:366

Stacktraces

org.springframework.orm.hibernate3.HibernateQueryException: Expected positional parameter count: 1, actual parameters: [] [select count(*) from ClaimVoucher where creator.sn = ?]; nested exception is org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [select count(*) from ClaimVoucher where creator.sn = ?]

    org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:656)
    org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412)
    org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:375)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:913)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:905)
    cn.jboa.dao.impl.BaseHibernateDaoSupport.getTotalCount(BaseHibernateDaoSupport.java:107)
    cn.jboa.service.impl.ClaimVoucherServiceImpl.getClaimVoucherPage(ClaimVoucherServiceImpl.java:78)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    com.sun.proxy.$Proxy5.getClaimVoucherPage(Unknown Source)
    cn.jboa.action.ClaimVoucherAction.searchClaimVoucher(ClaimVoucherAction.java:69)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
    org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:139)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:562)
    org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
    org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    java.lang.Thread.run(Unknown Source)

org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [select count(*) from ClaimVoucher where creator.sn = ?]

    org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:366)
    org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:322)
    org.hibernate.impl.QueryImpl.list(QueryImpl.java:98)
    org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:922)
    org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:913)
    org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:407)
    org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:375)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:913)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:905)
    cn.jboa.dao.impl.BaseHibernateDaoSupport.getTotalCount(BaseHibernateDaoSupport.java:107)
    cn.jboa.service.impl.ClaimVoucherServiceImpl.getClaimVoucherPage(ClaimVoucherServiceImpl.java:78)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    com.sun.proxy.$Proxy5.getClaimVoucherPage(Unknown Source)
    cn.jboa.action.ClaimVoucherAction.searchClaimVoucher(ClaimVoucherAction.java:69)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
    org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:139)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:562)
    org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
    org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    java.lang.Thread.run(Unknown Source)

我的dao层抽象基类：

//查询对象条目数
	@Override
	public Number getTotalCount(String hql, Object... values) {
		if(hql.startsWith("select ")){
			hql="select count(*) "+hql.substring(hql.indexOf(" from ")+1);
		}else{
			hql="select count(*) "+hql;
		}
		return (Number) this.getHibernateTemplate().find(hql).get(0);
	}
//定义属性
//hql语句
	StringBuilder sqlBuilder=new StringBuilder
			("from ClaimVoucher where creator.sn = ?");
	List<Object> values=new ArrayList<>();
	values.add(createSn);
//调用方法其中claimVoucherDao继承了抽象父类
int count=claimVoucherDao.getTotalCount(sqlBuilder.toString(), values.toArray()).intValue();

出错原因是：return (Number) this.getHibernateTemplate().find(hql).get(0);这个方法大意了忘记把values加进去了

改成return (Number) this.getHibernateTemplate().find(hql，values).get(0);问题解决；

另外关于getHibernateTemplate().find方法的使用https://www.cnblogs.com/fengjunming/p/7228196.html

jack_zhs
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Hibernate异常之org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters
静若清池，动如涟漪_
08-01 2373
1、异常描述 org.hibernate.QueryException: Expected positional parameter count: 1,actual parameters: [] [from Student where name like ?] 备注： 此处hibernate版本号：3.6.10.Final 2、示例代码 2-1 StudentDao.jav...
expected-exit-status:CLI检查命令退出状态是否正常
05-01
expected-exit-status 1 --command "exit 1" // $? => 0 $ expected-exit-status 0 --command "exit 1" // $? => 1用例如果要测试“ abc-command”是否应该失败（退出状态1 ），则可以编写以下内容。 $ expecte
Expected positional parameter count: 1, actual p
xiantingxinbuone的专栏
08-15 6282
rg.hibernate.QueryException: Expected positional parameter count: 2, actual parameters: [] [SELECT * from Ad where gr_id = ? and adst_id = ?] 这样的异常主要原因是： //以下为例子 Query query =session.getNamed
Expected positional parameter count: 1, actual parameters: [002]
m0_38113064的博客
08-12 2161
首先从错误信息进行解读，期望的参数个数为1个，实际参数为一个数组类型的。 说明此时占位符（?）与你传递的参数个数不一致，此时检查下 参数是否遗漏后者是未填写吧。 String hql = "from BaseDict where dict_type_code = ?"; return (List<BaseDict>)this.getHibernateTemplate().find(hq...
Expected positional parameter count: 1, actual parameters: []
nicepuppy的专栏
04-19 538
Expected positional parameter count: 1, actual parameters: [] 这问题看上去像sql语句中？的个数与实际的参数个数不匹配，实际问题是使用了hql，hql中字段与表映射中的字段大小写不一致导致的。
org.hibernate.QueryException:Expected positional parameter count: 1
༺ bestcxx的专栏 ༻
06-01 1025
org.hibernate.QueryException:Expected positional parameter count: 1   org.hibernate.QueryException:Expected positional parameter count: 1, actual parameters: [] [from LhClient c where c.wnamw
Expected positional parameter count: 1, actual parameters: [] [{ call proc1(?)}]
lzjzlzw的博客
06-02 2456
使用hibernate调用存储过程查询oracle数据库数据 此错误产生原因：hbm配置文件中标签中缺少代码导致不能调用存储方法 解决方法：在标签中添加callable="true"属性即可，该属性默认为false 错误代码展示： 解决方法示例：
登录发生问题提出：Expected one result (or null) to be returned by selectOne(), but found: 2
12-14
1.查询一条数据，但返回两条数据： 2.查询多条数据，但是前台限制只能查询一条 (1) 检查数据sql语句写对没有 (2) 查看mybaties的返回值（resultType或resultMap），可以返回list，map等数据 (3) dao层接口要与...
求救！！mybatis Expected one result (or null) to be returned by selectOne(), but found:18
12-14
Expected one result (or null) to be returned by selectOne(), but found:18 下面展示一些 mapper.xml。 SELECT st.title as titlest ,st.info_text as info_text , sbt.title as titlesbt,sbt.icon as icon...
精心整理的ssh2 一些错误问题的记录（推荐）
05-24
ssh2 一些错误问题的记录
expected:C ++ 111417标准
04-28
std::expected单个标头实现，带有功能样式的扩展名。 lang + GCC： MSVC： 在和上可用。 建议使用作为表示对象的首选方法，该对象将具有预期值或意外值，以提供有关某些原因的信息。 不幸的是，将许多可能失败的...
SSH：Expected positional parameter count: 1, actual parameters: [123] [from User where username = ?];
努力给自己想要的
03-20 653
【背景】   在用idea苦战了一周后，也没配置好SSH的环境，后来还是选择MyEclipse，真舒服~ 。立马运行成功，谁料问题接踵而来，连绵不绝。@#￥！~ 在敲第一个小功能，进行AJAX异步效验用户名是否存在，结果又报错了，这个“开头”有点难啊。 【问题】 控制台报错信息： ERROR Dispatcher:38 - Exception occurred during processing ...
关于Expected positional parameter count的问题！
热门推荐
u014100278的专栏
03-20 2万+
框架： webwork+spring+hibernate   错误： org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [from Yg where bm.bmid=?] org.hibernate.QueryException: Expected pos
周报-org.hibernate.QueryException:Expected positional parameter count: 1,
zhouxi19880701的专栏
11-18 1万+
<br />1.错误：org.hibernate.QueryException:Expected positional parameter count: 1, actual parameters: [] [from Mb as a where a.jsId.username=?]<br />2.解决方法：<br />Query query=session.createQuery("from Mb as a where a.jsId.username=?");<br /> query.setParameter
Expected positional parameter count: 4, actual parameters
weixin_38919176的博客
10-26 307
原因：问号个数和参数个数不一致 select s.id ,s.name from student s where s.id = ? and t.startdate = ? and t.enddate = ? and s.id = ?
Expected positional parameter count: 1, actual 0 错误
zr_1877的博客
01-08 1272
错误上说：设置了参数位，实际没有？嗯，回去检查了HQL语句，发现一个方法中的HQL中设置了参数位，并且使用它作为参数创建了一个Query对象，但忘记设置这个参数了。。。好吧，添上query.setParameter(* , ***)后正常。
JavaEE开发遇到的异常：Expected positional parameter count:
Cheang_Bokgaai的博客
06-09 2153
在采用strtus+hibernate+spring的开发框架进行编程时，遇到了org.hibernate.QueryException: Expected positional parameter count:这个异常。异常具体为：dao层对应的代码为：                                String queryString="from Classes where E...
总结遇到的错误
zhangsan_321的博客
08-04 5184
严重: Exception occurred during processing request: Expected positional parameter count: 1, actual parameters: [] [from UserBean where id =? ]; nested exception is org.hibernate.QueryException: Expected
Incorrect column count: expected 1, actual 42
最新发布
08-30
在你提供的引用中，你遇到了一个错误消息" Incorrect column count: expected 1, actual 42"。这个错误消息表示实际返回的列数与期望的列数不一致。根据你的描述，你使用的是jdbcTemplate的queryForList方法，它期望返回单列对象或者返回一个包含多个列的List<Map<String, Object>>对象。 根据你的代码和问题描述，我猜测你在使用queryForList方法时可能出现了以下问题： 1. 你的SQL查询语句返回了42列，而queryForList方法期望只返回1列。 2. 你可能没有正确地配置单列映射器(singleColumnRowMapper)，导致报错。 要解决这个问题，你可以尝试以下几点： 1. 确认你的SQL查询语句是否正确，确保它只返回了1列。如果你的SQL查询语句返回了多列，你可以考虑使用query方法并结合BeanPropertyRowMapper来直接返回对象集合。 2. 确认你正确配置了单列映射器(singleColumnRowMapper)。你需要确保映射器的列数与实际返回的列数一致。 综上所述，你遇到的错误是由于实际返回的列数与期望的列数不一致所导致的。你可以通过检查SQL查询语句和正确配置单列映射器来解决这个问题。<span class="em">1</span><span class="em">2</span> #### 引用[.reference_title] - *1* [jdbcTemplate报错：Incorrect column count: expected 1, actual 2](https://blog.csdn.net/happy488127311/article/details/120591563)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] - *2* [EurekaLog_7.5.0.0_Enterprise](https://download.csdn.net/download/jsdf007/9683759)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值