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

最新推荐文章于 2023-08-20 10:53:49 发布

兔兔软糖

最新推荐文章于 2023-08-20 10:53:49 发布

阅读量1.3k

点赞数 1

分类专栏：笔记

本文链接：https://blog.csdn.net/m0_53397360/article/details/116958052

版权

笔记专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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://xxxxxxxxxx:3306/collection?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=jsj2018_HW03