CentOS+Docker+Mysql+Gerrit+Nginx configuration

Software environment: CentOS 7.0 Docker 18.06.0-ce Following is the docker image Mysql 5.7 Gerrit 2.15.3 Nginx 1.15.2-alpine Assume that the current server ip address is (all three software are on the same server) 192.168.0.1 Note: When using docker image, it is strongly recommended to fix the mirror version number o ...

Posted by voltrader on Fri, 21 Dec 2018 21:51:05 -0800

No operations allowed after connection close error occurred in Spring Book environment

Spring Cloud + Spring MVC + Spring Data JPA + MySql + Postgresql Among them, the project is equipped with multiple data sources, and there is no problem in the early development test, but when the project is tested on the server, the next morning there is an abnormal database connection. After checking the log, the following ex ...

Posted by successor on Thu, 20 Dec 2018 09:15:05 -0800

java jdbc curd && learning document [translation]

jdbc tutorial https://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm (English) http://www.yiibai.com/jdbc/jdbc-sample-code.html#article-start (Chinese) jdbc curd example http://www.codejava.net/java-se/jdbc/jdbc-tutorial-sql-insert-select-update-and-delete-examples (English) http://www.cnblogs.com/sbj-dawn/p/7111990.html (Chinese) 2 Crea ...

Posted by TwistedLogix on Thu, 20 Dec 2018 02:24:04 -0800

ssm project uses Mybatis dynamic splicing sql statements, the generated sql Chinese is displayed as??? Questions (Chinese parsing of configuration file sql statements)

Scene reappearance There is a table. Now we want to query whether a character field in the table contains some keywords. Example: there is a field tag in the table; now it is to determine whether the tag contains keywords, the number of keywords is uncertain, so we need to use dynamic sql statements to splice, and screen out tags that cont ...

Posted by alpinec on Wed, 19 Dec 2018 20:18:05 -0800

MySQL Foundation - 1 - row_number () over (partition by expr1, expr2... order by expr1)

In the project, you see that the designer provides an sql question, using row_number() and over() functions. I don't even understand MySQL, so it's a bit too difficult for me. I'll record the replacement of the function of the question, and I don't know if anyone can use it. demand Once processed by functions on the title, the original t ...

Posted by freynolds on Wed, 19 Dec 2018 18:45:05 -0800

Resolution of mysql No operations allowed after connection closed connection exception

Spring Boot Multi-data Source Configuration and No Operation Allowed After Connected Closed Connection Anomaly Solution Recently, when the project went online, it encountered a weird bug. Let's start with my project configuration: Spring Booot + Spring MVC + Spring Data JPA + two MySql s That is, my project has multi ...

Posted by jswash on Tue, 18 Dec 2018 19:21:04 -0800

Laravel Query Builder Complex Query Case: Subquery Implements partition by Partition Query

case Case study: Laravel attaches the top 10 comments to his list of articles? At the same time, the first 10 comments of each article are queried together when getting the list of articles. This is a typical case of partition query, which needs to be partitioned according to the post_id field in the comments table, and sorted according to the ...

Posted by Chrisj on Tue, 18 Dec 2018 08:30:04 -0800

Deploy PHP projects under linux - Apache, php, mysql associations

Deploying PHP project environment under linux can be divided into two kinds, one is using Apache, php, mysql package installation, and the other is using yum command to install. To install with compressed packages of three kinds of software, it is necessary to configure the relationship between them manually. The configuration between apache an ...

Posted by cyberdwarf on Tue, 18 Dec 2018 01:51:04 -0800

Solution to connect Mysql prompt Can't connect to local MySQL server through socket

mysql, mysqldump, mysqldump, php connection mysql service often prompts the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) There are generally two reasons for this problem: 1. The mysql service is not functioning properly: Since mysql's socket file is created when m ...

Posted by chrille112 on Tue, 18 Dec 2018 01:30:04 -0800

IDEA Commercial Java Web Connection MySQL-JDBC Error Analysis (Errors Caused by Adding classes and lib)

IDEs such as IDEA and eclipse are quite different, so we should treat them differently. If classes and lib are added privately, accidents will happen. For example, my error is as follows: Error:Internal error: (java.io.FileNotFoundException) E:\IntellJAVA\ONE\TEST\out\artifacts\TEST_war_exploded\WEB-INF\lib\mysql-connector-java-5.1.45-bin.j ...

Posted by BMurtagh on Sun, 16 Dec 2018 19:33:03 -0800