开发者

java 1.4 -sql server 2000:not able to insert multiple records into table

开发者 https://www.devze.com 2022-12-09 12:44 出处:网络
INSERT INTO [UPLOAD_FILE_RECORD_FIELDS_DATA]([RECORD_ID], [FIELD_ORDER],[FIELD_VALUE], [ERROR_CODE])

INSERT INTO [UPLOAD_FILE_RECORD_FIELDS_DATA]([RECORD_ID], [FIELD_ORDER], [FIELD_VALUE], [ERROR_CODE])

select ?,?,?,? 
union all 
select ?,?,?,? 
union all 
select ?,?,?,? 

I have to insert multiple records into one table.So i am using query as below.and setting parameter values. But i am getting error code 77.What is cause?

No of records to be 开发者_运维技巧inserted are approx 70000.So i am inserting 100 records in one query and then using addBatch() on preparedstatment 700 times i execute whole batch .


Actually it was not error code 77.it was no of updates per statement.SO Everything is working fine.

0

精彩评论

暂无评论...
验证码 换一张
取 消