View, trigger, stored procedure, function, process control, transaction
1, View
View is a virtual table (non real). Its essence is to obtain a dynamic data set according to SQL statements and name it. When using, users only need to use the name to obtain the result set, which can be used as a table.
Using the view, we can pick out the temporary table in the query process and implement it with the view. In t ...
Added by narked on Mon, 07 Mar 2022 19:30:05 +0200
Conclusion of Spring boot integrated learning 1.0: exception handling, integration of Mybatis, transaction, cache, JPA, dynamic log, RabbitMq, sending mail, background operation and deployment
https://blog.didispace.com/spring-boot-learning-1x/
1. Unified exception handling of application
Spring Boot provides a default mapping: / error. When an exception is thrown during processing, it will be transferred to the request for processing, and the request has a global error page to display the exception content.
Access a nonexistent U ...
Added by mizz key_me on Sat, 05 Mar 2022 09:12:53 +0200
Learn Spring - JdbcTemplate and Spring transactions from scratch
1. jdbcTemplate
1.1 basic concepts
JdbcTemplate is a template object provided in the spring framework. It is a simple encapsulation of the original cumbersome Jdbc API object Core object JdbcTemplate jdbcTemplate = new JdbcTemplate(DataSource dataSource);
Core method Execute addition, deletion and modification statements
int update();
/ ...
Added by salomo on Wed, 02 Feb 2022 10:35:43 +0200
Spring AOP learning -- Introduction and principle of spring transaction
Transaction introduction
The previous article introduced spring AOP. Spring transaction is a typical application of spring AOP.
Transaction is the database transaction, which means that the reading and writing of data in the same batch are either all successful or all failed to ensure the consistency of data. It is the core function of th ...
Added by ctsiow on Sun, 30 Jan 2022 14:06:36 +0200
Seven propagation behaviors of Spring transactions
1. Required (default)
Meaning: use the current transaction. If there is no transaction, create a new transaction. The sub method must run in a transaction; If there is a transaction, join the transaction as a whole. For example: if the leader has no food, I have money, I will buy it myself and eat it myself; If some leaders eat, they will shar ...
Added by megaalf on Mon, 10 Jan 2022 15:23:53 +0200
Solution to distributed transaction - seata
Recommended - seata
Official website: https://seata.io/zh-cn/
Seata currently has three distributed transaction implementation schemes: AT, TCC and SAGA
AT mode mainly focuses on the data consistency of multi DB access. Of course, it also includes the 2PC improvement of multi DB data access consistency under multi servicesTCC mode mainly foc ...
Added by birwin on Sat, 01 Jan 2022 22:48:07 +0200
Spring(SpringBoot) -- transaction propagation mechanism -- Application / instance / detailed explanation
Original website:
brief introduction
This paper introduces the transaction propagation mechanism in Spring, and illustrates its usage with an example.
This content is also a common question in Java back-end interview.
summary
Spring specifies seven types ...
Added by kyberfabrikken on Wed, 17 Nov 2021 14:20:46 +0200
How to implement a solution to avoid message duplication?
Problem Description
Message middleware is a component commonly used in distributed systems and is widely used in asynchronization, decoupling and peak-clipping of systems.Message middleware is generally considered a reliable component, that is, messages are not lost as long as they are delivered to the message middleware.
Therefore, it ca ...
Added by XZer0cool on Wed, 01 Sep 2021 19:36:24 +0300