com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'

 

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'

[plain]  view plain  copy

 print ?

1. 2014-7-12 21:06:05 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager  
2. 信息: 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 -> x3reqp93bublw71xo3ley|1e1225d, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> x3reqp93bublw71xo3ley|1e1225d, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/user, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 600, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 2, numHelperThreads -> 10, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]  
3. 2014-7-12 21:06:37 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask run  
4. 警告: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@10f7612 -- 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:   
5. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'  
6.     at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown Source)  
7.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)  
8.     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)  
9.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)  
10.     at com.mysql.jdbc.Util.getInstance(Util.java:386)  
11.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)  
12.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)  
13.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)  
14.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)  
15.     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4686)  
16.     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1304)  
17.     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483)  
18.     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)  
19.     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)  
20.     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)  
21.     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)  
22.     at sun.reflect.GeneratedConstructorAccessor16.newInstance(Unknown Source)  
23.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)  
24.     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)  
25.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)  
26.     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)  
27.     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)  
28.     at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)  
29.     at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)  
30.     at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)  
31.     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)  
32.     at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)  
33.     at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)  
34.     at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)  
35.     at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)  
36.     at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)  
37. 2014-7-12 21:06:37 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcquires  
38. 警告: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6ccf3e is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.  
39. 2014-7-12 21:06:37 org.hibernate.engine.jdbc.internal.JdbcServicesImpl configure  
40. WARN: HHH000342: Could not obtain connection to query metadata : Connections could not be acquired from the underlying database!  
41. 2014-7-12 21:06:37 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask run  
42. 警告: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1748ba4 -- 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:   
43. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'  
44.     at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown Source)  
45.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)  
46.     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)  
47.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)  
48.     at com.mysql.jdbc.Util.getInstance(Util.java:386)  
49.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)  
50.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)  
51.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)  
52.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)  
53.     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4686)  
54.     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1304)  
55.     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483)  
56.     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)  
57.     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)  
58.     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)  
59.     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)  
60.     at sun.reflect.GeneratedConstructorAccessor16.newInstance(Unknown Source)  
61.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)  
62.     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)  
63.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)  
64.     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)  
65.     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)  
66.     at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)  
67.     at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)  
68.     at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)  
69.     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)  
70.     at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)  
71.     at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)  
72.     at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)  
73.     at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)  
74.     at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)  
75. 2014-7-12 21:06:37 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcquires  
76. 警告: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6ccf3e is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.  
77. 2014-7-12 21:06:37 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask run  
78. 警告: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1bf8a41 -- 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:   
79. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'  
80.     at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown Source)  
81.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)  
82.     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)  
83.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)  
84.     at com.mysql.jdbc.Util.getInstance(Util.java:386)  
85.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)  
86.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)  
87.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)  
88.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)  
89.     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4686)  
90.     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1304)  
91.     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483)  
92.     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)  
93.     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)  
94.     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)  
95.     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)  
96.     at sun.reflect.GeneratedConstructorAccessor16.newInstance(Unknown Source)  
97.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)  
98.     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)  
99.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)  
100.     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)  
101.     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)  
102.     at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)  
103.     at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)  
104.     at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)  
105.     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)  
106.     at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)  
107.     at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)  
108.     at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)  
109.     at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)  
110.     at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)  
111. 2014-7-12 21:06:37 com.mchange.v2.resourcepool.BasicResourcePool forceKillAcquires  
112. 警告: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6ccf3e is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.  
113. 2014-7-12 21:06:37 org.hibernate.dialect.Dialect <init>  
114. INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect  

2、错误原因

      由于MySQL数据库中没有创建user数据库，导致出错

3、解决办法

  

2