Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed

background mybatis is used only, but spring is not used because it involves multiple data sources, so each query uses the mapper factory method to create mappers to execute select or Update. Executor was closed when the same mapper executed select and executed update. Solve Log 2018-05-30 17:09:58,941 DEBUG [org.apache ...

Posted by JayFM on Wed, 06 Feb 2019 08:54:16 -0800

Spring Cloud Spring Boot mybatis Distributed Microservice Cloud Architecture (19) Configuration and Use of Multiple Data Sources (1)

Previously, when introducing the use of JdbcTemplate and Spring-data-jpa, single data sources were used. In the case of a single data source, the configuration of Spring Boot is very simple, just need to configure the connection parameters in the application.properties file. However, with the development of business, we usually split the databa ...

Posted by Cochise on Wed, 06 Feb 2019 01:57:17 -0800

Sprboot Series III: Sprboot Integration Jdbc Template

In the first two articles, we talked about two things: Getting started with spring boot through a simple example Modify the default service port number and context path of spring boot In this article, we'll look at how to persist data through JdbcTemplate. Don't talk too much nonsense, go straight to dry goods. I. Code Implementation Modify ...

Posted by mcdsoftware on Tue, 05 Feb 2019 22:42:17 -0800

MySQL Installation Sample Database (employee, world, sakila, menagerie, etc.)

sakila sample database official information and installation instructions Notice if the supported version of the sample database matches your database. In order to test, sometimes a large number of data sets are needed. MySQL Official provides a sample database for testing. The download page is in the Here. Now take the saki ...

Posted by congos on Tue, 05 Feb 2019 10:48:15 -0800

ERROR 1044 (42000): Access denied for user 'root'@'localhost'

Take over a MySQL database from the vendor (the database version is 5.7.21 MySQL Community Server (GPL)) and encounter an ERROR 1044 (42000) error when creating an account: Access denied for user'root'@'localhost' to database xxx, as shown below.     mysql> grant all on xxx.* to xxx@'192.168.%' identified by 'xxx'; ERROR 1044 (42000): Acces ...

Posted by Push Eject on Tue, 05 Feb 2019 03:36:16 -0800

PHP of MySQL implements sorting & grouping & connection &NULL

ORDER BY grammar SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]] Use the ORDER BY clause in PHP scripts <?php $dbhost = 'localhost:3306'; // mysql server host address $dbuser = 'root'; // mysql username $dbpass = '123456'; // mysql username passw ...

Posted by ijmccoy on Tue, 05 Feb 2019 03:15:17 -0800

Use of MySQL 10-count,sum,avg,max,min functions from scratch

The previous section describes the composition and use of select statements.( select statement and the use of where, order by, group by clauses However, relying solely on the words and sentences of select can not give full play to the ability of select. This section will introduce the collocation of select and function. The te ...

Posted by ryanh_106 on Tue, 05 Feb 2019 02:00:16 -0800

CentOS 6u9 Intrusion Detection System Based on Snort+Barnyard2+Base

Brief description: This experiment is based on blog https://www.cnblogs.com/zlslch/p/7306632.html. The IDS is an intrusion detection system based on LAMP architecture. The core components are Snort, Barnyard2 and Base. Intrusion Detection Using Snort and Output to alert File Use Barnyard2 to read alert file format and output ...

Posted by BSkopnik on Mon, 04 Feb 2019 22:57:17 -0800

CentOS 6.8 installs mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz

1. Download Compressed Files on mysql Official Website https://dev.mysql.com/downloads/mysql/5.7.html#downloads 2. Copy the downloaded files to the / opt directory of centos system III. Start installation 1. Decompress mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz [root@centosDemo opt]# tar -zxvf mysql-5.7.22-linux-glibc ...

Posted by cookspyder on Mon, 04 Feb 2019 16:42:16 -0800

Failed on my_net_write()

Introduction Log error 2018-07-16T16:48:58.391994+08:00 77 [Note] Aborted connection 77 to db: 'unconnected' user: 'ashe' host: '127.0.0.1' (Failed on my_net_write()) We know that mysqld is a multi-threaded C/S architecture network application, so it is necessary to read and write data through the network, so there may be ...

Posted by wedge00 on Mon, 04 Feb 2019 15:36:16 -0800