Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are batch updates. in jdbc

Answers were Sorted based on User's Feedback



What are batch updates. in jdbc..

Answer / gajendra

Batch updates is a facility given by the JDBC to the
application developers to submit a set of SQL update
statements as batch to the database.

st.addBatch("Update statement1");
st.addBatch("Update statement2");
st.addBatch("Update statement3");

int updated[]=st.executeBatch();// This methods throws
BatchUpdateException and SQLException

Is This Answer Correct ?    3 Yes 0 No

What are batch updates. in jdbc..

Answer / vijayakumar chinnasamy

Batch Update provide the functionality of executing a group
of sql statement at single timing.

Steps:

1.set autocommit as false for connection .
connectionObject.setAutoCommit(false);
2.create sql statement and add to statement object.
statementObj.addBatch("sql1");
statementObj.addBatch("sql2");
statementObj.addBatch("sql3");
3.execute the batch of statement using executeBatch().
statementObj.executebatch();
4. commit the connection.
connectionObj.commit();

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Core Java Interview Questions

what is servlet filter?

2 Answers  


Which method returns the length of a string?

0 Answers  


What is the java reflection api? Why it’s so important to have?

0 Answers  


what is the use of thread?Justify it by project point of view

7 Answers  


Can we restart a thread already started in java?

0 Answers  


What is a superclass?

0 Answers  


there are N number of matchboxes numbered 1...N.each matchbox contain various number of stick.Two player can alternatevely pick some amount of stick from the higest stick containing box . The player is condidered win if there is no stick after his move.Find the final move so that the move player win. Note:In case the number of stick is equal ,pick the stick from the higest numbered box.

0 Answers   Manhattan,


What is a serializable interface?

4 Answers  


what is mutual exclusion? How can you take care of mutual exclusion using java threads? : Java thread

0 Answers  


What is the declaration statement?

0 Answers  


What is the maximum length of a url?

0 Answers  


is it possible to add a object in a HASHMAP

6 Answers   HCL,


Categories