本地搭建的服务器访问不到数据库数据

Question

请问下按照老师的文档把本地服务器运行起来了,网页能出现Hello world,IDEA也链接上数据库了,但是为什么用接口访问不到数据库的数据
访问本地 http://192.168.1.102:8080/Kotlin_war_exploded/category/getCategory
postman返回的错误信息:

HTTP Status 500 – Internal Server Error

Type 异常报告

消息 Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

描述 服务器遇到一个意外的情况，阻止它完成请求。

Exception

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 com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 0, maxActive 20
### The error may exist in file [E:\KotlinMall_coding\Kotlin_Server\Kotlin\target\Kotlin_Server\WEB-INF\classes\mybatis\CategoryMapper.xml]
### The error may involve com.module.user.dao.CategoryMapper.selectCategory
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 0, maxActive 20
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:980)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:870)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

我的配置:

想同时学下服务器这块内容,麻烦老师帮忙解决下了,谢谢

Answer 1

雷宇 2019-04-15 19:26:10

数据库连接失败了，查看数据库配置

• 提问者 默小铭 #1

  jdbc.url=jdbc:mysql://127.0.0.1:3306/dada?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true  我配置是这样写的，然后项目是从慕课仓库下载下来的