报错JDBC Connection [com.mysql.jdbc.JDBC4Connection@184c65da] will not be managed by Spring

最新推荐文章于 2025-07-22 17:47:05 发布

原创最新推荐文章于 2025-07-22 17:47:05 发布 · 2.4w 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#单点登录 #redis #连接数据库报错

报错专栏收录该内容

16 篇文章

订阅专栏

本文记录了一次因密码错误导致的登录失败问题及其解决过程。通过排查发现直接使用明文密码进行数据库验证是问题根源，建议采用加密方式存储并验证密码。

折腾了一个下午，报了这个错，现在找出原因了，就是密码错误，不要避开md5(不要直接在数据库加入个可见的密码用来登录)

先注册，记住注册的密码，在用这个密码，登录

不要用这种密码登录

2018-04-21 21:09:11,766 [http-bio-8084-exec-7] [org.springframework.web.servlet.DispatcherServlet]-[DEBUG] DispatcherServlet with name 'taotao-sso' processing POST request for [/user/selectlogin]
2018-04-21 21:09:11,767 [http-bio-8084-exec-7] [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]-[DEBUG] Looking up handler method for path /user/selectlogin
2018-04-21 21:09:11,767 [http-bio-8084-exec-7] [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]-[DEBUG] Returning handler method [public com.taotao.common.pojo.TaotaoResult com.taotao.sso.controller.UserController.userLogin(java.lang.String,java.lang.String)]
2018-04-21 21:09:11,767 [http-bio-8084-exec-7] [org.springframework.beans.factory.support.DefaultListableBeanFactory]-[DEBUG] Returning cached instance of singleton bean 'userController'
2018-04-21 21:09:11,768 [http-bio-8084-exec-7] [org.mybatis.spring.SqlSessionUtils]-[DEBUG] Creating a new SqlSession
2018-04-21 21:09:11,768 [http-bio-8084-exec-7] [org.mybatis.spring.SqlSessionUtils]-[DEBUG] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6438ec85] was not registered for synchronization because synchronization is not active
2018-04-21 21:09:11,769 [http-bio-8084-exec-7] [org.springframework.jdbc.datasource.DataSourceUtils]-[DEBUG] Fetching JDBC Connection from DataSource
2018-04-21 21:09:11,769 [http-bio-8084-exec-7] [org.mybatis.spring.transaction.SpringManagedTransaction]-[DEBUG] JDBC Connection [com.mysql.jdbc.JDBC4Connection@184c65da] will not be managed by Spring
2018-04-21 21:09:11,769 [http-bio-8084-exec-7] [com.taotao.mapper.TbUserMapper.selectByExample]-[DEBUG] ==>  Preparing: select id, username, password, phone, email, created, updated from tb_user WHERE ( username = ? ) 
2018-04-21 21:09:11,770 [http-bio-8084-exec-7] [com.taotao.mapper.TbUserMapper.selectByExample]-[DEBUG] ==> Parameters: ww(String)
2018-04-21 21:09:11,772 [http-bio-8084-exec-7] [com.taotao.mapper.TbUserMapper.selectByExample]-[DEBUG] <==      Total: 1
2018-04-21 21:09:11,772 [http-bio-8084-exec-7] [org.mybatis.spring.SqlSessionUtils]-[DEBUG] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6438ec85]
2018-04-21 21:09:11,773 [http-bio-8084-exec-7] [org.springframework.jdbc.datasource.DataSourceUtils]-[DEBUG] Returning JDBC Connection to DataSource
2018-04-21 21:09:11,773 [http-bio-8084-exec-7] [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain]-[DEBUG] Invoking ResponseBodyAdvice chain for body=com.taotao.common.pojo.TaotaoResult@64d559aa
2018-04-21 21:09:11,773 [http-bio-8084-exec-7] [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain]-[DEBUG] After ResponseBodyAdvice chain body=com.taotao.common.pojo.TaotaoResult@64d559aa
2018-04-21 21:09:11,774 [http-bio-8084-exec-7] [org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor]-[DEBUG] Written [com.taotao.common.pojo.TaotaoResult@64d559aa] as "application/json;charset=UTF-8" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@25272bc4]
2018-04-21 21:09:11,774 [http-bio-8084-exec-7] [org.springframework.web.servlet.DispatcherServlet]-[DEBUG] Null ModelAndView returned to DispatcherServlet with name 'taotao-sso': assuming HandlerAdapter completed request handling
2018-04-21 21:09:11,774 [http-bio-8084-exec-7] [org.springframework.web.servlet.DispatcherServlet]-[DEBUG] Successfully completed request