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

Question

INSERT INTO UPLOAD_FILE_RECORD_FIELDS_DATA

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 .

Answer 1

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