大家可以帮我看看mysql问题吗?

MrMastiff 发布于 2017/06/14 21:17
阅读 127
收藏 0

六月 14, 2017 9:18:50 下午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:SecondBookShopping' did not find a matching property.
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/7.0.68
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Feb 8 2016 20:25:54 UTC
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         7.0.68.0
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Windows 7
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            6.1
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          amd64
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             D:\java-jdk\jre
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.8.0_31-b13
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         D:\迅雷下载\eclispe\.metadata\.plugins\org.eclipse.wst.server.core\tmp0
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         D:\tomact
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=D:\迅雷下载\eclispe\.metadata\.plugins\org.eclipse.wst.server.core\tmp0
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=D:\tomact
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dwtp.deploy=D:\迅雷下载\eclispe\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=D:\tomact\endorsed
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dfile.encoding=GBK
六月 14, 2017 9:18:50 下午 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: D:\java-jdk\jre\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:/java-jdk/jre/bin/server;D:/java-jdk/jre/bin;D:/java-jdk/jre/lib/amd64;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;D:\MySQL Datafiles\bin;D:\迅雷下载\eclispe\eclipse;;.
六月 14, 2017 9:18:50 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-bio-8080"]
六月 14, 2017 9:18:50 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-bio-8009"]
六月 14, 2017 9:18:50 下午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 692 ms
六月 14, 2017 9:18:50 下午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
六月 14, 2017 9:18:50 下午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.68
六月 14, 2017 9:18:50 下午 org.apache.catalina.loader.WebappClassLoaderBase validateJarFile
信息: validateJarFile(D:\迅雷下载\eclispe\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\SecondBookShopping\WEB-INF\lib\el-api.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/el/Expression.class
六月 14, 2017 9:18:50 下午 org.apache.catalina.loader.WebappClassLoaderBase validateJarFile
信息: validateJarFile(D:\迅雷下载\eclispe\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\SecondBookShopping\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
六月 14, 2017 9:18:53 下午 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.
六月 14, 2017 9:18:53 下午 org.apache.catalina.core.ApplicationContext log
信息: No Spring WebApplicationInitializer types detected on classpath
六月 14, 2017 9:18:53 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
[org.springframework.web.context.ContextLoader]Root WebApplicationContext: initialization started
[org.springframework.web.context.support.XmlWebApplicationContext]Refreshing Root WebApplicationContext: startup date [Wed Jun 14 21:18:54 CST 2017]; root of context hierarchy
[org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from ServletContext resource [/WEB-INF/classes/applicationContext.xml]
[com.mchange.v2.log.MLog]MLog clients using log4j logging.
[com.mchange.v2.c3p0.C3P0Registry]Initializing c3p0-0.9.2.1 [built 20-March-2013 10:47:27 +0000; debug? true; trace: 10]
[org.hibernate.annotations.common.Version]HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
[org.hibernate.Version]HHH000412: Hibernate Core {4.3.11.Final}
[org.hibernate.cfg.Environment]HHH000206: hibernate.properties not found
[org.hibernate.cfg.Environment]HHH000021: Bytecode provider name : javassist
[com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource]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 -> 2rwru09o1a9ora5xqlhez|76849819, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2rwru09o1a9ora5xqlhez|76849819, idleConnectionTestPeriod -> 0, initialPoolSize -> 2, jdbcUrl -> jdbc:mysql://127.0.0.1:3306/bookshoppingdb, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 20, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 40, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 2, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
[com.mchange.v2.resourcepool.BasicResourcePool]com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5ffdb9e0 -- 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:
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1750)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1290)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2502)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2535)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2320)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    at sun.reflect.GeneratedConstructorAccessor13.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
[com.mchange.v2.resourcepool.BasicResourcePool]Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@18dea83e is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[org.hibernate.engine.jdbc.internal.JdbcServicesImpl]HHH000342: Could not obtain connection to query metadata : Connections could not be acquired from the underlying database!
[org.hibernate.dialect.Dialect]HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
[org.hibernate.engine.jdbc.internal.LobCreatorBuilder]HHH000422: Disabling contextual LOB creation as connection was null
[org.hibernate.engine.transaction.internal.TransactionFactoryInitiator]HHH000399: Using default transaction strategy (direct JDBC transactions)
[org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory]HHH000397: Using ASTQueryTranslatorFactory
[org.hibernate.tool.hbm2ddl.SchemaUpdate]HHH000228: Running hbm2ddl schema update
[org.hibernate.tool.hbm2ddl.SchemaUpdate]HHH000102: Fetching database metadata

 

同一台机器,同一个eclispe。两个不同的ssh项目,hibernate上配置文件的用户名和密码都一样,但是就是一个可以连接上,一个连接不上。快要爆炸了

 

加载中
0
罗文浩
罗文浩

你的工作区路径能用英文的吗?而且这问题一看应该是用户名密码错误问题,或者权限访问控制问题。。设置下权限。。。

罗文浩
罗文浩
回复 @MrMastiff : 那就是数据库权限需要开放下。在数据库中user系统表中,有Ip的限定权限,你去看看是否是这个问题所引起的。
MrMastiff
MrMastiff
用户名密码确定是无误的,但是我另外一个项目也是用同样的用户名密码,却可以连接上。如果是权限问题,那么我另外一个项目不是应该同样连接不上吗?
返回顶部
顶部