Spring+Mybatis时出现数据库连接问题

在使用Spring+Mybatis时遇到数据库连接问题,表现为无法连接。错误源于时区设置不正确。通过在配置中添加`serverTimezone=UTC`解决了此问题。
摘要由CSDN通过智能技术生成

Spring+Mybatis时出现数据库连接问题

连接不上数据库,出现如下错误

D:\ProgramFiles\Java\jdk1.8.0_191\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:D:\ProgramFiles\JetBrains\IntelliJ IDEA 2018.3.2\lib\idea_rt.jar=6126:D:\ProgramFiles\JetBrains\IntelliJ IDEA 2018.3.2\bin" -Dfile.encoding=UTF-8 -classpath "D:\ProgramFiles\JetBrains\IntelliJ IDEA 2018.3.2\lib\idea_rt.jar;D:\ProgramFiles\JetBrains\IntelliJ IDEA 2018.3.2\plugins\junit\lib\junit-rt.jar;D:\ProgramFiles\JetBrains\IntelliJ IDEA 2018.3.2\plugins\junit\lib\junit5-rt.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\charsets.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\deploy.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\access-bridge-64.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\cldrdata.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\dnsns.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\jaccess.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\jfxrt.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\localedata.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\nashorn.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\sunec.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\sunjce_provider.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\sunmscapi.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\sunpkcs11.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\ext\zipfs.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\javaws.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\jce.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\jfr.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\jfxswt.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\jsse.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\management-agent.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\plugin.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\resources.jar;D:\ProgramFiles\Java\jdk1.8.0_191\jre\lib\rt.jar;E:\IntelliJIDEA-workspace\BookStore\target\classes;E:\localRepository\Maven\junit\junit\4.10\junit-4.10.jar;E:\localRepository\Maven\org\hamcrest\hamcrest-core\1.1\hamcrest-core-1.1.jar;E:\localRepository\Maven\org\springframework\spring-context\4.3.0.RELEASE\spring-context-4.3.0.RELEASE.jar;E:\localRepository\Maven\org\springframework\spring-aop\4.3.0.RELEASE\spring-aop-4.3.0.RELEASE.jar;E:\localRepository\Maven\org\springframework\spring-beans\4.3.0.RELEASE\spring-beans-4.3.0.RELEASE.jar;E:\localRepository\Maven\org\springframework\spring-core\4.3.0.RELEASE\spring-core-4.3.0.RELEASE.jar;E:\localRepository\Maven\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;E:\localRepository\Maven\org\springframework\spring-expression\4.3.0.RELEASE\spring-expression-4.3.0.RELEASE.jar;E:\localRepository\Maven\org\springframework\spring-web\4.3.0.RELEASE\spring-web-4.3.0.RELEASE.jar;E:\localRepository\Maven\org\aspectj\aspectjweaver\1.8.9\aspectjweaver-1.8.9.jar;E:\localRepository\Maven\org\mybatis\mybatis-spring\1.3.0\mybatis-spring-1.3.0.jar;E:\localRepository\Maven\org\springframework\spring-jdbc\4.3.0.RELEASE\spring-jdbc-4.3.0.RELEASE.jar;E:\localRepository\Maven\org\springframework\spring-tx\4.3.0.RELEASE\spring-tx-4.3.0.RELEASE.jar;E:\localRepository\Maven\mysql\mysql-connector-java\8.0.11\mysql-connector-java-8.0.11.jar;E:\localRepository\Maven\com\google\protobuf\protobuf-java\2.6.0\protobuf-java-2.6.0.jar;E:\localRepository\Maven\org\apache\logging\log4j\log4j-core\2.6.1\log4j-core-2.6.1.jar;E:\localRepository\Maven\org\apache\logging\log4j\log4j-api\2.6.1\log4j-api-2.6.1.jar;E:\localRepository\Maven\org\mybatis\mybatis\3.4.1\mybatis-3.4.1.jar;E:\localRepository\Maven\c3p0\c3p0\0.9.1.2\c3p0-0.9.1.2.jar;E:\localRepository\Maven\javax\servlet\jstl\1.2\jstl-1.2.jar;E:\localRepository\Maven\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;E:\localRepository\Maven\javax\servlet\jsp\javax.servlet.jsp-api\2.3.1\javax.servlet.jsp-api-2.3.1.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 com.zhangguo.bookstore.test.TestBookService,testGetAllBooks
二月 12, 2019 9:03:03 上午 org.springframework.context.support.ClassPathXmlApplicationContext prepareRefresh
信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@ed17bee: startup date [Tue Feb 12 09:03:03 CST 2019]; root of context hierarchy
二月 12, 2019 9:03:03 上午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [applicationContext.xml]
二月 12, 2019 9:03:03 上午 org.springframework.context.support.PropertySourcesPlaceholderConfigurer loadProperties
信息: Loading properties file from URL [file:/E:/IntelliJIDEA-workspace/BookStore/target/classes/db.properties]
二月 12, 2019 9:03:04 上午 com.mchange.v2.log.MLog <clinit>
信息: MLog clients using java 1.4+ standard logging.
二月 12, 2019 9:03:04 上午 com.mchange.v2.c3p0.C3P0Registry banner
信息: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
二月 12, 2019 9:03:05 上午 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge8t6a01pxrq4l1x4kvs1|4d9e68d0, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge8t6a01pxrq4l1x4kvs1|4d9e68d0, idleConnectionTestPeriod -> 0, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3306/db1?useUnicode=true&characterEncoding=UTF-8&useSSL=false, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {
   user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
二月 12, 2019 9:03:25 上午 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
警告: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@da38f1b -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
二月 12, 2019 9:03:25 上午 com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
警告
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值