org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [ch.slf.sdbobj.station.Standort@2ed755] [SELECT i FROM ch.slf.sdbobj.ams.Imis150 as i WHERE i.id.standort in (?) AND i.id.datum = ( SELECT MAX(i1.id.datum) FROM ch.slf.sdbobj.ams.Imis150 as i1 WHERE i1.id.standort = i.id.standort)]

hibernate.org | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Hibernate Community • View topic - QueryException: Expected positional parameter count:...

    hibernate.org | 9 months ago
    org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [ch.slf.sdbobj.station.Standort@2ed755] [SELECT i FROM ch.slf.sdbobj.ams.Imis150 as i WHERE i.id.standort in (?) AND i.id.datum = ( SELECT MAX(i1.id.datum) FROM ch.slf.sdbobj.ams.Imis150 as i1 WHERE i1.id.standort = i.id.standort)]
  2. 0

    Hibernate / Mailing Lists

    sourceforge.net | 2 years ago
    org.hibernate.QueryException: Not all named parameters have been set: [] [select a.timeHrs|| ' : ' ||a.timeMins from CreatedTIme a]
  3. 0

    Data from HSQLDB table into two dimensional array using Java

    Stack Overflow | 6 years ago | Precious
    org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [] [select F.item, F.category, F.amount from LivEx F where F.planName=?] 0 problem
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    2009年7月16日 随笔档案 - JBOSS 点滴 - BlogJava

    blogjava.net | 1 year ago
    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]
  6. 0

    Caused by: org.hibernate.QueryException: Not all named parameters have been set: while using hibernate template

    Stack Overflow | 2 years ago | Soumava Das
    org.hibernate.QueryException: Not all named parameters have been set: [roledesc, sapid, pass] [ select u from Role as r left join r.users as u where u.sapid=:sapid and u.pass=:pass and r.roledesc=:roledesc ]

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.hibernate.QueryException

      Expected positional parameter count: 1, actual parameters: [ch.slf.sdbobj.station.Standort@2ed755] [SELECT i FROM ch.slf.sdbobj.ams.Imis150 as i WHERE i.id.standort in (?) AND i.id.datum = ( SELECT MAX(i1.id.datum) FROM ch.slf.sdbobj.ams.Imis150 as i1 WHERE i1.id.standort = i.id.standort)]

      at org.hibernate.impl.AbstractQueryImpl.verifyParameters()
    2. Hibernate
      QueryImpl.list
      1. org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:141)
      2. org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:102)
      3. org.hibernate.impl.QueryImpl.list(QueryImpl.java:70)
      3 frames
    3. Hibernate
      HibernateTemplate.find
      1. org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:528)
      2. org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:176)
      3. org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:196)
      4. org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:522)
      4 frames
    4. ch.slf.ifkis
      AmsServiceImpl.getLatestImis150DataMap
      1. ch.slf.ifkis.hydro.server.dao.hibernate.AmsDataAccess.getLatestImis150DataList(AmsDataAccess.java:98)
      2. ch.slf.ifkis.hydro.server.service.AmsServiceImpl.getLatestImis150DataMap(AmsServiceImpl.java:89)
      2 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    6. ch.slf.ifkis
      MethodInvoker.invoke
      1. ch.slf.ifkis.base.server.service.AbstractService.invokeMethode(AbstractService.java:267)
      2. ch.slf.ifkis.base.server.service.MethodInvoker.invoke(MethodInvoker.java:51)
      2 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    8. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      3 frames
    9. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
      1 frame
    10. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      2 frames
    11. Unknown
      $Proxy0.invoke
      1. $Proxy0.invoke(Unknown Source)
      1 frame
    12. ch.slf.ifkis
      AbstractService.invoke
      1. ch.slf.ifkis.base.server.service.AbstractService.invoke(AbstractService.java:225)
      1 frame
    13. Unknown
      $Proxy6.getLatestImis150DataMap
      1. $Proxy6.getLatestImis150DataMap(Unknown Source)
      1 frame
    14. ch.slf.ifkis
      AmsViewController.handleDataAktuell
      1. ch.slf.ifkis.hydro.web.view.Imis150ViewController.getLatestDataMap(Imis150ViewController.java:47)
      2. ch.slf.ifkis.hydro.web.view.AmsViewController.handleDataAktuell(AmsViewController.java:133)
      2 frames
    15. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    16. Spring MVC
      FrameworkServlet.doGet
      1. org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:351)
      2. org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:305)
      3. org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
      4. org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
      5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
      6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
      7. org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:386)
      8. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:346)
      8 frames
    17. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      2 frames
    18. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      9 frames
    19. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      4 frames
    20. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      1 frame
    21. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame