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 jdbc odbc connection?
What is odbc and jdbc in dbms?
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
what does batchUpdate does?
What is jdbc odbc bridge in java?
java based application for hospital management
How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?
What is odbc and jdbc?
What is encrypted connection?
How MS-Access DB can be accessed over a network, using JDBC API?
What is Connection Pooling ??? How we set up a particular connection within connection pooling ????
What is the execute method in java?