欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

项目在本机上可以运行,部署到Linux上显示连接不到数据库

程序员文章站 2024-03-11 19:08:43
...

Linux环境:
jdk:openjdk version “1.8.0_292”
tomcat:9.0.4
mysql:5.0
错误信息:

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
### The error may exist in file [/usr/local/tomcat/apache-tomcat-9.0.4/webapps/garbage-collection-0.0.1-SNAPSHOT/WEB-INF/classes/com/soft/dao/EnterpriseMapper.xml]
### The error may involve com.soft.dao.EnterpriseMapper.selectByExample
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	com.soft.filter.CharactorFilter.doFilter(CharactorFilter.java:40)
	org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

已知信息;
mysql可以远程访问
jar包等其他版本适合

修正信息:补充完整的jdbc.url

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://xxxxxxxxxxx:3306/collection?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
jdbc.username=root
jdbc.password=jsj2018_HW03

先前url:

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://119.3.88.12:3306/collection?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=jsj2018_HW03