Interested to Buy Any Domain ? << Click Here >> for more details...
What are batch updates. in jdbc
- 2 Answers
- 6309 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 causes memory leaks in java?
How many types of memory areas are allocated by jvm?
What is fundamental datatype?
What data structures are used to perform recursion?
0 Answers Akamai Technologies,
Is java free for businesses?
Java support what type of parameter passing ?
Can we declare variables inside a method as Final Variables?
Where is singleton pattern used?
Which is the best way of exception handling?
How to access a method that it declared as protected?
What are the advantages of java over C++?
What are the different types of java?
Core Java 
