Results 1 to 3 of 3

Thread: batch updated

  1. #1
    swati.jyoti is offline Member
    Join Date
    Mar 2009
    Posts
    42
    Rep Power
    0

    Default batch updated

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

  2. #2
    RamyaSivakanth's Avatar
    RamyaSivakanth is offline Senior Member
    Join Date
    Apr 2009
    Location
    Chennai
    Posts
    844
    Rep Power
    6

    Default

    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.
    Ramya:cool:

  3. #3
    venkatallu is offline Member
    Join Date
    Sep 2008
    Posts
    16
    Rep Power
    0

    Default

    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.

Similar Threads

  1. Replies: 3
    Last Post: 04-24-2009, 07:28 PM
  2. why my image is not updated ?
    By aneuryzma in forum New To Java
    Replies: 4
    Last Post: 08-15-2008, 01:08 AM
  3. Number of updated records
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-21-2008, 05:32 PM
  4. Updated Forum Rules
    By levent in forum Suggestions & Feedback
    Replies: 1
    Last Post: 08-12-2007, 02:09 PM
  5. Replies: 1
    Last Post: 08-07-2007, 06:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •