On 16 June 2011 17:21, Konstantin S. <mko...@gmail.com> wrote:
> Response message: java.sql.SQLException: No suitable driver found for
> ${databaseUrl}
>
> It looks like sample ( whichever  you use) can not obtain value of variable

Yes, because the JDBC Config reads the variable before CSV Dataset has run.

Try defining the variables on the Test Plan.

> and tries to pass this  ${databaseUrl} instead of the value .

> I guess error should be like...
>
> Response message: java.sql.SQLException: No suitable driver found for
> jdbc:mysql://localhost:3306/osax

Yes, it would be if the variable were defined but incorrect.

>
> On Thu, Jun 16, 2011 at 7:12 PM, Alexander Guzman
> <aguz...@tlcdelivers.com>wrote:
>
>> JMeter Version:  2.4 r961953
>>
>>
>>
>> I’m attempting to load the connection information from an external CSV
>> file.
>> I’ve attached a Debug Sampler and can see that the variables are making it
>> into memory as seen below.
>>
>>
>>
>> JMeterVariables:
>>
>>
>> DatabaseConnection=org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl@29021f42
>>
>> JMeterThread.last_sample_ok=true
>>
>> JMeterThread.pack=org.apache.jmeter.threads.SamplePackage@4a523b16
>>
>> START.HMS=172648
>>
>> START.MS=1308094008358
>>
>> START.YMD=20110614
>>
>> TESTSTART.MS=1308155812780
>>
>> databaseJDBCDriverClass=com.mysql.jdbc.Driver
>>
>> databasePassword=test
>>
>> databaseUrl=jdbc:mysql://localhost:3306/osax
>>
>> databaseUser=test
>>
>>
>>
>> But I’m unable to use any of the variables in the JDBC Connection
>> Configuration as seen below:
>>
>>
>>
>> Thread Name: Thread Users 1-1
>>
>> Sample Start: 2011-06-15 10:36:51 MDT
>>
>> Load time: 0
>>
>> Latency: 0
>>
>> Size in bytes: 0
>>
>> Sample Count: 1
>>
>> Error Count: 1
>>
>> Response code: 08001 0
>>
>> Response message: java.sql.SQLException: No suitable driver found for
>> ${databaseUrl}
>>
>>
>>
>> Does anyone have any input because I’m lost at this point. Any help would
>> be
>> appreciated.
>>
>>
>>
>> Regards,
>>
>> Xander
>>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org
For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org

Reply via email to