Spring entry (3) [transaction control], spring entry transaction control
The database needs to be operated during development, and the process of adding, deleting, and modifying operations is one operation. If you need to update multiple tables in a
MySQL's transactional support is not tied to the MySQL server itself, but is related to the storage engine 1. MyISAM: Transaction not supported, for read-only program lift high performance 2.InnoDB: Acid transaction, row level lock, concurrent
PrefaceThis is hibernate's last article, the next series will explain Struts2 things, and then finish Struts2, in to spring, and then write an SSH how to integrate the case. After that, I'm going to talk about SSM, and then my own personal blog
1. Inconsistent data in database transaction processingIn the case of multiple transactions concurrently doing database operations, if there is no effective mechanism to avoid, there will be a variety of problems. There are generally four types of
MySQL Stored Procedure Transaction Management and mysql Stored Procedure transaction
ACID: Atomic, Consistent, Isolated, Durable
A storage program provides an excellent mechanism to define, encapsulate, and manage transactions.
1. MySQL
The previous article introduced the JDBC transaction, JDBC can handle the transaction of a single data source, satisfies most transaction processing requirements, but the JDBC transaction does not solve the problem of multi-data source and
Introduction: Mycat has become a powerful open source distributed database middleware product. In the face of enterprise application of massive data transaction processing, is currently the best open source solution. However, if you want to keep the
1. What is a transaction: a transaction is an inseparable logical unit of work. It is used as the smallest control unit to execute concurrent operations on the database system. All the database operation commands contained in the database are
Transaction Processing
A transaction is a mechanism that ensures that multiple SQL statements are treated as a single work order.
To process. Transactions have the following roles:
* Consistency: the query and update operations at the same time do
Objective:
We all know the nature of the transaction, in order to maintain these properties, especially the consistency and isolation of the database, the use of locks is generally used in this way. At the same time, the database is a high
MySQL InnoDB Transaction isolation level dirty read, Repeatable read, phantom read
MySQL InnoDB transactions are isolated at four levels. The default value is repeatable read ).
· READUNCOMMITTED ). Another transaction modifies the data but has not
In spring, declarative transactions are defined by transaction parameters. A transaction parameter is a description of how a transaction policy should be applied to a method, as shown in a total of 5 aspects of a transaction parameter:Propagation
One Spring transaction is widely used by transactions. One transaction method should not call another transaction method. Otherwise, two transactions will be generated. As a result, developers are tied up when designing transaction methods for fear
One, propagation (the propagation property of a transaction)The Propagation:key property determines which method the agent should add the transaction behavior to. The most important part of such a property is the propagation behavior.The following
One, propagation (the propagation property of a transaction)The Propagation:key property determines which method the agent should add the transaction behavior to. The most important part of such a property is the propagation behavior. The following
There are six transactional propagation properties defined in spring, and if you don't seem intuitive enough, I'm going to paste a translation that's all over the street.
Reference
L propagation_required-supports the current transaction, and creates
Source: ReprintMySQL's transactional support is not tied to the MySQL server itself, but is related to the storage engine 1. MyISAM: Transaction not supported, for read-only program lift high performance 2.InnoDB: Acid transaction support, row level
What is a transaction?
Is a mechanism, an operation sequence, it contains a group of database operation commands, and all the commands as a whole, together to submit or cancel the operation request to the system. It consists of one or more SQL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.