数据库异常Cannot create PoolableConnectionFactory (Unknown database '11')

 

此异常出现原因为配置文件中的数据库名不存在

解决办法:修改配置文件中的数据库名或新建配置文件中指定的数据库

 

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown database '11')

    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)

    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

    at org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:156)

    at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:453)

    at cn.twitter.dao.BlogDaoImpl.insert(BlogDaoImpl.java:166)

    at cn.twitter.service.BlogServiceImpl.insert(BlogServiceImpl.java:17)

    at cn.twitter.junit.Test2.insert(Test2.java:29)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:597)

    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)

    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)

    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)

    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)

    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)

    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)

    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)

    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)

    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)

    at org.junit.runners.ParentRunner.run(ParentRunner.java:236)

    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49)

    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database '11'

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

    at com.mysql.jdbc.Util.getInstance(Util.java:381)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)

    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)

    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)

    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)

    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

    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:283)

    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)

    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)

    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)

    ... 28 more

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown database '11')

    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)

    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

    at cn.twitter.util.JdbcUtil.getConn(JdbcUtil.java:39)

    at cn.twitter.dao.BlogDaoImpl.findByUsername(BlogDaoImpl.java:189)

    at cn.twitter.service.BlogServiceImpl.findByUsername(BlogServiceImpl.java:52)

    at cn.twitter.junit.Test2.findByUsername(Test2.java:33)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:597)

    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)

    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)

    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)

    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)

    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)

    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)

    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)

    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)

    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)

    at org.junit.runners.ParentRunner.run(ParentRunner.java:236)

    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49)

    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database '11'

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

    at com.mysql.jdbc.Util.getInstance(Util.java:381)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)

    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)

    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)

    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)

    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

    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:283)

    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)

    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)

    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)

    ... 27 more

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值