无法使用gradle运行Jmeter (数据库测试)脚本

Question

我无法使用带有数据库检查点测试的gradle任务'jmeterRun‘来运行JMX文件。我收到了错误信息

"Could not return Connection java.sql.SQLException: No suitable driver found" in the jmeter.log file.

以下是我的JDBC连接配置：

以下是build.gradle：

 apply plugin: 'jmeter'
 apply plugin: 'java'

  dependencies {
 testRuntime "com.oracle:ojdbc6:11.2.0.3"
 }

 buildscript {      

    repositories {
        mavenCentral()
    }
    dependencies {
        classpath "com.github.kulya:jmeter-gradle-plugin:1.3.2-2.9"
        //classpath "com.github.kulya:jmeter-gradle-plugin:1.3.4-2.13"
        classpath "kg.apc:jmeter-plugins:1.1.3"
        classpath "kg.apc:jmeter-plugins-standard:1.1.3"
        classpath "kg.apc:jmeter-plugins-extras:1.1.3"
    }
}

jmeterRun.configure {
jmeterTestFiles = [file("src/test/resources/Zone_RR_CRUD.jmx")]
jmeterPropertyFile = file("src/test/resources/jmeter.properties")
}

Jmeter.log

2015/08/17 12:05:05 WARN - jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@coredb-useast1c01-02.qa.ultradns.net:2115:CUE1C2Q at java.sql.DriverManager.getConnection(DriverManager.java:604) at java.sql.DriverManager.getConnection(DriverManager.java:221) at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182) at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655) at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145) at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:91) at org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371) at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97) at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:188) at org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:286) at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:146) at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:85) at org.apache.jmeter.threads.JMeterThread.process_sampler(JMeterThread.java:434) at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:261) at java.lang.Thread.run(Thread.java:722)

当我将ojdbc6.jar放在本地计算机上的jmeter/lib文件夹中时，同样的事情也很正常。

当我运行gradle任务，即jmeterRun时，我不知道它将如何工作。

Answer 1

当JDBC驱动程序丢失时，通常会观察到此错误。没有为jdbc:oracle:thin:@coredb-useast1c01-02.qa.ultradns.net:2115:CUE1C2Q找到合适的驱动程序，您能尝试将驱动程序jar放在JMeter lib文件夹中吗？

Answer 2

您需要将JDBC驱动程序类路径添加到从repo中提取的依赖项中。问题是，您从Maven构建的JMeter缺少JDBC驱动程序，通过Maven将其拉进来，应该可以修复这个问题。