Could not get JDBC Connection无法登录了

来源:11-10 支付模块所有功能自测

星辰Iron

2017-10-03

通过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)
写回答

11回答

星辰Iron

提问者

2017-10-05

这是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
0

星辰Iron

提问者

2017-10-05

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
0

星辰Iron

提问者

2017-10-05

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
0

星辰Iron

提问者

2017-10-05

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
0

星辰Iron

提问者

2017-10-05

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
0

星辰Iron

提问者

2017-10-05

这是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
1
Geely
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
共1条回复

Geely

2017-10-05

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

0
1
星辰Iron
老师我把Server、Tomcat Localhost Log、Tomcat Catalina Log三个框里面的日志信息都贴在上面了,辛苦老师了。ヽ( ̄▽ ̄)ノ
2017-10-05
共1条回复

星辰Iron

提问者

2017-10-05

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

//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
1
Geely
这个没关系,一期里面我们没有做事务,这块先忽略。
2017-10-05
共1条回复

Geely

2017-10-05

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

0
4
星辰Iron
回复
Geely
我看着Server框里面的日志信息提示是SqlSession的相关错误,但是不知道解决。
2017-10-05
共4条回复

星辰Iron

提问者

2017-10-04

如下是我的本地ip信息

//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
1
giantbroom
我也遇到了同样的问题,原因如下,你在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
共1条回复

Geely

2017-10-03

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

datasource.properties 

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

0
2
安然2015
回复
星辰Iron
老哥 我最近也遇到了跟你一样的问题 请问你还记得你当初怎么解决的吗
2019-11-19
共2条回复

从0开始 独立完成企业级Java电商网站服务端开发

前后端分离,数据库接口设计,架构设计,功能开发,上线运维

9476 学习 · 8804 问题

查看课程