batch updated

[swati.jyoti]

Pls tell me the following-:
1. what is batch update in Sql.
2. Advantage of using it.

[RamyaSivakanth]

If you want to perform bunch of updates/insert at once ,then we can go for batch.
The entire bunch can be bundled into a single transaction so that entire unit can be commited/rolledback.

The batch updates are being supported by JDBC2.0.

[venkatallu]

Hi swathi
batchUpdate() is for executing more than one query at a time.
Adavatange is,for every sql query u need not send to DB server.
There no n/w traffic b/w client and DB server.So performance wil increase.