In the previous posts, we read about database transactions and how we can manage them in Java and PHP on different layers. In this post, we will read about data concurrency/consistency and figure out how to properly set the isolation level of an explicit DBMS transaction. We will see several examples using three distinct RDBMS: … Read moreDatabase – Data Concurrency, Data Consistency and Isolation Level
Starting from ACID properties, in the previous post, we have seen how transactions are handled by JDBC and by the abstracted layers written using JAVA as a programming language. What does it change if we are going to use PHP? How many layers and methodologies are provided? Let’s figure it out together! Mysqli: vendor specific … Read moreTransaction in PHP: from Mysqli to PDO and Doctrine transaction handling
In this reading, we are going to understand how transactions are handled in a plain old JDBC transaction management and, later, how Spring Framework’s declarative transaction management is made possible with Spring aspect-oriented programming (AOP) (official Spring documentation). In the final part, we are also going to talk about TransactionTemplate!
Introduction In this reading, we will explain some principles on which database transactions are based: ACID Properties (don’t forget to read about Jim GRAY) and CAP Theorem. Transaction A transaction is a single logical unit of work that reads, and possibly changes, the contents of a database. Transactions are made up of one or more … Read moreTransaction: ACID Properties and CAP Theorem