请稍等 ...
×

采纳答案成功!

向帮助你的同学说点啥吧!感谢那些助人为乐的人

Could not get JDBC Connection无法登录了

通过http://localhost:8088/user/login.do 发送POST请求之后总是提示无法取得JDBC连接,该怎么解决呢?

报错里面是提示D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\UserMapper.xml文件里面的com.mmall.dao.UserMapper.checkUsername可能有问题,不过我没看出来

如下是checkUsername里面的内容

  <select id="checkUsername" resultType="int" parameterType="string" >
    select count(1) from mmall_user
    where username = #{username}
  </select>

如下是通过reslet发送POST请求后Tomcat Localhost Log里面的内容

十月 03, 2017 12:03:12 下午 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
十月 03, 2017 12:03:12 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
十月 03, 2017 12:03:14 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring FrameworkServlet 'dispatcher'
十月 03, 2017 12:07:37 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [dispatcher] in context with path [] threw exception [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 org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 1 ms ago.)
### The error may exist in file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\UserMapper.xml]
### The error may involve com.mmall.dao.UserMapper.checkUsername
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 1 ms ago.)] with root cause
java.net.ConnectException: Connection timed out: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:579)
	at java.net.Socket.connect(Socket.java:528)
	at java.net.Socket.<init>(Socket.java:425)
	at java.net.Socket.<init>(Socket.java:241)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:84)
	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:70)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:401)
	at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374)
	at com.github.pagehelper.PageHelper.intercept(PageHelper.java:250)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy30.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
	at com.sun.proxy.$Proxy19.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
	at com.sun.proxy.$Proxy20.checkUsername(Unknown Source)
	at com.mmall.service.impl.UserServiceImpl.login(UserServiceImpl.java:28)
	at com.mmall.controller.portal.UserController.login(UserController.java:39)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:214)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:748)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:931)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:833)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2549)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2538)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)

正在回答 回答被采纳积分+3

11回答

提问者 星辰Iron 2017-10-05 12:15:31

这是Tomcat Catalina Log框里面的日志信息

十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/7.0.81
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Aug 11 2017 10:21:27 UTC
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         7.0.81.0
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Windows 8.1
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            6.3
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          amd64
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             C:\Program Files\Java\jdk1.7.0_80\jre
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.7.0_80-b15
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         C:\Users\Jupiter-Lee\.IntelliJIdea2016.1\system\tomcat\Unnamed_mmall_5
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         D:\apache-tomcat-7.0.81
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.util.logging.config.file=C:\Users\Jupiter-Lee\.IntelliJIdea2016.1\system\tomcat\Unnamed_mmall_5\conf\logging.properties
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcom.sun.management.jmxremote=
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcom.sun.management.jmxremote.port=1099
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcom.sun.management.jmxremote.ssl=false
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcom.sun.management.jmxremote.authenticate=false
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.rmi.server.hostname=127.0.0.1
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=D:\apache-tomcat-7.0.81\endorsed
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=C:\Users\Jupiter-Lee\.IntelliJIdea2016.1\system\tomcat\Unnamed_mmall_5
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=D:\apache-tomcat-7.0.81
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.io.tmpdir=D:\apache-tomcat-7.0.81\temp
十月 05, 2017 11:59:22 上午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: Loaded APR based Apache Tomcat Native library 1.2.12 using APR version 1.5.2.
十月 05, 2017 11:59:22 上午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
十月 05, 2017 11:59:23 上午 org.apache.catalina.core.AprLifecycleListener initializeSSL
信息: OpenSSL successfully initialized (OpenSSL 1.0.2k  26 Jan 2017)
十月 05, 2017 11:59:23 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-apr-8088"]
十月 05, 2017 11:59:23 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-apr-8009"]
十月 05, 2017 11:59:23 上午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 910 ms
十月 05, 2017 11:59:23 上午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
十月 05, 2017 11:59:23 上午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.81
十月 05, 2017 11:59:23 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-apr-8088"]
十月 05, 2017 11:59:23 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-apr-8009"]
十月 05, 2017 11:59:23 上午 org.apache.catalina.startup.Catalina start
信息: Server startup in 44 ms
十月 05, 2017 11:59:23 上午 org.apache.catalina.loader.WebappClassLoaderBase validateJarFile
信息: validateJarFile(D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\lib\tomcat-servlet-api-7.0.64.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
十月 05, 2017 11:59:25 上午 org.apache.catalina.startup.TldConfig execute


0 回复 有任何疑惑可以回复我~
提问者 星辰Iron 2017-10-05 12:13:54

Server框日志信息最后一部分,个人感觉最后三行可能是错误原因,辛苦老师了(~ ̄▽ ̄)~ 

信息: Mapped "{[/manage/product/save.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.ProductManageController.productSave(javax.servlet.http.HttpSession,com.mmall.pojo.Product)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/product/list.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.ProductManageController.getList(javax.servlet.http.HttpSession,int,int)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/user/login.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.pojo.User> com.mmall.controller.backend.UserManageController.login(java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//add.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.vo.CartVo> com.mmall.controller.portal.CartController.add(javax.servlet.http.HttpSession,java.lang.Integer,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//list.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.vo.CartVo> com.mmall.controller.portal.CartController.list(javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//update.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.vo.CartVo> com.mmall.controller.portal.CartController.update(javax.servlet.http.HttpSession,java.lang.Integer,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//select.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.vo.CartVo> com.mmall.controller.portal.CartController.select(javax.servlet.http.HttpSession,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//get_cart_product_count.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.Integer> com.mmall.controller.portal.CartController.getCartProductCount(javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//delete_product.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.vo.CartVo> com.mmall.controller.portal.CartController.deleteProduct(javax.servlet.http.HttpSession,java.lang.String)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//un_select.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.vo.CartVo> com.mmall.controller.portal.CartController.unSelect(javax.servlet.http.HttpSession,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//select_all.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.vo.CartVo> com.mmall.controller.portal.CartController.selectAll(javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/cart//un_select_all.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.vo.CartVo> com.mmall.controller.portal.CartController.unSelectAll(javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/order//create.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.OrderController.create(javax.servlet.http.HttpSession,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/order//list.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.OrderController.list(javax.servlet.http.HttpSession,int,int)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/order//cancel.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.OrderController.cancel(javax.servlet.http.HttpSession,java.lang.Long)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/order//detail.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.OrderController.detail(javax.servlet.http.HttpSession,java.lang.Long)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/order//alipay_callback.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.lang.Object com.mmall.controller.portal.OrderController.alipayCallback(javax.servlet.http.HttpServletRequest)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/order//query_order_pay_status.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.Boolean> com.mmall.controller.portal.OrderController.queryOrderPayStatus(javax.servlet.http.HttpSession,java.lang.Long)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/order//get_order_cart_product.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.OrderController.getOrderCartProduct(javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/order//pay.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.OrderController.pay(javax.servlet.http.HttpSession,java.lang.Long,javax.servlet.http.HttpServletRequest)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/shipping//add.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.ShippingController.add(javax.servlet.http.HttpSession,com.mmall.pojo.Shipping)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/shipping//list.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.github.pagehelper.PageInfo> com.mmall.controller.portal.ShippingController.list(int,int,javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/shipping//update.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.ShippingController.update(javax.servlet.http.HttpSession,com.mmall.pojo.Shipping)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/shipping//select.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.pojo.Shipping> com.mmall.controller.portal.ShippingController.select(javax.servlet.http.HttpSession,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/shipping//del.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.portal.ShippingController.del(javax.servlet.http.HttpSession,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//register.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.String> com.mmall.controller.portal.UserController.register(com.mmall.pojo.User)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//get_user_info.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.pojo.User> com.mmall.controller.portal.UserController.getUserInfo(javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//logout.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.String> com.mmall.controller.portal.UserController.logout(javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//login.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.pojo.User> com.mmall.controller.portal.UserController.login(java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//get_information.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.pojo.User> com.mmall.controller.portal.UserController.get_information(javax.servlet.http.HttpSession)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//update_information.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<com.mmall.pojo.User> com.mmall.controller.portal.UserController.update_information(javax.servlet.http.HttpSession,com.mmall.pojo.User)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//forget_check_answer.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.String> com.mmall.controller.portal.UserController.forgetCheckAnswer(java.lang.String,java.lang.String,java.lang.String)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//forget_reset_password.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.String> com.mmall.controller.portal.UserController.forgetRestPassword(java.lang.String,java.lang.String,java.lang.String)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//forget_get_question.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.String> com.mmall.controller.portal.UserController.forgetGetQuestion(java.lang.String)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//reset_password.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.String> com.mmall.controller.portal.UserController.resetPassword(javax.servlet.http.HttpSession,java.lang.String,java.lang.String)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/user//check_valid.do],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse<java.lang.String> com.mmall.controller.portal.UserController.checkValid(java.lang.String,java.lang.String)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.FrameworkServlet initServletBean
信息: FrameworkServlet 'dispatcher': initialization completed in 750 ms
[2017-10-05 11:59:27,690] Artifact mmall.war: Artifact is deployed successfully
[2017-10-05 11:59:27,691] Artifact mmall.war: Deploy took 4,381 milliseconds
十月 05, 2017 11:59:33 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory D:\apache-tomcat-7.0.81\webapps\manager
十月 05, 2017 11:59:33 上午 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deployment of web application directory D:\apache-tomcat-7.0.81\webapps\manager has finished in 61 ms
[12:00:07.512][DEBUG][org.mybatis.spring.SqlSessionUtils][http-apr-8088-exec-2] Creating a new SqlSession
[12:00:07.522][DEBUG][org.mybatis.spring.SqlSessionUtils][http-apr-8088-exec-2] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b52161c] was not registered for synchronization because synchronization is not active
[12:00:28.627][DEBUG][org.mybatis.spring.SqlSessionUtils][http-apr-8088-exec-2] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b52161c]


0 回复 有任何疑惑可以回复我~
提问者 星辰Iron 2017-10-05 12:11:07

Server框日志信息第三部分

十月 05, 2017 11:59:26 上午 org.springframework.web.context.ContextLoader initWebApplicationContext
信息: Root WebApplicationContext: initialization completed in 1387 ms
十月 05, 2017 11:59:26 上午 org.springframework.web.servlet.FrameworkServlet initServletBean
信息: FrameworkServlet 'dispatcher': initialization started
十月 05, 2017 11:59:26 上午 org.springframework.context.support.AbstractApplicationContext prepareRefresh
信息: Refreshing WebApplicationContext for namespace 'dispatcher-servlet': startup date [Thu Oct 05 11:59:26 CST 2017]; parent: Root WebApplicationContext
十月 05, 2017 11:59:26 上午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from ServletContext resource [/WEB-INF/dispatcher-servlet.xml]
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/category/get_deep_category.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.CategoryManageController.getCategoryAndDeepChildrenCategory(javax.servlet.http.HttpSession,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/category/get_category.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.CategoryManageController.getChildrenParallelCategory(javax.servlet.http.HttpSession,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/category/set_category_name.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.CategoryManageController.setCategoryName(javax.servlet.http.HttpSession,java.lang.Integer,java.lang.String)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/category/add_category.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.CategoryManageController.addCategory(javax.servlet.http.HttpSession,java.lang.String,int)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/product/upload.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.ProductManageController.upload(javax.servlet.http.HttpSession,org.springframework.web.multipart.MultipartFile,javax.servlet.http.HttpServletRequest)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/product/richtext_img_upload.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.util.Map com.mmall.controller.backend.ProductManageController.richtextImgUpload(javax.servlet.http.HttpSession,org.springframework.web.multipart.MultipartFile,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/product/search.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.ProductManageController.productSearch(javax.servlet.http.HttpSession,java.lang.String,java.lang.Integer,int,int)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/product/set_sale_status.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.ProductManageController.setSaleStatus(javax.servlet.http.HttpSession,java.lang.Integer,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod
信息: Mapped "{[/manage/product/detail.do],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.mmall.common.ServerResponse com.mmall.controller.backend.ProductManageController.getDetail(javax.servlet.http.HttpSession,java.lang.Integer)
十月 05, 2017 11:59:27 上午 org.springframework.web.servlet.handler.AbstractHandlerMethodMapping registerHandlerMethod


0 回复 有任何疑惑可以回复我~
提问者 星辰Iron 2017-10-05 12:08:30

Server框日志信息第二部分

信息: Server startup in 44 ms
Connected to server
[2017-10-05 11:59:23,310] Artifact mmall.war: Artifact is being deployed, please wait...
十月 05, 2017 11:59:23 上午 org.apache.catalina.loader.WebappClassLoaderBase validateJarFile
信息: validateJarFile(D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\lib\tomcat-servlet-api-7.0.64.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
十月 05, 2017 11:59:25 上午 org.apache.catalina.startup.TldConfig execute
信息: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
十月 05, 2017 11:59:25 上午 org.springframework.web.context.ContextLoader initWebApplicationContext
信息: Root WebApplicationContext: initialization started
十月 05, 2017 11:59:25 上午 org.springframework.context.support.AbstractApplicationContext prepareRefresh
信息: Refreshing Root WebApplicationContext: startup date [Thu Oct 05 11:59:25 CST 2017]; root of context hierarchy
十月 05, 2017 11:59:25 上午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [applicationContext.xml]
十月 05, 2017 11:59:25 上午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [applicationContext-datasource.xml]
十月 05, 2017 11:59:26 上午 org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
信息: Loading properties file from class path resource [datasource.properties]
11:59:26,178 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]
11:59:26,178 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
11:59:26,179 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [file:/D:/apache-tomcat-7.0.81/webapps/ROOT/WEB-INF/classes/logback.xml]
11:59:26,222 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set
11:59:26,224 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Setting ReconfigureOnChangeFilter scanning period to 1 minutes
11:59:26,224 |-INFO in ReconfigureOnChangeFilter{invocationCounter=0} - Will scan for changes in [[D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\logback.xml]] every 60 seconds. 
11:59:26,224 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Adding ReconfigureOnChangeFilter as a turbo filter
11:59:26,225 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
11:59:26,228 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [console]
11:59:26,238 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@4:19 - no applicable action for [encoding], current ElementPath  is [[configuration][appender][encoding]]
11:59:26,240 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
11:59:26,275 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender]
11:59:26,278 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [mmall]
11:59:26,289 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@19:21 - no applicable action for [append], current ElementPath  is [[configuration][appender][rollingPolicy][append]]
11:59:26,292 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy - Will use gz compression
11:59:26,293 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy - Will use the pattern d:/mmalllog/mmall.log.%d{yyyy-MM-dd} for the active file
11:59:26,296 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - The date pattern is 'yyyy-MM-dd' from file name pattern 'd:/mmalllog/mmall.log.%d{yyyy-MM-dd}.gz'.
11:59:26,296 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - Roll-over at midnight.
11:59:26,296 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - Setting initial period to Thu Sep 21 21:11:32 CST 2017
11:59:26,298 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
11:59:26,300 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[mmall] - Active log file name: d:/mmalllog/mmall.log
11:59:26,300 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[mmall] - File property is set to [d:/mmalllog/mmall.log]
11:59:26,301 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender]
11:59:26,301 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [error]
11:59:26,301 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@34:21 - no applicable action for [append], current ElementPath  is [[configuration][appender][rollingPolicy][append]]
11:59:26,301 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy - Will use gz compression
11:59:26,301 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy - Will use the pattern d:/mmalllog/error.log.%d{yyyy-MM-dd} for the active file
11:59:26,302 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - The date pattern is 'yyyy-MM-dd' from file name pattern 'd:/mmalllog/error.log.%d{yyyy-MM-dd}.gz'.
11:59:26,302 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - Roll-over at midnight.
11:59:26,302 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - Setting initial period to Sun Sep 03 10:45:52 CST 2017
11:59:26,302 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
11:59:26,306 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[error] - Active log file name: d:/mmalllog/error.log
11:59:26,306 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[error] - File property is set to [d:/mmalllog/error.log]
11:59:26,308 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [com.mmall] to INFO
11:59:26,308 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.mmall] to false
11:59:26,308 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [mmall] to Logger[com.mmall]
11:59:26,309 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [console] to Logger[com.mmall]
11:59:26,309 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [com.mmall.dao] to DEBUG
11:59:26,310 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to DEBUG
11:59:26,310 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [console] to Logger[ROOT]
11:59:26,310 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [error] to Logger[ROOT]
11:59:26,310 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
11:59:26,311 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@2480567 - Registering current configuration as safe fallback point

[11:59:26.319][DEBUG][org.apache.ibatis.logging.LogFactory][RMI TCP Connection(3)-127.0.0.1] Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
[11:59:26.392][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Property `configuration` or 'configLocation' not specified, using default MyBatis Configuration
[11:59:26.428][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Registered plugin: 'com.github.pagehelper.PageHelper@5fcd6d74'
[11:59:26.562][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Parsed mapper file: 'file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\CartMapper.xml]'
[11:59:26.586][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Parsed mapper file: 'file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\CategoryMapper.xml]'
[11:59:26.615][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Parsed mapper file: 'file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\OrderItemMapper.xml]'
[11:59:26.650][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Parsed mapper file: 'file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\OrderMapper.xml]'
[11:59:26.665][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Parsed mapper file: 'file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\PayInfoMapper.xml]'
[11:59:26.688][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Parsed mapper file: 'file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\ProductMapper.xml]'
[11:59:26.708][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Parsed mapper file: 'file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\ShippingMapper.xml]'
[11:59:26.729][DEBUG][org.mybatis.spring.SqlSessionFactoryBean][RMI TCP Connection(3)-127.0.0.1] Parsed mapper file: 'file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\UserMapper.xml]'
十月 05, 2017 11:59:26 上午 com.alipay.demo.trade.config.Configs init
信息: 配置文件名: zfbinfo.properties
十月 05, 2017 11:59:26 上午 com.alipay.demo.trade.config.Configs init
信息: Configs{支付宝openapi网关: https://openapi.alipaydev.com/gateway.do
, 支付宝mcloudapi网关域名: http://mcloudmonitor.com/gateway.do
, pid: 2088102172140011
, appid: 2016082000290572
, 商户RSA私钥: MIIEvQ******YJiss=
, 商户RSA公钥: MIIBIj******IDAQAB
, 支付宝RSA公钥: MIIBIj******IDAQAB
, 签名类型: RSA2
, 查询重试次数: 5
, 查询间隔(毫秒): 5000
, 撤销尝试次数: 3
, 撤销重试间隔(毫秒): 2000
, 交易保障调度延迟(秒): 5
, 交易保障调度间隔(秒): 900
}


0 回复 有任何疑惑可以回复我~
提问者 星辰Iron 2017-10-05 12:06:40

Server框日志信息第一部分(日志太长一次装不下)

D:\apache-tomcat-7.0.81\bin\catalina.bat run
[2017-10-05 11:59:21,727] Artifact mmall.war: Server is not connected. Deploy is not available.
Using CATALINA_BASE:   "C:\Users\Jupiter-Lee\.IntelliJIdea2016.1\system\tomcat\Unnamed_mmall_5"
Using CATALINA_HOME:   "D:\apache-tomcat-7.0.81"
Using CATALINA_TMPDIR: "D:\apache-tomcat-7.0.81\temp"
Using JRE_HOME:        "C:\Program Files\Java\jdk1.7.0_80"
Using CLASSPATH:       "D:\apache-tomcat-7.0.81\bin\bootstrap.jar;D:\apache-tomcat-7.0.81\bin\tomcat-juli.jar"
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/7.0.81
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Aug 11 2017 10:21:27 UTC
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         7.0.81.0
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Windows 8.1
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            6.3
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          amd64
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             C:\Program Files\Java\jdk1.7.0_80\jre
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.7.0_80-b15
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         C:\Users\Jupiter-Lee\.IntelliJIdea2016.1\system\tomcat\Unnamed_mmall_5
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         D:\apache-tomcat-7.0.81
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.util.logging.config.file=C:\Users\Jupiter-Lee\.IntelliJIdea2016.1\system\tomcat\Unnamed_mmall_5\conf\logging.properties
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcom.sun.management.jmxremote=
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcom.sun.management.jmxremote.port=1099
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcom.sun.management.jmxremote.ssl=false
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcom.sun.management.jmxremote.authenticate=false
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.rmi.server.hostname=127.0.0.1
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=D:\apache-tomcat-7.0.81\endorsed
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=C:\Users\Jupiter-Lee\.IntelliJIdea2016.1\system\tomcat\Unnamed_mmall_5
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=D:\apache-tomcat-7.0.81
十月 05, 2017 11:59:22 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.io.tmpdir=D:\apache-tomcat-7.0.81\temp
十月 05, 2017 11:59:22 上午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: Loaded APR based Apache Tomcat Native library 1.2.12 using APR version 1.5.2.
十月 05, 2017 11:59:22 上午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
十月 05, 2017 11:59:23 上午 org.apache.catalina.core.AprLifecycleListener initializeSSL
信息: OpenSSL successfully initialized (OpenSSL 1.0.2k  26 Jan 2017)
十月 05, 2017 11:59:23 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-apr-8088"]
十月 05, 2017 11:59:23 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-apr-8009"]
十月 05, 2017 11:59:23 上午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 910 ms
十月 05, 2017 11:59:23 上午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
十月 05, 2017 11:59:23 上午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.81
十月 05, 2017 11:59:23 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-apr-8088"]
十月 05, 2017 11:59:23 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-apr-8009"]
十月 05, 2017 11:59:23 上午 org.apache.catalina.startup.Catalina start
信息: Server startup in 44 ms


0 回复 有任何疑惑可以回复我~
提问者 星辰Iron 2017-10-05 12:01:40

这是Tomcat Localhost Log框里面的日志信息

十月 05, 2017 11:59:25 上午 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
十月 05, 2017 11:59:25 上午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
十月 05, 2017 11:59:26 上午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring FrameworkServlet 'dispatcher'
十月 05, 2017 12:00:28 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [dispatcher] in context with path [] threw exception [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 org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
### The error may exist in file [D:\apache-tomcat-7.0.81\webapps\ROOT\WEB-INF\classes\mappers\UserMapper.xml]
### The error may involve com.mmall.dao.UserMapper.checkUsername
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)] with root cause
java.net.ConnectException: Connection timed out: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:579)
	at java.net.Socket.connect(Socket.java:528)
	at java.net.Socket.<init>(Socket.java:425)
	at java.net.Socket.<init>(Socket.java:241)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:84)
	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:70)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:401)
	at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374)
	at com.github.pagehelper.PageHelper.intercept(PageHelper.java:250)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy30.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
	at com.sun.proxy.$Proxy19.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
	at com.sun.proxy.$Proxy20.checkUsername(Unknown Source)
	at com.mmall.service.impl.UserServiceImpl.login(UserServiceImpl.java:28)
	at com.mmall.controller.portal.UserController.login(UserController.java:39)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:214)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:748)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:931)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:833)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2549)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2538)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)


0 回复 有任何疑惑可以回复我~
  • Geely #1
    Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure


    192.168.8.107
    看了一下你的连接串。

    看了一下关键异常,无法获取jdbc的连接。


    db.url=jdbc:mysql://192.168.8.107:3306/mmall_learning?characterEncoding=utf-8

    3306端口是 对的,同学这个ip和端口是开放的么,数据库装在本机还是别的机器,ping一下ip看看是否通,另外打开一个客户端mysql工具连接一下,看看能否连接上。

    如果这个错误排除之后
    看下这个帖子

    http://blog.csdn.net/ah3629/article/details/46459119

    操作一下就能解决了。
    回复 有任何疑惑可以回复我~ 2017-10-05 22:55:58
Geely 2017-10-05 11:56:38

那把最新的详细日志发出来~~

0 回复 有任何疑惑可以回复我~
  • 提问者 星辰Iron #1
    老师我把Server、Tomcat Localhost Log、Tomcat Catalina Log三个框里面的日志信息都贴在上面了,辛苦老师了。ヽ( ̄▽ ̄)ノ
    回复 有任何疑惑可以回复我~ 2017-10-05 12:17:21
提问者 星辰Iron 2017-10-05 11:41:17

我发送完登录请求之后Server那个框里面会提示下图红框里的信息

https://szimg.mukewang.com/59d5aa90000141dd16101030.jpg

如下是红框里面的完整信息

[11:38:12.766][DEBUG][org.mybatis.spring.SqlSessionUtils][http-apr-8088-exec-2] Creating a new SqlSession
[11:38:12.775][DEBUG][org.mybatis.spring.SqlSessionUtils][http-apr-8088-exec-2] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@70ab0b8c] was not registered for synchronization because synchronization is not active
[11:38:33.892][DEBUG][org.mybatis.spring.SqlSessionUtils][http-apr-8088-exec-2] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@70ab0b8c]

这是啥意思,怎么解决?

0 回复 有任何疑惑可以回复我~
  • Geely #1
    这个没关系,一期里面我们没有做事务,这块先忽略。
    回复 有任何疑惑可以回复我~ 2017-10-05 22:51:56
Geely 2017-10-05 10:50:04

端口为什么是2736?你改过mysql的默认端口?

0 回复 有任何疑惑可以回复我~
  • 提问者 星辰Iron #1
    没主动改过端口号,我通过show global variables like 'port';命令查询的端口号是3306
    回复 有任何疑惑可以回复我~ 2017-10-05 11:21:29
  • Geely 回复 提问者 星辰Iron #2
    你的配置写的是2736。。那个又不是端口是pid而已。
    回复 有任何疑惑可以回复我~ 2017-10-05 11:45:33
  • 提问者 星辰Iron 回复 Geely #3
    改回3306了,还是没法登录。
    回复 有任何疑惑可以回复我~ 2017-10-05 11:50:28
提问者 星辰Iron 2017-10-04 16:15:05

如下是我的本地ip信息

https://szimg.mukewang.com/59d497810001aef512230639.jpg

我的datasource.properties里面的信息如下,是不是我的db.url配置有问题?

下面是我之前的db.url的配置

db.url=jdbc:mysql://192.168.8.107:3306/mmall_learning?characterEncoding=utf-8

下面是我调整之后的datasource.properties的完整内容,不过还是无法取得JDBC连接,是我哪里配置错了吗?

db.driverLocation=E:/imooc/mysql-connector-java-5.1.6-bin.jar
db.driverClassName=com.mysql.jdbc.Driver

#db.url=jdbc:mysql://192.1.1.1:3306/mmall?characterEncoding=utf-8
db.url=jdbc:mysql://192.168.8.104:2736/mmall_learning?characterEncoding=utf-8
db.username=root
db.password=root

db.initialSize = 20
db.maxActive = 50
db.maxIdle = 20
db.minIdle = 10
db.maxWait = 10
db.defaultAutoCommit = true
db.minEvictableIdleTimeMillis = 3600000


0 回复 有任何疑惑可以回复我~
  • 我也遇到了同样的问题,原因如下,你在pom.xml里指定的mysql版本,maven的repo里没有对应的jar,你把E:/imooc/mysql-connector-java-5.1.6-bin.jar拷贝到IdeaProjects/mmall/target/mmall/WEB-INF/lib,重新启动就好了
    回复 有任何疑惑可以回复我~ 2018-08-25 18:47:29
Geely 2017-10-03 22:27:02

你好同学,我看了下这个问题不在mapper,在和db的链接,你的db链接是正常的么

datasource.properties 

里面的是配置数据库,请保证这个连接可用

0 回复 有任何疑惑可以回复我~
  • 提问者 星辰Iron #1
    老师我把datasource.properties 里面的db.url修改了一下,不过还是无法取得JDBC连接,是不是我配置的有问题?之前都是能够正常登陆的,跟着写完“支付模块开发”之后就无法登陆了。
    回复 有任何疑惑可以回复我~ 2017-10-04 16:19:06
  • 安然2015 回复 提问者 星辰Iron #2
    老哥 我最近也遇到了跟你一样的问题 请问你还记得你当初怎么解决的吗
    回复 有任何疑惑可以回复我~ 2019-11-19 09:20:24
问题已解决,确定采纳
还有疑问,暂不采纳
意见反馈 帮助中心 APP下载
官方微信