链接数据库报错了

来源:2-6 登录后页面跳转

湛歌

2019-10-21 22:54:00

/Library/Tomcat/bin/catalina.sh run
[2019-10-21 10:52:27,658] Artifact shop:war exploded: Waiting for server connection to start artifact deployment...
21-Oct-2019 22:52:28.590 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.43
21-Oct-2019 22:52:28.593 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jul 4 2019 20:53:15 UTC
21-Oct-2019 22:52:28.593 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.43.0
21-Oct-2019 22:52:28.593 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Mac OS X
21-Oct-2019 22:52:28.593 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.15
21-Oct-2019 22:52:28.593 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          x86_64
21-Oct-2019 22:52:28.593 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre
21-Oct-2019 22:52:28.593 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_191-b12
21-Oct-2019 22:52:28.596 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
21-Oct-2019 22:52:28.596 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /Users/vincent/Library/Caches/IntelliJIdea2019.2/tomcat/Tomcat_8_5_43_shop
21-Oct-2019 22:52:28.596 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /Library/Tomcat
21-Oct-2019 22:52:28.597 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/Users/vincent/Library/Caches/IntelliJIdea2019.2/tomcat/Tomcat_8_5_43_shop/conf/logging.properties
21-Oct-2019 22:52:28.597 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
21-Oct-2019 22:52:28.597 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote=
21-Oct-2019 22:52:28.599 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1099
21-Oct-2019 22:52:28.599 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false
21-Oct-2019 22:52:28.599 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.password.file=/Users/vincent/Library/Caches/IntelliJIdea2019.2/tomcat/Tomcat_8_5_43_shop/jmxremote.password
21-Oct-2019 22:52:28.600 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.access.file=/Users/vincent/Library/Caches/IntelliJIdea2019.2/tomcat/Tomcat_8_5_43_shop/jmxremote.access
21-Oct-2019 22:52:28.600 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1
21-Oct-2019 22:52:28.601 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
21-Oct-2019 22:52:28.601 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
21-Oct-2019 22:52:28.601 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
21-Oct-2019 22:52:28.602 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
21-Oct-2019 22:52:28.602 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/Users/vincent/Library/Caches/IntelliJIdea2019.2/tomcat/Tomcat_8_5_43_shop
21-Oct-2019 22:52:28.602 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/Library/Tomcat
21-Oct-2019 22:52:28.603 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/Library/Tomcat/temp
21-Oct-2019 22:52:28.603 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/Users/vincent/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.]
21-Oct-2019 22:52:28.791 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
21-Oct-2019 22:52:28.825 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
21-Oct-2019 22:52:28.864 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
21-Oct-2019 22:52:28.865 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
21-Oct-2019 22:52:28.865 信息 [main] org.apache.catalina.startup.Catalina.load Initialization processed in 635 ms
21-Oct-2019 22:52:28.925 信息 [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
21-Oct-2019 22:52:28.926 信息 [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.43
21-Oct-2019 22:52:28.931 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
21-Oct-2019 22:52:28.940 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
21-Oct-2019 22:52:28.943 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in 77 ms
Connected to server
[2019-10-21 10:52:29,239] Artifact shop:war exploded: Artifact is being deployed, please wait...
21-Oct-2019 22:52:29.463 警告 [RMI TCP Connection(2)-127.0.0.1] org.apache.tomcat.util.descriptor.web.WebXml.setVersion Unknown version string [4.0]. Default version will be used.
21-Oct-2019 22:52:30.463 信息 [RMI TCP Connection(2)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars 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.
[2019-10-21 10:52:30,539] Artifact shop:war exploded: Artifact is deployed successfully
[2019-10-21 10:52:30,539] Artifact shop:war exploded: Deploy took 1,300 milliseconds
21-Oct-2019 22:52:38.939 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/Library/Tomcat/webapps/manager]
21-Oct-2019 22:52:39.235 信息 [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars 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.
21-Oct-2019 22:52:39.245 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/Library/Tomcat/webapps/manager] has finished in [306] ms
aaa111
21-Oct-2019 22:52:40.080 信息 [http-nio-8080-exec-10] com.mchange.v2.log.MLog.<clinit> MLog clients using java 1.4+ standard logging.
21-Oct-2019 22:52:40.125 信息 [http-nio-8080-exec-10] com.mchange.v2.c3p0.C3P0Registry.banner Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
21-Oct-2019 22:52:40.208 信息 [http-nio-8080-exec-10] com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> z8kflta51u9d4xb1g1bo5o|211bc97e, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kflta51u9d4xb1g1bo5o|211bc97e, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql:///shop?useSSL=false&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT%2B8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
21-Oct-2019 22:53:09.493 警告 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@4e7ab59e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
	com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
		at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
		at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
		at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
		at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
		at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
		at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
		at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
		at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
		at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
		at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
		at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
		at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
		at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
		at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
		at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
		at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
21-Oct-2019 22:53:09.493 警告 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2c3f87c1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
	com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
		at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
		at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
		at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
		at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
		at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
		at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
		at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
		at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
		at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
		at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
		at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
		at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
		at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
		at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
		at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
		at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
21-Oct-2019 22:53:09.497 警告 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@60538e3 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
	com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
		at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
		at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
		at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
		at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
		at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
		at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
		at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
		at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
		at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
		at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
		at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
		at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
		at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
		at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
		at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
		at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at com.imooc.utils.JDBCUtils.getConnection(JDBCUtils.java:24)
	at com.imooc.dao.impl.UserDaoImpl.login(UserDaoImpl.java:19)
	at com.imooc.service.impl.UserServiceImpl.login(UserServiceImpl.java:14)
	at com.imooc.web.action.UserServlet.login(UserServlet.java:41)
	at com.imooc.web.action.UserServlet.doPost(UserServlet.java:23)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 30 more


写回答

1回答

好帮手慕阿满

2019-10-22

同学你好,报错是指无法从数据库获取连接,建议同学检查一下是否有导入MySQL的驱动jar包,jar包版本是否和安装的数据库版本一致。另外建议同学检查一下MySQL服务是否启动,项目中MySQL的url,用户名及密码等是否正确。

如果我的回答解决了你的疑惑,请采纳。祝:学习愉快~

0

0 学习 · 8016 问题

查看课程