java - 为什么无法在 JTesterDataSource 中注册 SQL 驱动程序？

Question

我编写了一个测试类来测试我的代码。
我的数据库配置在jtester.properties中，文件如下:

 database.type=MYSQL
 database.url=jdbc:mysql://xxxx:3311/ae_fc_00
 database.userName=xxxx
 database.password=xxxx
 database.driverClassName=com.mysql.jdbc.Driver

我确定用户名、网址和密码正确。但是当我运行测试时，出现如下错误:

java.lang.RuntimeException: Cannot register SQL driver com.mysql.jdbc.Driver
    at org.jtester.module.database.JTesterDataSource.registerDriver(JTesterDataSource.java:175)
    at org.jtester.module.database.JTesterDataSource.createDataSource(JTesterDataSource.java:49)
    at org.jtester.module.database.JTesterDataSource.<init>(JTesterDataSource.java:44)
    at org.jtester.module.database.environment.AbstractDBEnvironment.setDataSource(AbstractDBEnvironment.java:68)
    at org.jtester.module.database.environment.DBEnvironmentFactory.getDBEnvironment(DBEnvironmentFactory.java:156)
    at org.jtester.module.database.environment.DBEnvironmentFactory.getDBEnvironment(DBEnvironmentFactory.java:93)
    at org.jtester.module.database.environment.DBEnvironmentFactory.getCurrentDBEnvironment(DBEnvironmentFactory.java:192)
    at org.jtester.core.context.TransactionManager.startTransaction(TransactionManager.java:47)
    at com.alibaba.qa.qtester.module.DatabaseModule$DatabaseTestListener.beforeMethodRunning(DatabaseModule.java:141)
    at org.jtester.module.core.CoreModule$CoreModuleListener.beforeMethodRunning(CoreModule.java:126)
    at org.jtester.core.ListenerExecutor.executeBeforeMethodRunningEvents(ListenerExecutor.java:73)
    at com.alibaba.qa.qtester.unitils.QTesterTestNG.run(QTesterTestNG.java:228)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at org.testng.internal.MethodInvocationHelper.invokeHookable(MethodInvocationHelper.java:194)
    at org.testng.internal.Invoker.invokeMethod(Invoker.java:707)
    at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
    at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
    at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
    at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
    at org.testng.TestRunner.privateRun(TestRunner.java:767)
    at org.testng.TestRunner.run(TestRunner.java:617)
    at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
    at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
    at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
    at org.testng.SuiteRunner.run(SuiteRunner.java:240)
    at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
    at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
    at org.testng.TestNG.runSuitesSequentially(TestNG.java:1198)
    at org.testng.TestNG.runSuitesLocally(TestNG.java:1123)
    at org.testng.TestNG.run(TestNG.java:1031)
    at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:115)
    at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:207)
    at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:178)

请帮助我...我的jtester版本是1.1.8

Answer 1

您的项目的类路径中可能不包含 mysql 驱动程序。

如果是maven项目，在pom.xml中添加以下配置

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
</dependency>

否则，下载驱动程序文件 from here并将其包含在您的项目中