Dynamic SQL error -- using clause doesn't match dynamic parameter specification in statement STMT00000001

[java freak]

All,

Environment : IDMS DB, WAS 6.1 App server

I am getting the below mentioned error in our integrated development
environment and not in the local development environment. I verified
for extra columns or parameters and it turned out be correct. But
still I am getting the exception.

Any insight into this issue is really appreciated.

The sql and the inputs were :

update HIDIDAQ.HIRE set HIRE_ACTV_INACTV_SW = ?,
HIRE_ORG_CODE = ?, HIRE_ADM_RGN_CD = ?, HIRE_RGN_CD = ?,
HIRE_POS_CAT_CD = ?, HIRE_PROG = ?, HIRE_DIST = ?, HIRE_LOC = ?,
HIRE_PROJ = ?, HIRE_POS_TITLE = ?, HIRE_PAY_PLAN = ?,
HIRE_OFFICER_POS_IND = ?, HIRE_POSTS_VICE_INCMB_SW = ?,
HIRE_PRIOR_INC_LAST_NAME = ?, HIRE_PRIOR_INC_FIRST_NAME = ?,
HIRE_PRIOR_INC_MI = ?, HIRE_EARLY_RECRUIT = ?, HIRE_NEW_POS_IND = ?,
HIRE_VNBR_REQUIRED_IND = ?, HIRE_SF52_FUND_DATE = ?,
HIRE_SF52_RCVD_DATE = ?, HIRE_POS_VACATE_DATE = ?, HIRE_SERIES = ?,
HIRE_OVS_FY = ?, HIRE_POSITION_NR = ?, HIRE_TARGET_GRADE = ?,
HIRE_UPDATE_USER = ?, HIRE_UPDATE_DATE = ?, HIRE_PROJECTED_EOD_DATE
= ? where HIRE_SF52_KEY = ?
A(String),
BB1861010000000000(String), (String),
O(String), O(String), 3119(String),
FAT(String), FAT(String), 000(String), IMMGRTN
(String), GL(String),
O(String), (String),
(String), ( String),
(String), N(String),
N(String), Y(String),
0(Integer), 0(Integer),
0(Integer), 1801(Integer), 2011(Integer),
0(Integer), 9(Integer), COW7024Z(String),
20110526(Integer), 20110424(Integer),
OVS03210002401(String)

### Error updating database. Cause: java.sql.SQLException: DB001085
T606 C-4M321: Dynamic SQL error -- using clause doesn't match dynamic
parameter specification in statement STMT00000001
### The error may involve com.hits.map.HirhireMapper.saveInfo-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLException: DB001085 T606 C-4M321: Dynamic SQL
error -- using clause doesn't match dynamic parameter specification in
statement STMT00000001

org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLException: DB001085
T606 C-4M321: Dynamic SQL error -- using clause doesn't match dynamic
parameter specification in statement STMT00000001
### The error may involve com.hits.map.HirhireMapper.saveInfo-Inline
### The error occurred while setting parameters
### Cause: java.sql.SQLException: DB001085 T606 C-4M321: Dynamic SQL
error -- using clause doesn't match dynamic parameter specification in
statement STMT00000001
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:
8)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:
100)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:
57)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:35)
at $Proxy15.saveInfo(Unknown Source)
at com.hits.dao.Sf52DAOImpl.saveInfo(Unknown Source)
at com.hits.service.Sf52ServiceImpl.convertToOvs(Unknown Source)
at com.hits.action.Sf52HiringAction.convert(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
79)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:618)
at
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:
452)
at
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:
291)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
254)
at
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:
176)
at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
98)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:
50)
at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
98)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:
133)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:
207)
at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
98)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:
207)
at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
98)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:
190)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:
75)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:
94)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:
243)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:
100)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:
141)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:
267)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:
142)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:
166)
at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
98)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:
176)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:
164)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:
190)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:
187)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at com.struts2.interceptor.XssFilterInterceptor.intercept(Unknown
Source)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
com.struts2.interceptor.RedirectMessageInterceptor.doIntercept(Unknown
Source)
at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:
98)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:
248)
at
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:
52)
at
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:
485)
at
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:
77)
at
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:
91)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:
190)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:
130)
at com.hits.common.AuthorizationFilter.doFilter(Unknown Source)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:
190)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:
130)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:
87)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:
850)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:
760)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:
713)
at
com.ibm.ws.wswebcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:
132)
at
com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.invokeFilters(DefaultExtensionProcessor.java:
894)
at
com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:
819)
at
com.ibm.ws.wswebcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:
113)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:
3574)
at
com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:
269)
at
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:
831)
at
com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:
1478)
at
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:
133)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:
450)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:
508)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:
296)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:
102)
at
com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:
165)
at
com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:
217)
at
com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:
161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
at
com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:
751)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1551)