Announcement Announcement Module
Collapse
No announcement yet.
simplejdbc template batch update is not working Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • simplejdbc template batch update is not working

    Hi All,
    I am using simplejdbctemplate to insert the batchupdate in the following code
    public void importData(final HashMap map)
    {
    if(map.size()>0)
    {

    setIdentityInsert((String)map.get("TableName"),"ON ");
    try
    {
    int[] updateCounts = template.batchUpdate((String) map.get("Query"), (List<Object[]>)map.get("Values"), (int[])map.get("Sqltypes"));




    } catch (Exception ex)
    {
    ex.printStackTrace();

    }
    setIdentityInsert((String)map.get("TableName"),"OF F");
    }
    }
    bur i am getting the following exception
    org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [insert into TURBINE_GROUP(GROUP_NAME,OBJECTDATA) values(?,?)]; nested exception is java.sql.SQLException: Invalid parameter index 3.
    at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.doTranslate(SQLStateSQLExceptionTran slator.java:98)
    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:602)
    at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:614)
    at org.springframework.jdbc.core.JdbcTemplate.batchUp date(JdbcTemplate.java:883)
    at org.springframework.jdbc.core.BatchUpdateUtils.exe cuteBatchUpdate(BatchUpdateUtils.java:32)
    at org.springframework.jdbc.core.simple.SimpleJdbcTem plate.batchUpdate(SimpleJdbcTemplate.java:257)
    at com.intervoice.cc.tools.dbexport.DBExportImpl.impo rtData(DBExportImpl.java:64)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoi npointUsingReflection(AopUtils.java:309)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.invokeJoinpoint(ReflectiveMethodInvocat ion.java:183)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :150)
    at org.springframework.transaction.interceptor.Transa ctionInterceptor.invoke(TransactionInterceptor.jav a:110)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :172)
    at org.springframework.aop.interceptor.ExposeInvocati onInterceptor.invoke(ExposeInvocationInterceptor.j ava:89)
    at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :172)
    at org.springframework.aop.framework.JdkDynamicAopPro xy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy4.importData(Unknown Source)
    at com.intervoice.cc.tools.dbexport.util.SQLUtil.dbim port(SQLUtil.java:186)
    at com.intervoice.cc.tools.dbexport.Main.importData(M ain.java:126)
    at com.intervoice.cc.tools.dbexport.Main.main(Main.ja va:61)
    Caused by: java.sql.SQLException: Invalid parameter index 3.
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.ge tParameter(JtdsPreparedStatement.java:340)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.se tParameter(JtdsPreparedStatement.java:409)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.se tObjectBase(JtdsPreparedStatement.java:395)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.se tObject(JtdsPreparedStatement.java:672)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.setObject(DelegatingPreparedStatement.java:162)
    at org.springframework.jdbc.core.StatementCreatorUtil s.setValue(StatementCreatorUtils.java:356)
    at org.springframework.jdbc.core.StatementCreatorUtil s.setParameterValueInternal(StatementCreatorUtils. java:216)
    at org.springframework.jdbc.core.StatementCreatorUtil s.setParameterValue(StatementCreatorUtils.java:144 )
    at org.springframework.jdbc.core.BatchUpdateUtils.set StatementParameters(BatchUpdateUtils.java:63)
    at org.springframework.jdbc.core.BatchUpdateUtils$1.s etValues(BatchUpdateUtils.java:38)
    at org.springframework.jdbc.core.JdbcTemplate$4.doInP reparedStatement(JdbcTemplate.java:892)
    at org.springframework.jdbc.core.JdbcTemplate$4.doInP reparedStatement(JdbcTemplate.java:1)
    at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:586)
    ... 21 more
Working...
X