How to find multiple inset into database success?

[athar]

Hi
I want to know whether multiple rows insertion is success or not? for single am using int iSuccess = stmt.executeUpdate(); How to know whether multiple insert is success?
Thanks

[Tolls]

Are you talking a batch job with multiple insert statements?

[athar]

Hi
No, i have data in List and loop through this list and insert record into database. Here is my code

String qString = "INSERT INTO Estd_Contents( file_ref, a,b ) values (?,?,?)";
PreparedStatement stmt = conSqlServer.prepareStatement(qString);
for(int i = 0; i < lstAllContents.size(); i++)
{
stmt.setString(1, lstAllContents.get(i).getFileRef());
stmt.setDouble(2, lstAllContents.get(i).getNetAmt());
stmt.setString(3, lstAllContents.get(i).getAcctNo());
stmt.executeUpdate();
}
conSqlServer.commit();
System.out.println("Contents inserted successfully!");

Maximum 3500 records i will insert at a time.

[Tolls]

Batch them, for starters.
Doing single inserts like that is not terribly good performance-wise.

for(int i = 0; i < lstAllContents.size(); i++)
{
   stmt.setString(1, lstAllContents.get(i).getFileRef());
   stmt.setDouble(2, lstAllContents.get(i).getNetAmt());
   stmt.setString(3, lstAllContents.get(i).getAcctNo());
   stmt.addBatch();
}
int[] results = stmt.executeBatch();

Then you will be able to see how many succeeded, and which ones (depending on db).

[athar]

Thanks Tolls
it worked. Before it was taking 4 seconds to insert 3500 records and now less than 1 sec

[Tolls]

That's because before you were doing the round trip to the database 3500 times, with all the overhead that entails.
Now you're doing it once.