How transactions are performed using JDBC ?
Answers were Sorted based on User's Feedback
Answer / devarathnam c,kotagudibanda(po
Hi... Using the following methods we can perform
transactions in JDBC
1:commit();
2:rollback();
3:setAutoCommit();These are in the Connection interface
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ketan
transaction means two or more queries are perform
simultaneously.
1. Hence befor first query put up setAutoCommit(false);
2. now at the end of several queries performed. if you know
how much rows will affect this transaction then you can
compare it with current transaction rows.
3. if both equals then commit() and setAutoCommit to true in
else rollback() and setAutoCommit(true).
4. as well as in catch statement put rollback() and
setAutoCommit(true);
5. and in finally setAutoCommit(true).
| Is This Answer Correct ? | 0 Yes | 0 No |
How to connect multiple database in jdbc?
What is DML?
What are the different types of interfaces in the api component?
List the advantages of using datasource?
What is Statement and PreparedStatement? whatz the difference?
How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?
What is Apache DBCP API?
Explain about column name and getter method?
What is difference between statement and preparedstatement in jdbc?
how we can remove hard code in java?
What is ojdbc?
PreparedStatement is a pre compiled statement but where it's pre compiled ?