PersistenceException:MyBatis项目Junit测试找不到数据源

Love The Way You Lie 2022-06-09 07:16 129阅读 0赞

org.apache.ibatis.exceptions.PersistenceException:  
\#\#\# Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: $\{jdbc.driver\}  
\#\#\# The error may exist in sqlmap/User.xml  
\#\#\# The error may involve test.findUserById  
\#\#\# The error occurred while executing a query  
\#\#\# Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: $\{jdbc.driver\}  
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66)  
at cn.itcast.mybatis.first.MybatisFirst.findUserByIdTest(MybatisFirst.java:55)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
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.ParentRunner.runLeaf(ParentRunner.java:263)  
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:69)  
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:48)  
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)  
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)  
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)  
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)  
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)  
at org.junit.runners.ParentRunner.run(ParentRunner.java:292)  
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)  
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)  
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)  
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)  
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)  
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)  
Caused by: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: $\{jdbc.driver\}  
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.initializeDriver(UnpooledDataSource.java:215)  
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:194)  
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:190)  
at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:92)  
at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:375)  
at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:84)  
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:134)  
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:61)  
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)  
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:72)  
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:59)  
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)  
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)  
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)  
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)  
... 26 more

原因：SqlMapConfig.xml中忘了引入db.properties文件。

<properties resource="db.properties"/>