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 | 4 months ago
  1. 0

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

    hibernate.org | 4 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

    Data from HSQLDB table into two dimensional array using Java

    Stack Overflow | 5 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
  3. 0

    Hibernate / Mailing Lists

    sourceforge.net | 1 year ago
    org.hibernate.QueryException: Not all named parameters have been set: [] [select a.timeHrs|| ' : ' ||a.timeMins from CreatedTIme a]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

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

    blogjava.net | 8 months 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 | 1 year 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