What are batch updates. in jdbc

Question Posted / gopalraop

2 Answers
5422 Views
Corent Technology, I also Faced
E-Mail Answers

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