为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:win7
【CPU】:intel core i5-6400 2.7ghz
【问题描述】*:批量执行sql:
update warehousegoods set currenttotal=currenttotal-11.0 where id=43;
update warehousedrawgoods set facttotal=11.0,state='01',modeFlag='00',operator='00000000012083',operationTime=sysdate where id=60 and goodsid=43;
update warehousePutin set outTotal=outTotal+7.0,surplusTotal=surplusTotal-7.0,state='02' where id=51;
insert into warehouseputindraw(putinId,drawId,factAmount,bureauid) values(51,60,7,'0001');
update warehousePutin set outTotal=outTotal+4.0,surplusTotal=surplusTotal-4.0,state='02' where id=65;
insert into warehouseputindraw(putinId,drawId,factAmount,bureauid) values(65,60,4,'0001');
update warehousedraw set state='01' where id=60;
执行上述几条sql,后台报错(直接在DM管理工具批量执行都ok):
java.sql.BatchUpdateException: 需要更多的参数
at dm.jdbc.driver.DBError.throwBatchUpdateException(DBError.java:726)
at dm.jdbc.driver.DmdbStatement.do_executeBatch(DmdbStatement.java:316)
at dm.jdbc.driver.DmdbStatement.executeBatch(DmdbStatement.java:1455)
看起来像是走了BatchUpdateException 的接口,这个需要有绑定参数的,但是实际上我们没有传入绑定参数报的错?