注册

java.sql.BatchUpdateException: 需要更多的参数

仓库办公软件saas服务商@赵建军 2023/09/08 730 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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)

回答 0
暂无回答
扫一扫
联系客服