Following is the docker image
Assume that the current server ip address is (all three software are on the same server)
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
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
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
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
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.
Once processed by functions on the title, the original t ...
Posted by freynolds on Wed, 19 Dec 2018 18:45:05 -0800
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
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
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
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
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