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)]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via hibernate.org by Unknown author, 1 year ago
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)]
via Stack Overflow by Soumava Das
, 2 years ago
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 ]
via blogjava.net by Unknown author, 1 year ago
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]
via Stack Overflow by java_user
, 1 year ago
Expected positional parameter count: 2, actual parameters: [MyIstitution, Tue Apr 27 00:00:00 EST 17] [select i from Institution i where i.nameOfInstitution =? and i.creationDate=?]
via sourceforge.net by Unknown author, 2 years ago
Not all named parameters have been set: [] [select a.timeHrs|| ' : ' ||a.timeMins from CreatedTIme a]
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(AbstractQueryImpl.java:141)
at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:102)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:70)
at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:528)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:176)
at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:196)
at ch.slf.ifkis.hydro.server.dao.hibernate.AmsDataAccess.getLatestImis150DataList(AmsDataAccess.java:98)
at ch.slf.ifkis.hydro.server.service.AmsServiceImpl.getLatestImis150DataMap(AmsServiceImpl.java:89)
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 ch.slf.ifkis.base.server.service.AbstractService.invokeMethode(AbstractService.java:267)
at ch.slf.ifkis.base.server.service.MethodInvoker.invoke(MethodInvoker.java:51)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at undefined.$Proxy0.invoke(Unknown Source)
at ch.slf.ifkis.base.server.service.AbstractService.invoke(AbstractService.java:225)
at ch.slf.ifkis.hydro.web.view.Imis150ViewController.getLatestDataMap(Imis150ViewController.java:47)
at ch.slf.ifkis.hydro.web.view.AmsViewController.handleDataAktuell(AmsViewController.java:133)
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.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:351)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:305)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:386)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
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.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at java.lang.Thread.run(Thread.java:595)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Know the solutions? Share your knowledge to help other developers to debug faster.