大神帮忙看下数据库连接问题SSM

显示全部楼层 · 2021-1-27 06:56:51

DEBUG[http-bio-8080-exec-1]-FetchingJDBCConnectionfromDataSource
org.mybatis.spring.MyBatisSystemException:nestedexceptionisorg.apache.ibatis.exceptions.PersistenceException:
###Errorqueryingdatabase.Cause:org.springframework.jdbc.CannotGetJdbcConnectionException:CouldnotgetJDBCConnection;nestedexceptionisorg.apache.commons.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(Couldnotcreateconnectiontodatabaseserver.Attemptedreconnect3times.Givingup.)
###Theerrormayexistincom/hzyc/citynight/mapper/HouseMapper.xml
###Theerrormayinvolvecom.hzyc.citynight.mapper.HouseMapper.getHouseByPublishDay
###Theerroroccurredwhileexecutingaquery
###Cause:org.springframework.jdbc.CannotGetJdbcConnectionException:CouldnotgetJDBCConnection;nestedexceptionisorg.apache.commons.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(Couldnotcreateconnectiontodatabaseserver.Attemptedreconnect3times.Givingup.)
atorg.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
atorg.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
atcom.sun.proxy.$Proxy9.selectList(UnknownSource)
atorg.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198)
atorg.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:119)
atorg.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
atorg.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
atcom.sun.proxy.$Proxy21.getHouseByPublishDay(UnknownSource)
atcom.hzyc.citynight.service.impl.HouseServiceImpl.getHouseByPublishDay(HouseServiceImpl.java:132)
atcom.hzyc.citynight.controller.HouseController.getHouseByPublishDayAndHot(HouseController.java:171)
atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
atjava.lang.reflect.Method.invoke(Method.java:498)
atorg.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
atorg.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
DEBUG[http-bio-8080-exec-1]-ClosingnontransactionalSqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@5e3ae854]
atorg.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:111)
atorg.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:806)
atorg.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:729)
atorg.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
atorg.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
atorg.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
atorg.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
atorg.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:624)
atorg.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:731)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
atorg.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:743)
atorg.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:485)
atorg.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:410)
atorg.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:337)
atorg.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:750)
atorg.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:720)
atorg.apache.jsp.index_jsp._jspService(index_jsp.java:114)
atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:731)
atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:731)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
atorg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
atcom.hzyc.citynight.filter.IndexFilter.doFilter(IndexFilter.java:51)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
atorg.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
atorg.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
atorg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
atorg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
atorg.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
atjava.lang.Thread.run(Thread.java:748)
Causedby:org.apache.ibatis.exceptions.PersistenceException:
###Errorqueryingdatabase.Cause:org.springframework.jdbc.CannotGetJdbcConnectionException:CouldnotgetJDBCConnection;nestedexceptionisorg.apache.commons.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(Couldnotcreateconnectiontodatabaseserver.Attemptedreconnect3times.Givingup.)
###Theerrormayexistincom/hzyc/citynight/mapper/HouseMapper.xml
###Theerrormayinvolvecom.hzyc.citynight.mapper.HouseMapper.getHouseByPublishDay
###Theerroroccurredwhileexecutingaquery
###Cause:org.springframework.jdbc.CannotGetJdbcConnectionException:CouldnotgetJDBCConnection;nestedexceptionisorg.apache.commons.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(Couldnotcreateconnectiontodatabaseserver.Attemptedreconnect3times.Givingup.)
atorg.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
atorg.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111)
atorg.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)
atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
atjava.lang.reflect.Method.invoke(Method.java:498)
atorg.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
...70more

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/citynight
jdbc.username=root
jdbc.password=
分 -->

千问 · 2021-1-27 06:56:51

很明显的错误，不能链接数据库。你要去检查链接数据库的配置文件。
仔细检查链接数据库的用户名，密码，链接mysql的jar路径等等信息是否都配置成功！

千问 · 2021-1-27 06:56:51

本地使用了测试类，测完账号密码和路径了