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 |
What is the role of the jdbc drivermanager class?
What are database warnings in jdbc and how can we handle database warnings in jdbc?
Can we have foreign key reference to a non primary key column ?
What are the jdbc api components?
What is a jdbc connection pool?
What is the function of drivermanager class?
What is jdbc in java?
What is meant by connection string?
Jdbc-odbc bridge is multi-threaded or not?
what does the method Class.forName returns?
What are the types of jdbc drivers that exist?
What is an outer join?