Example Analysis of url Parameter trample in Spring Database connection Pool

This article mainly shows you the "Spring database connection pool url parameter trample example analysis", the content is easy to understand, well-organized, hope to help you solve your doubts, the following let the editor lead you to study and study the "Spring database connection pool url parameter trample example analysis" this article.

Problems encountered in Spring database connection pool url parameter trampling crater

Report an error

Solve

The & 'character needs to be escaped to' &'in xml

After modifying the url of the database connection pool, it is still the original url problem of the connection.

When the connection pool url is modified, the original database is accessed.

For example

It turns out:

Url=jdbc:mysql://192.168.250.227:3306/myshop?characterEncoding=utf-8

After modification:

Url=jdbc:mysql://10.201.15.5:3306/shop?characterEncoding=utf-8

The error is reported as follows:

Com.alibaba.druid.pool.DruidDataSource error critical: init datasource error url=jdbc:mysql://192.168.250.227:3306/myshop?characterEncoding=utf-8

This is because:

The data configuration file of the project in the webapp of tomcat has not been modified, and it is still the original url.

Modify the database configuration file (db.properties) of the project before modifying

Apache-tomcat-8.0.45\ webapps\ proTest\ WEB-INF\ classes\ db.properties

Modify the "data configuration file for the project in tomcat's webapp" and restart Tomcat.

The above is all the contents of the article "example Analysis of url parameters trample in Spring Database connection Pool". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!