项目在本机上可以运行,部署到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
上一篇: Linux定时备份mysql数据库