java.sql.SQLException: Invalid argument in JDBC call: parameter index out of range: 5

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 Stack Overflow by Lynge
, 2 years ago
Invalid argument in JDBC call: parameter index out of range: 1
via Liferay Issues by Koor Gai, 1 year ago
statement is not in batch mode
via openxava by e-sarge
, 1 year ago
Invalid argument in JDBC call: parameter index out of range: 5
via GitHub by tsuyoshizawa
, 2 years ago
Invalid argument in JDBC call: parameter index out of range: 3
via Stack Overflow by BetaRide
, 2 years ago
Invalid argument in JDBC call
via Stack Overflow by Chia Syn
, 11 months ago
Parameter not set
org.hsqldb.HsqlException: Invalid argument in JDBC call: parameter index out of range: 5	at org.hsqldb.error.Error.error(Unknown Source)	at org.hsqldb.error.Error.error(Unknown Source)	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)	at org.hsqldb.jdbc.JDBCUtil.outOfRangeArgument(Unknown Source)	at org.hsqldb.jdbc.JDBCPreparedStatement.checkSetParameterIndex(Unknown Source)	at org.hsqldb.jdbc.JDBCPreparedStatement.setInt(Unknown Source)	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)	at org.hibernate.type.descriptor.sql.IntegerTypeDescriptor$1.doBind(IntegerTypeDescriptor.java:63)	at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:90)	at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:286)	at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:281)	at org.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:344)	at org.hibernate.type.ManyToOneType.nullSafeSet(ManyToOneType.java:174)	at org.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:344)	at org.hibernate.persister.entity.AbstractEntityPersister.dehydrateId(AbstractEntityPersister.java:2880)	at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2849)	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3121)	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335)	at org.openxava.jpa.impl.EntityManagerDecorator.flush(EntityManagerDecorator.java:157)	at org.openxava.model.impl.JPAPersistenceProvider.flush(JPAPersistenceProvider.java:98)	at org.openxava.model.impl.MapFacadeBean.commitTransaction(MapFacadeBean.java:76)	at org.openxava.model.impl.MapFacadeBean.create(MapFacadeBean.java:46)	at org.openxava.model.MapFacade.create(MapFacade.java:112)	at org.openxava.actions.SaveAction.execute(SaveAction.java:27)	at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:495)	at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:403)	at org.openxava.controller.ModuleManager.execute(ModuleManager.java:360)	at org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:196)	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)	at org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:66)	at org.openxava.web.dwr.Module.getURIAsStream(Module.java:202)	at org.openxava.web.dwr.Module.request(Module.java:61)	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)	at java.lang.reflect.Method.invoke(Method.java:497)	at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)	at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)	at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)	at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)	at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)	at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)	at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)	at java.lang.Thread.run(Thread.java:745)