Dear All,
I tried to insert 1,50,000 records from the Text file to MS-SQL Server through my Java Application.I am using Prepared statement to form the query and executing in the batch of 5,000 records at one time.
but is giving "com.ibm.websphere.jdbc.base.BaseBatchUpdateExcept ion: [IBM][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated" after 1,15000 records being inserted.Please help me if you have any idea about it.

dear amit,
          i think ur problem is , fields of ur data base tables are not matching properly. for example a long value is not setted to int value, i.e long is 8 bytes and int is 4 bytes so even thoug data is numeric, data gets truncated.
                               bye , goodluck.

P.Mallikharjuna Rao