How to Commit and Roll Back Transactions in JDBC


show more Committing and rolling back transactions provides you with in-depth training on Developer. Taught by David Gassner as part of the Java Database Integration with JDBC show less
please wait ...

Committing and rolling back transactions

A database transaction is one or more actions that are making changes to data in a database server or local database file. Whenever you make changes such as inserts, updates, or deletes, you're creating transactions. And in JDBC, these transactions are what we call auto-committed. That is, if you don't see anything else, the changes that you request are made and committed to the database immediately. But most database management systems give you the ability to explicitly commit and roll back transactions. It depends on what database you're using, and how you're using it.

For example, with MySQL, it depends on what backend database engine you are using. I'm going to go to phpMyAdmin to my Explore California database, and I'll choose one of my tables, the admin table, and I'll go to the Operations tab. Notice that the storage engine for my database tables is innoDB, and I have specifically selected that because innoDB supports transactions, row-level locking foreign keys,...

Committing and rolling back transactions
Video duration: 4m 14s 2h 51m Intermediate

Viewers:

Committing and rolling back transactions provides you with in-depth training on Developer. Taught by David Gassner as part of the Java Database Integration with JDBC

Subject:
Developer
Software:
Java
Author:
please wait ...