Interested to Buy Any Domain ? << Click Here >> for more details...
What are batch updates. in jdbc
- 2 Answers
- 6412 Views
- Corent Technology, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
what is servlet filter?
How many bytes is a string in java?
What is the life cycle of Servlet?
What are the restrictions that are applied to the java static methods?
What are scriptlets?
Write a program to create a binary Tree ?
What is the indent key?
Can constructor be static or final?
What carriage return means?
What is the collections api in java programming?
Can a class inherit the constructors of its superclass?
What is the unit of plancks constant?
Core Java 
