JDBC

[Houck, James]

Has anyone been able to get the jdbc functionality to work.

 

 I have tried several variations and get the following message over and over again.

 

ConnectionObject: e=java.sql.SQLException: No suitable driverurl = jdbc:null://jdbc:oracle:thin:@devora:1521:devora
ConnectionObject: e=java.sql.SQLException: No suitable driverurl = jdbc:null://jdbc:oracle:thin:@devora:1521:devora
ConnectionObject: e=java.sql.SQLException: No suitable driverurl = jdbc:null://jdbc:oracle:thin:@devora:1521:devora

 

Using

<?xml version="1.0"?>

 

<TestPlan>
<threadgroups>
<ThreadGroup name="ThreadGroup" numThreads="1">
<controllers>
<JdbcTestSample type="org.apache.jmeter.protocol.jdbc.control.JdbcTestSample" name="Database Testing">
<defaultDb>
<ConfigElement type="org.apache.jmeter.protocol.jdbc.config.DbConfig">
<property name="url">jdbc:oracle:thin:@devora:1521:devora</property>
<property name="password">ziabot</property>
<property name="driver">oracle.jdbc.driver.OracleDriver</property>
<property name="username">test</property>
</ConfigElement></defaultDb>
<defaultPool>
<ConfigElement type="org.apache.jmeter.protocol.jdbc.config.PoolConfig">
<property name="use">50</property>
<property name="num_connections">1</property>
</ConfigElement></defaultPool>
<sqlList>
<ConfigElement type="org.apache.jmeter.protocol.jdbc.config.SqlConfig">
<property name="name">Sql Query</property>
<property name="query">Select * from zips_users</property>
</ConfigElement>
</sqlList>
<configElements>
</configElements>
<controllers>
</controllers>
</JdbcTestSample>

 

</controllers>
<configElements>
</configElements>
<timers>
<Timer type="org.apache.jmeter.timers.ConstantTimer" name="Constant Timer">
<delay>300</delay>
<range>0.0</range>
</Timer>

 

</timers>
<listeners>
<JMeterComponent type="org.apache.jmeter.visualizers.GraphModel" name="Graph Results"/>
</listeners>
</ThreadGroup>

 

</threadgroups>
<configElements>
</configElements>
</TestPlan>

Thanks,

James R Houck
Zilliant
email: [EMAIL PROTECTED]
512.531.8514 Wk
512.531.8599 Fax
512.585.0112 Cell