Load Testing the MySql Database

[Jatin Davey <ja...@cisco.com>]

Hi All

I want to load test my MySql Database. I was reading the JMeter user 
manual on how to do this and found the following page on it:

http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html

In the first few lines i found , " This example uses the MySQL database 
driver. To use this driver, its containing .jar file must be copied to 
the JMeter *lib * directory".

I dont know what database driver to pick to that JMeter could contact my 
Database. I was having the MySql Query tool in my PC Which query's the 
MySql DB for the constructed queries. I assume this tool also needs the 
"MySQL database driver" , so i searched for the driver in its lib 
directory and found the following:

mysql-connector-java-5.0.4-bin.jar

I am not sure whether this is the same driver that needs to be used with 
JMeter to connect it to my MySql Database.
Please let me know if i could make use of this driver or i need anything 
else to load my DB.

Thanks
Jatin

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

Re: Load Testing the MySql Database

[Jakub Białek <ra...@gmail.com>]

Currently I have no idea what it doesn't work. If you want send my
your test plan and I'll look at it and maybe then I'll find the
solution.

BTW. You should try the newest version of connector for MySQL 5.0.x
which is 5.0.8

Best regards,
Jakub


2009/9/28 Jatin Davey <ja...@cisco.com>:
> Hi
>
> I did put the string " com.mysql.jdbc.Driver" in the field JDBC Driver class
> in the JDBC connection configuration.
>
> I am using JMeter 2.3.4
>
> Thanks
> Jatin
>
> Jakub Bia?ek wrote:
>>
>> It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
>> Driver class in JDBC Connection Configuration, if this still doesn't
>> work send my your test plan.
>>
>> BTW. Which version of jmeter do you use?
>>
>> Best regards,
>> Jakub
>>
>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>
>>>
>>> Yes , JMeter was re-started after copying the .Jar file.
>>> Still i am seeing the same error.
>>>
>>> Thanks
>>> Jatin
>>>
>>> Jakub Bia?ek wrote:
>>>
>>>>
>>>> Do you restart jmeter after you copy
>>>> mysql-connector-java-5.0.4-bin.jar to lib directory?
>>>>
>>>> Jakub
>>>>
>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>
>>>>
>>>>>
>>>>> I copied the
>>>>>
>>>>> mysql-connector-java-5.0.4-bin.jar into JMeter's lib directory as it
>>>>> was
>>>>> working fine with the MySql Query browser with my DB. But when i run it
>>>>> with
>>>>> JMeter i got the following error message in the listeners's Tree:
>>>>>
>>>>> Response message: java.sql.SQLException: No suitable driver found for
>>>>> jdbc:mysql://172.20.106.119:3309/ciscomd
>>>>>
>>>>> I am trying to connect to a data base remotely. Adding one more point ,
>>>>> this
>>>>> is what i used as the JDBC Driver class: com.mysql.jdbc.Driver in the
>>>>> JDBC
>>>>> connection configuration.
>>>>>
>>>>> Please let me know if i am missing something.
>>>>>
>>>>>
>>>>> Thanks
>>>>> Jatin
>>>>>
>>>>>
>>>>> Jakub Bia?ek wrote:
>>>>>
>>>>>
>>>>>>
>>>>>> You only have to copy this jar to jmeter lib directory, remember to
>>>>>> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x, don't
>>>>>> mix them!
>>>>>> Then you need to configure connection and sampler:
>>>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>>>
>>>>>> Best regards,
>>>>>> Jakub
>>>>>>
>>>>>>
>>>>>>
>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>
>>>>>>
>>>>>>
>>>>>>>
>>>>>>> I downloaded the driver from the location mentioned below. Should i
>>>>>>> copy
>>>>>>> only the .Jar file into JMeter's lib directory or anything else is
>>>>>>> also
>>>>>>> required.
>>>>>>> Please let me know.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Jatin
>>>>>>>
>>>>>>> Jakub Bia?ek wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>> Hi!
>>>>>>>>
>>>>>>>> Yes, you can use this driver, it's a bit old but if you use MySQL
>>>>>>>> 5.0.x it should work fine.
>>>>>>>> For MySQL 5.1.x you need another driver, here is place where you can
>>>>>>>> download appropriate connector (for all version of MySQL db):
>>>>>>>>
>>>>>>>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>>>>>>>
>>>>>>>> Best regards,
>>>>>>>> Jakub
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>
>>>>>>>>> Hi All
>>>>>>>>>
>>>>>>>>> I want to load test my MySql Database. I was reading the JMeter
>>>>>>>>> user
>>>>>>>>> manual
>>>>>>>>> on how to do this and found the following page on it:
>>>>>>>>>
>>>>>>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>>>>>>
>>>>>>>>> In the first few lines i found , " This example uses the MySQL
>>>>>>>>> database
>>>>>>>>> driver. To use this driver, its containing .jar file must be copied
>>>>>>>>> to
>>>>>>>>> the
>>>>>>>>> JMeter *lib * directory".
>>>>>>>>>
>>>>>>>>> I dont know what database driver to pick to that JMeter could
>>>>>>>>> contact
>>>>>>>>> my
>>>>>>>>> Database. I was having the MySql Query tool in my PC Which query's
>>>>>>>>> the
>>>>>>>>> MySql
>>>>>>>>> DB for the constructed queries. I assume this tool also needs the
>>>>>>>>> "MySQL
>>>>>>>>> database driver" , so i searched for the driver in its lib
>>>>>>>>> directory
>>>>>>>>> and
>>>>>>>>> found the following:
>>>>>>>>>
>>>>>>>>> mysql-connector-java-5.0.4-bin.jar
>>>>>>>>>
>>>>>>>>> I am not sure whether this is the same driver that needs to be used
>>>>>>>>> with
>>>>>>>>> JMeter to connect it to my MySql Database.
>>>>>>>>> Please let me know if i could make use of this driver or i need
>>>>>>>>> anything
>>>>>>>>> else to load my DB.
>>>>>>>>>
>>>>>>>>> Thanks
>>>>>>>>> Jatin
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ---------------------------------------------------------------------
>>>>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>>>> For additional commands, e-mail:
>>>>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> ---------------------------------------------------------------------
>>>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> ---------------------------------------------------------------------
>>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

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

Re: Load Testing the MySql Database

[Jatin Davey <ja...@cisco.com>]

Hi

I have nailed down the issue , the issue was with the MySql Connector 
version 5.0.4 , I tried with the latest version in 5.0 which is 5.0.8 
and it worked fine.

Thanks to Sebb and Jakub.

Thanks
Jatin

sebb wrote:
> On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
>   
>> Hi
>>
>>  The Following Jar : mysql-connector-java-5.0.4-bin.jar  is
>> definitely placed in the following directory: C:\jakarta-jmeter-2.3.4\lib
>>
>>  All that i have in PC is JRE 1.6 so i am sure JMeter is using it.
>>     
>
> What does the JMeter log file say?
> It logs the JVM details near the beginning.
>
>   
>> But still
>> it does not work. All that i get in the sample result is :
>>
>>  Thread Name: Thread Group 1-1
>>  Sample Start: 2009-09-28 16:40:13 IST
>>  Load time: 1
>>  Latency: 1
>>  Size in bytes: 0
>>  Sample Count: 1
>>  Error Count: 1
>>  Response code: 08001 0
>>  Response message: java.sql.SQLException: No suitable driver found for
>> jdbc:mysql://172.20.106.119:3309/ciscomd
>>     
>
> Try selecting the JDBC Config element.
> Use Help/Enable Debug to temporarily enable debugging.
> Run the test again, and check the lines in the jmeter log file for clues:
>
> e.g.
>
> DEBUG - jmeter.protocol.jdbc.config.DataSourceElement: MaxPool: 1
> Timeout: 10000 TrimInt: 60000 Auto-Commit: true
> etc.
>
>   
>>  Response headers:
>>
>>
>>  SampleResult fields:
>>  ContentType: text/plain
>>  DataEncoding: UTF-8
>>
>>
>>
>>  Thanks
>>  Jatin
>>
>>  sebb wrote:
>>
>>     
>>> On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
>>>
>>>
>>>       
>>>> Hi
>>>>
>>>>  The leading spaces are being added by mistake as part of sending the
>>>>         
>> mail.
>>     
>>>> It is not there when i execute the Tests in JMeter. So this should not
>>>>         
>> be
>>     
>>>> the issue.
>>>>  Secondly as you said i verified with WinRar to ascertain whether there
>>>>         
>> is a
>>     
>>>> class named as "Driver" in the com/mysql/jdbc  directory structure , it
>>>>         
>> is
>>     
>>>> available.
>>>>
>>>>
>>>>         
>>> And the jar is definitely in the lib directory?
>>>
>>> Then all I can think of is maybe the jar requires Java 1.5 or 1.6; try
>>> running JMeter with a later version of Java.
>>>
>>>
>>>
>>>       
>>>>  Thanks
>>>>  Jatin
>>>>
>>>>
>>>>  sebb wrote:
>>>>
>>>>
>>>>
>>>>         
>>>>> On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>           
>>>>>> Hi
>>>>>>
>>>>>>  I did put the string " com.mysql.jdbc.Driver" in the field JDBC
>>>>>>             
>> Driver
>>     
>>>>>>
>>>>>>
>>>>>>             
>>>>> If there really is a leading space in the field then it won't work.
>>>>>
>>>>> Also, check that the class is present in the jar file (you can open a
>>>>> jar file with an application that opens zip files).
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>           
>>>>>> class in the JDBC connection configuration.
>>>>>>
>>>>>>  I am using JMeter 2.3.4
>>>>>>
>>>>>>
>>>>>>  Thanks
>>>>>>  Jatin
>>>>>>
>>>>>>  Jakub Bia?ek wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>> It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
>>>>>>> Driver class in JDBC Connection Configuration, if this still
>>>>>>>               
>> doesn't
>>     
>>>>>>> work send my your test plan.
>>>>>>>
>>>>>>> BTW. Which version of jmeter do you use?
>>>>>>>
>>>>>>> Best regards,
>>>>>>> Jakub
>>>>>>>
>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>>>> Yes , JMeter was re-started after copying the .Jar file.
>>>>>>>> Still i am seeing the same error.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Jatin
>>>>>>>>
>>>>>>>> Jakub Bia?ek wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>>>>>>> Do you restart jmeter after you copy
>>>>>>>>> mysql-connector-java-5.0.4-bin.jar to lib
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>>>> directory?
>>>>
>>>>
>>>>         
>>>>>>>>> Jakub
>>>>>>>>>
>>>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>>>>>>>>>> I copied the
>>>>>>>>>>
>>>>>>>>>> mysql-connector-java-5.0.4-bin.jar into
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>> JMeter's
>>>>
>>>>
>>>>         
>>>>>>>>>>                     
>>>>>> lib directory as it was
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>> working fine with the MySql Query browser with my DB. But
>>>>>>>>>>                     
>> when i
>>     
>>>>>>>>>>                     
>>>> run
>>>>
>>>>
>>>>         
>>>>>>>>>>                     
>>>>>> it
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>> with
>>>>>>>>>> JMeter i got the following error message in the listeners's
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>> Tree:
>>>>
>>>>
>>>>         
>>>>>>>>>> Response message: java.sql.SQLException: No suitable driver
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>> found
>>>>
>>>>
>>>>         
>>>>>>>>>>                     
>>>>>> for
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>> jdbc:mysql://172.20.106.119:3309/ciscomd
>>>>>>>>>>
>>>>>>>>>> I am trying to connect to a data base remotely. Adding one
>>>>>>>>>>                     
>> more
>>     
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>>>> point ,
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>> this
>>>>>>>>>> is what i used as the JDBC Driver class:
>>>>>>>>>>                     
>> com.mysql.jdbc.Driver
>>     
>>>>>>>>>>                     
>>>> in
>>>>
>>>>
>>>>         
>>>>>>>>>>                     
>>>>>> the
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>> JDBC
>>>>>>>>>> connection configuration.
>>>>>>>>>>
>>>>>>>>>> Please let me know if i am missing something.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Thanks
>>>>>>>>>> Jatin
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Jakub Bia?ek wrote:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>>>>>>>>> You only have to copy this jar to jmeter lib directory,
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>> remember
>>>>
>>>>
>>>>         
>>>>>>>>>>>                       
>>>>>> to
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>> 5.0.x,
>>>>
>>>>
>>>>         
>>>>>>>>>>>                       
>>>>>> don't
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>> mix them!
>>>>>>>>>>> Then you need to configure connection and sampler:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>     
>>>>         
>>>>>>             
>>>>>>>>>>> Best regards,
>>>>>>>>>>> Jakub
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>>>>>>>>>> I downloaded the driver from the location mentioned
>>>>>>>>>>>>                         
>> below.
>>     
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>>>> Should i
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>> copy
>>>>>>>>>>>> only the .Jar file into JMeter's lib directory or
>>>>>>>>>>>>                         
>> anything
>>     
>>>>>>>>>>>>                         
>>>> else
>>>>
>>>>
>>>>         
>>>>>>>>>>>>                         
>>>>>> is also
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>> required.
>>>>>>>>>>>> Please let me know.
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks
>>>>>>>>>>>> Jatin
>>>>>>>>>>>>
>>>>>>>>>>>> Jakub Bia?ek wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>>>>>>>>>>> Hi!
>>>>>>>>>>>>>
>>>>>>>>>>>>> Yes, you can use this driver, it's a bit old but if
>>>>>>>>>>>>>                           
>> you
>>     
>>>>>>>>>>>>>                           
>>>> use
>>>>
>>>>
>>>>         
>>>>>>>>>>>>>                           
>>>>>> MySQL
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>> 5.0.x it should work fine.
>>>>>>>>>>>>> For MySQL 5.1.x you need another driver, here is place
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>                           
>>>> where
>>>>
>>>>
>>>>         
>>>>>>>>>>>>>                           
>>>>>> you can
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>> download appropriate connector (for all version of
>>>>>>>>>>>>>                           
>> MySQL
>>     
>>>>>>>>>>>>>                           
>>>> db):
>>>>
>>>>
>>>>         
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>                           
>>>>>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>> Best regards,
>>>>>>>>>>>>> Jakub
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>                           
>>>>>>>>>>>>>> Hi All
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> I want to load test my MySql Database. I was reading
>>>>>>>>>>>>>>                             
>> the
>>     
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>>>>>> JMeter user
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> manual
>>>>>>>>>>>>>> on how to do this and found the following page on
>>>>>>>>>>>>>>                             
>> it:
>>     
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>     
>>>>         
>>>>>>             
>>>>>>>>>>>>>> In the first few lines i found , " This example uses
>>>>>>>>>>>>>>                             
>> the
>>     
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>>>>>> MySQL
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> database
>>>>>>>>>>>>>> driver. To use this driver, its containing .jar file
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>>>> must be
>>>>
>>>>
>>>>         
>>>>>>>>>>>>>>                             
>>>>>> copied
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> to
>>>>>>>>>>>>>> the
>>>>>>>>>>>>>> JMeter *lib * directory".
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> I dont know what database driver to pick to that
>>>>>>>>>>>>>>                             
>> JMeter
>>     
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>>>>>> could contact
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> my
>>>>>>>>>>>>>> Database. I was having the MySql Query tool in my PC
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>>>> Which
>>>>
>>>>
>>>>         
>>>>>>>>>>>>>>                             
>>>>>> query's
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> the
>>>>>>>>>>>>>> MySql
>>>>>>>>>>>>>> DB for the constructed queries. I assume this tool
>>>>>>>>>>>>>>                             
>> also
>>     
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>>>>>> needs the
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> "MySQL
>>>>>>>>>>>>>> database driver" , so i searched for the driver in
>>>>>>>>>>>>>>                             
>> its
>>     
>>>>>>>>>>>>>>                             
>>>> lib
>>>>
>>>>
>>>>         
>>>>>>>>>>>>>>                             
>>>>>> directory
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> and
>>>>>>>>>>>>>> found the following:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> mysql-connector-java-5.0.4-bin.jar
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> I am not sure whether this is the same driver that
>>>>>>>>>>>>>>                             
>> needs
>>     
>>>>>>>>>>>>>>                             
>>>> to
>>>>
>>>>
>>>>         
>>>>>>>>>>>>>>                             
>>>>>> be used
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> with
>>>>>>>>>>>>>> JMeter to connect it to my MySql Database.
>>>>>>>>>>>>>> Please let me know if i could make use of this
>>>>>>>>>>>>>>                             
>> driver or
>>     
>>>>>>>>>>>>>>                             
>>>> i
>>>>
>>>>
>>>>         
>>>>>>>>>>>>>>                             
>>>>>> need
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> anything
>>>>>>>>>>>>>> else to load my DB.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Thanks
>>>>>>>>>>>>>> Jatin
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>             
>>>>>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>                             
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>             
>>>>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>                           
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>                           
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>                           
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>             
>>>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>             
>>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>             
>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>             
>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>             
>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>> For additional commands, e-mail:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>>>>>               
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>             
>>>>>>> To unsubscribe, e-mail:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>> For additional commands, e-mail:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>
>>>>>>>
>>>>>>>               
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>  To unsubscribe, e-mail:
>>>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>  For additional commands, e-mail:
>>>>>> jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>           
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>> To unsubscribe, e-mail:
>>>>>
>>>>>
>>>>>           
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>> For additional commands, e-mail:
>>>>>
>>>>>
>>>>>           
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>
>>>>>
>>>>>           
>> ---------------------------------------------------------------------
>>     
>>>>  To unsubscribe, e-mail:
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>  For additional commands, e-mail:
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>         
>>>       
>> ---------------------------------------------------------------------
>>     
>>> To unsubscribe, e-mail:
>>>       
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>> For additional commands, e-mail:
>>>       
>> jmeter-user-help@jakarta.apache.org
>>     
>>>
>>>
>>>       
>> ---------------------------------------------------------------------
>>  To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>>  For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>>
>>
>>     
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>   

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

Re: Load Testing the MySql Database

[sebb <se...@gmail.com>]

On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
> Hi
>
>  The Following Jar : mysql-connector-java-5.0.4-bin.jar  is
> definitely placed in the following directory: C:\jakarta-jmeter-2.3.4\lib
>
>  All that i have in PC is JRE 1.6 so i am sure JMeter is using it.

What does the JMeter log file say?
It logs the JVM details near the beginning.

> But still
> it does not work. All that i get in the sample result is :
>
>  Thread Name: Thread Group 1-1
>  Sample Start: 2009-09-28 16:40:13 IST
>  Load time: 1
>  Latency: 1
>  Size in bytes: 0
>  Sample Count: 1
>  Error Count: 1
>  Response code: 08001 0
>  Response message: java.sql.SQLException: No suitable driver found for
> jdbc:mysql://172.20.106.119:3309/ciscomd

Try selecting the JDBC Config element.
Use Help/Enable Debug to temporarily enable debugging.
Run the test again, and check the lines in the jmeter log file for clues:

e.g.

DEBUG - jmeter.protocol.jdbc.config.DataSourceElement: MaxPool: 1
Timeout: 10000 TrimInt: 60000 Auto-Commit: true
etc.

>  Response headers:
>
>
>  SampleResult fields:
>  ContentType: text/plain
>  DataEncoding: UTF-8
>
>
>
>  Thanks
>  Jatin
>
>  sebb wrote:
>
> > On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
> >
> >
> > > Hi
> > >
> > >  The leading spaces are being added by mistake as part of sending the
> mail.
> > > It is not there when i execute the Tests in JMeter. So this should not
> be
> > > the issue.
> > >  Secondly as you said i verified with WinRar to ascertain whether there
> is a
> > > class named as "Driver" in the com/mysql/jdbc  directory structure , it
> is
> > > available.
> > >
> > >
> >
> > And the jar is definitely in the lib directory?
> >
> > Then all I can think of is maybe the jar requires Java 1.5 or 1.6; try
> > running JMeter with a later version of Java.
> >
> >
> >
> > >  Thanks
> > >  Jatin
> > >
> > >
> > >  sebb wrote:
> > >
> > >
> > >
> > > > On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
> > > >
> > > >
> > > >
> > > >
> > > > > Hi
> > > > >
> > > > >  I did put the string " com.mysql.jdbc.Driver" in the field JDBC
> Driver
> > > > >
> > > > >
> > > > >
> > > > >
> > > > If there really is a leading space in the field then it won't work.
> > > >
> > > > Also, check that the class is present in the jar file (you can open a
> > > > jar file with an application that opens zip files).
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > > class in the JDBC connection configuration.
> > > > >
> > > > >  I am using JMeter 2.3.4
> > > > >
> > > > >
> > > > >  Thanks
> > > > >  Jatin
> > > > >
> > > > >  Jakub Bia?ek wrote:
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > > It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
> > > > > > Driver class in JDBC Connection Configuration, if this still
> doesn't
> > > > > > work send my your test plan.
> > > > > >
> > > > > > BTW. Which version of jmeter do you use?
> > > > > >
> > > > > > Best regards,
> > > > > > Jakub
> > > > > >
> > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > > Yes , JMeter was re-started after copying the .Jar file.
> > > > > > > Still i am seeing the same error.
> > > > > > >
> > > > > > > Thanks
> > > > > > > Jatin
> > > > > > >
> > > > > > > Jakub Bia?ek wrote:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > > Do you restart jmeter after you copy
> > > > > > > > mysql-connector-java-5.0.4-bin.jar to lib
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > directory?
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > > Jakub
> > > > > > > >
> > > > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > > I copied the
> > > > > > > > >
> > > > > > > > > mysql-connector-java-5.0.4-bin.jar into
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > JMeter's
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > lib directory as it was
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > working fine with the MySql Query browser with my DB. But
> when i
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > run
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > it
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > with
> > > > > > > > > JMeter i got the following error message in the listeners's
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > Tree:
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > Response message: java.sql.SQLException: No suitable driver
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > found
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > for
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > jdbc:mysql://172.20.106.119:3309/ciscomd
> > > > > > > > >
> > > > > > > > > I am trying to connect to a data base remotely. Adding one
> more
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > point ,
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > this
> > > > > > > > > is what i used as the JDBC Driver class:
> com.mysql.jdbc.Driver
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > in
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > the
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > JDBC
> > > > > > > > > connection configuration.
> > > > > > > > >
> > > > > > > > > Please let me know if i am missing something.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > > Jatin
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Jakub Bia?ek wrote:
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > > You only have to copy this jar to jmeter lib directory,
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > remember
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > to
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > 5.0.x,
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > don't
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > mix them!
> > > > > > > > > > Then you need to configure connection and sampler:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > Best regards,
> > > > > > > > > > Jakub
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > I downloaded the driver from the location mentioned
> below.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > Should i
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > copy
> > > > > > > > > > > only the .Jar file into JMeter's lib directory or
> anything
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > else
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > is also
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > required.
> > > > > > > > > > > Please let me know.
> > > > > > > > > > >
> > > > > > > > > > > Thanks
> > > > > > > > > > > Jatin
> > > > > > > > > > >
> > > > > > > > > > > Jakub Bia?ek wrote:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > > Hi!
> > > > > > > > > > > >
> > > > > > > > > > > > Yes, you can use this driver, it's a bit old but if
> you
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > use
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > MySQL
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > > 5.0.x it should work fine.
> > > > > > > > > > > > For MySQL 5.1.x you need another driver, here is place
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > where
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > you can
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > > download appropriate connector (for all version of
> MySQL
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > db):
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > http://dev.mysql.com/downloads/connector/j/5.1.html
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > > Best regards,
> > > > > > > > > > > > Jakub
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > Hi All
> > > > > > > > > > > > >
> > > > > > > > > > > > > I want to load test my MySql Database. I was reading
> the
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > JMeter user
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > manual
> > > > > > > > > > > > > on how to do this and found the following page on
> it:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > In the first few lines i found , " This example uses
> the
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > MySQL
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > database
> > > > > > > > > > > > > driver. To use this driver, its containing .jar file
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > must be
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > copied
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > to
> > > > > > > > > > > > > the
> > > > > > > > > > > > > JMeter *lib * directory".
> > > > > > > > > > > > >
> > > > > > > > > > > > > I dont know what database driver to pick to that
> JMeter
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > could contact
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > my
> > > > > > > > > > > > > Database. I was having the MySql Query tool in my PC
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > Which
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > query's
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > the
> > > > > > > > > > > > > MySql
> > > > > > > > > > > > > DB for the constructed queries. I assume this tool
> also
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > needs the
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > "MySQL
> > > > > > > > > > > > > database driver" , so i searched for the driver in
> its
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > lib
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > directory
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > and
> > > > > > > > > > > > > found the following:
> > > > > > > > > > > > >
> > > > > > > > > > > > > mysql-connector-java-5.0.4-bin.jar
> > > > > > > > > > > > >
> > > > > > > > > > > > > I am not sure whether this is the same driver that
> needs
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > to
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > be used
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > with
> > > > > > > > > > > > > JMeter to connect it to my MySql Database.
> > > > > > > > > > > > > Please let me know if i could make use of this
> driver or
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > i
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > need
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > anything
> > > > > > > > > > > > > else to load my DB.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Thanks
> > > > > > > > > > > > > Jatin
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > > For additional commands, e-mail:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > > For additional commands, e-mail:
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > For additional commands, e-mail:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > For additional commands, e-mail:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > For additional commands, e-mail:
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > > To unsubscribe, e-mail:
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > > For additional commands, e-mail:
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > >
> > > > > > > To unsubscribe, e-mail:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > > For additional commands, e-mail:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > > > To unsubscribe, e-mail:
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > > For additional commands, e-mail:
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >  To unsubscribe, e-mail:
> > > > > jmeter-user-unsubscribe@jakarta.apache.org
> > > > >  For additional commands, e-mail:
> > > > > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > > To unsubscribe, e-mail:
> > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > > For additional commands, e-mail:
> > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > >
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >  To unsubscribe, e-mail:
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >  For additional commands, e-mail:
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > >
> > >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> >
> >
> >
> >
>
> ---------------------------------------------------------------------
>  To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
>  For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
>
>

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

Re: Load Testing the MySql Database

[Jatin Davey <ja...@cisco.com>]

Hi

The Following Jar : mysql-connector-java-5.0.4-bin.jar  is definitely 
placed in the following directory: C:\jakarta-jmeter-2.3.4\lib

All that i have in PC is JRE 1.6 so i am sure JMeter is using it. But 
still it does not work. All that i get in the sample result is :

Thread Name: Thread Group 1-1
Sample Start: 2009-09-28 16:40:13 IST
Load time: 1
Latency: 1
Size in bytes: 0
Sample Count: 1
Error Count: 1
Response code: 08001 0
Response message: java.sql.SQLException: No suitable driver found for 
jdbc:mysql://172.20.106.119:3309/ciscomd

Response headers:


SampleResult fields:
ContentType: text/plain
DataEncoding: UTF-8


Thanks
Jatin

sebb wrote:
> On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
>   
>> Hi
>>
>>  The leading spaces are being added by mistake as part of sending the mail.
>> It is not there when i execute the Tests in JMeter. So this should not be
>> the issue.
>>  Secondly as you said i verified with WinRar to ascertain whether there is a
>> class named as "Driver" in the com/mysql/jdbc  directory structure , it is
>> available.
>>     
>
> And the jar is definitely in the lib directory?
>
> Then all I can think of is maybe the jar requires Java 1.5 or 1.6; try
> running JMeter with a later version of Java.
>
>   
>>  Thanks
>>  Jatin
>>
>>
>>  sebb wrote:
>>
>>     
>>> On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
>>>
>>>
>>>       
>>>> Hi
>>>>
>>>>  I did put the string " com.mysql.jdbc.Driver" in the field JDBC Driver
>>>>
>>>>
>>>>         
>>> If there really is a leading space in the field then it won't work.
>>>
>>> Also, check that the class is present in the jar file (you can open a
>>> jar file with an application that opens zip files).
>>>
>>>
>>>
>>>       
>>>> class in the JDBC connection configuration.
>>>>
>>>>  I am using JMeter 2.3.4
>>>>
>>>>
>>>>  Thanks
>>>>  Jatin
>>>>
>>>>  Jakub Bia?ek wrote:
>>>>
>>>>
>>>>
>>>>         
>>>>> It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
>>>>> Driver class in JDBC Connection Configuration, if this still doesn't
>>>>> work send my your test plan.
>>>>>
>>>>> BTW. Which version of jmeter do you use?
>>>>>
>>>>> Best regards,
>>>>> Jakub
>>>>>
>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>           
>>>>>> Yes , JMeter was re-started after copying the .Jar file.
>>>>>> Still i am seeing the same error.
>>>>>>
>>>>>> Thanks
>>>>>> Jatin
>>>>>>
>>>>>> Jakub Bia?ek wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>> Do you restart jmeter after you copy
>>>>>>> mysql-connector-java-5.0.4-bin.jar to lib
>>>>>>>               
>> directory?
>>     
>>>>>>> Jakub
>>>>>>>
>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>>>> I copied the
>>>>>>>>
>>>>>>>> mysql-connector-java-5.0.4-bin.jar into
>>>>>>>>                 
>> JMeter's
>>     
>>>>>>>>                 
>>>> lib directory as it was
>>>>
>>>>
>>>>         
>>>>>>>> working fine with the MySql Query browser with my DB. But when i
>>>>>>>>                 
>> run
>>     
>>>>>>>>                 
>>>> it
>>>>
>>>>
>>>>         
>>>>>>>> with
>>>>>>>> JMeter i got the following error message in the listeners's
>>>>>>>>                 
>> Tree:
>>     
>>>>>>>> Response message: java.sql.SQLException: No suitable driver
>>>>>>>>                 
>> found
>>     
>>>>>>>>                 
>>>> for
>>>>
>>>>
>>>>         
>>>>>>>> jdbc:mysql://172.20.106.119:3309/ciscomd
>>>>>>>>
>>>>>>>> I am trying to connect to a data base remotely. Adding one more
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>> point ,
>>>>
>>>>
>>>>         
>>>>>>>> this
>>>>>>>> is what i used as the JDBC Driver class: com.mysql.jdbc.Driver
>>>>>>>>                 
>> in
>>     
>>>>>>>>                 
>>>> the
>>>>
>>>>
>>>>         
>>>>>>>> JDBC
>>>>>>>> connection configuration.
>>>>>>>>
>>>>>>>> Please let me know if i am missing something.
>>>>>>>>
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Jatin
>>>>>>>>
>>>>>>>>
>>>>>>>> Jakub Bia?ek wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>>>>>>> You only have to copy this jar to jmeter lib directory,
>>>>>>>>>                   
>> remember
>>     
>>>>>>>>>                   
>>>> to
>>>>
>>>>
>>>>         
>>>>>>>>> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL
>>>>>>>>>                   
>> 5.0.x,
>>     
>>>>>>>>>                   
>>>> don't
>>>>
>>>>
>>>>         
>>>>>>>>> mix them!
>>>>>>>>> Then you need to configure connection and sampler:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>     
>>>>         
>>>>>>>>> Best regards,
>>>>>>>>> Jakub
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>>>>>>>>>> I downloaded the driver from the location mentioned below.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>> Should i
>>>>
>>>>
>>>>         
>>>>>>>>>> copy
>>>>>>>>>> only the .Jar file into JMeter's lib directory or anything
>>>>>>>>>>                     
>> else
>>     
>>>>>>>>>>                     
>>>> is also
>>>>
>>>>
>>>>         
>>>>>>>>>> required.
>>>>>>>>>> Please let me know.
>>>>>>>>>>
>>>>>>>>>> Thanks
>>>>>>>>>> Jatin
>>>>>>>>>>
>>>>>>>>>> Jakub Bia?ek wrote:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>>>>>>>>> Hi!
>>>>>>>>>>>
>>>>>>>>>>> Yes, you can use this driver, it's a bit old but if you
>>>>>>>>>>>                       
>> use
>>     
>>>>>>>>>>>                       
>>>> MySQL
>>>>
>>>>
>>>>         
>>>>>>>>>>> 5.0.x it should work fine.
>>>>>>>>>>> For MySQL 5.1.x you need another driver, here is place
>>>>>>>>>>>                       
>> where
>>     
>>>>>>>>>>>                       
>>>> you can
>>>>
>>>>
>>>>         
>>>>>>>>>>> download appropriate connector (for all version of MySQL
>>>>>>>>>>>                       
>> db):
>>     
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>>>
>>>>
>>>>         
>>>>>>>>>>> Best regards,
>>>>>>>>>>> Jakub
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>>>>>>>>>> Hi All
>>>>>>>>>>>>
>>>>>>>>>>>> I want to load test my MySql Database. I was reading the
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>> JMeter user
>>>>
>>>>
>>>>         
>>>>>>>>>>>> manual
>>>>>>>>>>>> on how to do this and found the following page on it:
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>     
>>>>         
>>>>>>>>>>>> In the first few lines i found , " This example uses the
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>> MySQL
>>>>
>>>>
>>>>         
>>>>>>>>>>>> database
>>>>>>>>>>>> driver. To use this driver, its containing .jar file
>>>>>>>>>>>>                         
>> must be
>>     
>>>>>>>>>>>>                         
>>>> copied
>>>>
>>>>
>>>>         
>>>>>>>>>>>> to
>>>>>>>>>>>> the
>>>>>>>>>>>> JMeter *lib * directory".
>>>>>>>>>>>>
>>>>>>>>>>>> I dont know what database driver to pick to that JMeter
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>> could contact
>>>>
>>>>
>>>>         
>>>>>>>>>>>> my
>>>>>>>>>>>> Database. I was having the MySql Query tool in my PC
>>>>>>>>>>>>                         
>> Which
>>     
>>>>>>>>>>>>                         
>>>> query's
>>>>
>>>>
>>>>         
>>>>>>>>>>>> the
>>>>>>>>>>>> MySql
>>>>>>>>>>>> DB for the constructed queries. I assume this tool also
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>> needs the
>>>>
>>>>
>>>>         
>>>>>>>>>>>> "MySQL
>>>>>>>>>>>> database driver" , so i searched for the driver in its
>>>>>>>>>>>>                         
>> lib
>>     
>>>>>>>>>>>>                         
>>>> directory
>>>>
>>>>
>>>>         
>>>>>>>>>>>> and
>>>>>>>>>>>> found the following:
>>>>>>>>>>>>
>>>>>>>>>>>> mysql-connector-java-5.0.4-bin.jar
>>>>>>>>>>>>
>>>>>>>>>>>> I am not sure whether this is the same driver that needs
>>>>>>>>>>>>                         
>> to
>>     
>>>>>>>>>>>>                         
>>>> be used
>>>>
>>>>
>>>>         
>>>>>>>>>>>> with
>>>>>>>>>>>> JMeter to connect it to my MySql Database.
>>>>>>>>>>>> Please let me know if i could make use of this driver or
>>>>>>>>>>>>                         
>> i
>>     
>>>>>>>>>>>>                         
>>>> need
>>>>
>>>>
>>>>         
>>>>>>>>>>>> anything
>>>>>>>>>>>> else to load my DB.
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks
>>>>>>>>>>>> Jatin
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>                         
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>                       
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>> For additional commands, e-mail:
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>>> To unsubscribe, e-mail:
>>>>>>>
>>>>>>>
>>>>>>>               
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>> For additional commands, e-mail:
>>>>>>>
>>>>>>>
>>>>>>>               
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>>> To unsubscribe, e-mail:
>>>>>>
>>>>>>
>>>>>>             
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>> For additional commands, e-mail:
>>>>>>
>>>>>>
>>>>>>             
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>>
>>>>>>
>>>>>>             
>>>>>           
>> ---------------------------------------------------------------------
>>     
>>>>         
>>>>> To unsubscribe, e-mail:
>>>>>
>>>>>
>>>>>           
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>> For additional commands, e-mail:
>>>>>
>>>>>
>>>>>           
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>         
>>>>>
>>>>>
>>>>>           
>> ---------------------------------------------------------------------
>>     
>>>>  To unsubscribe, e-mail:
>>>> jmeter-user-unsubscribe@jakarta.apache.org
>>>>  For additional commands, e-mail:
>>>> jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>         
>>>       
>> ---------------------------------------------------------------------
>>     
>>> To unsubscribe, e-mail:
>>>       
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>> For additional commands, e-mail:
>>>       
>> jmeter-user-help@jakarta.apache.org
>>     
>>>
>>>
>>>       
>> ---------------------------------------------------------------------
>>  To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>>  For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>>
>>
>>     
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>   

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

Re: Load Testing the MySql Database

[sebb <se...@gmail.com>]

On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
> Hi
>
>  The leading spaces are being added by mistake as part of sending the mail.
> It is not there when i execute the Tests in JMeter. So this should not be
> the issue.
>  Secondly as you said i verified with WinRar to ascertain whether there is a
> class named as "Driver" in the com/mysql/jdbc  directory structure , it is
> available.

And the jar is definitely in the lib directory?

Then all I can think of is maybe the jar requires Java 1.5 or 1.6; try
running JMeter with a later version of Java.

>  Thanks
>  Jatin
>
>
>  sebb wrote:
>
> > On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
> >
> >
> > > Hi
> > >
> > >  I did put the string " com.mysql.jdbc.Driver" in the field JDBC Driver
> > >
> > >
> >
> > If there really is a leading space in the field then it won't work.
> >
> > Also, check that the class is present in the jar file (you can open a
> > jar file with an application that opens zip files).
> >
> >
> >
> > > class in the JDBC connection configuration.
> > >
> > >  I am using JMeter 2.3.4
> > >
> > >
> > >  Thanks
> > >  Jatin
> > >
> > >  Jakub Bia?ek wrote:
> > >
> > >
> > >
> > > > It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
> > > > Driver class in JDBC Connection Configuration, if this still doesn't
> > > > work send my your test plan.
> > > >
> > > > BTW. Which version of jmeter do you use?
> > > >
> > > > Best regards,
> > > > Jakub
> > > >
> > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > >
> > > >
> > > >
> > > >
> > > > > Yes , JMeter was re-started after copying the .Jar file.
> > > > > Still i am seeing the same error.
> > > > >
> > > > > Thanks
> > > > > Jatin
> > > > >
> > > > > Jakub Bia?ek wrote:
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > > Do you restart jmeter after you copy
> > > > > > mysql-connector-java-5.0.4-bin.jar to lib
> directory?
> > > > > >
> > > > > > Jakub
> > > > > >
> > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > > I copied the
> > > > > > >
> > > > > > > mysql-connector-java-5.0.4-bin.jar into
> JMeter's
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > lib directory as it was
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > > working fine with the MySql Query browser with my DB. But when i
> run
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > it
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > > with
> > > > > > > JMeter i got the following error message in the listeners's
> Tree:
> > > > > > >
> > > > > > > Response message: java.sql.SQLException: No suitable driver
> found
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > for
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > > jdbc:mysql://172.20.106.119:3309/ciscomd
> > > > > > >
> > > > > > > I am trying to connect to a data base remotely. Adding one more
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > point ,
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > > this
> > > > > > > is what i used as the JDBC Driver class: com.mysql.jdbc.Driver
> in
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > the
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > > JDBC
> > > > > > > connection configuration.
> > > > > > >
> > > > > > > Please let me know if i am missing something.
> > > > > > >
> > > > > > >
> > > > > > > Thanks
> > > > > > > Jatin
> > > > > > >
> > > > > > >
> > > > > > > Jakub Bia?ek wrote:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > > You only have to copy this jar to jmeter lib directory,
> remember
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > to
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > > use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL
> 5.0.x,
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > don't
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > > mix them!
> > > > > > > > Then you need to configure connection and sampler:
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > > Best regards,
> > > > > > > > Jakub
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > > I downloaded the driver from the location mentioned below.
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > Should i
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > copy
> > > > > > > > > only the .Jar file into JMeter's lib directory or anything
> else
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > is also
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > required.
> > > > > > > > > Please let me know.
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > > Jatin
> > > > > > > > >
> > > > > > > > > Jakub Bia?ek wrote:
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > > Hi!
> > > > > > > > > >
> > > > > > > > > > Yes, you can use this driver, it's a bit old but if you
> use
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > MySQL
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > 5.0.x it should work fine.
> > > > > > > > > > For MySQL 5.1.x you need another driver, here is place
> where
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > you can
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > download appropriate connector (for all version of MySQL
> db):
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > http://dev.mysql.com/downloads/connector/j/5.1.html
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > Best regards,
> > > > > > > > > > Jakub
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > Hi All
> > > > > > > > > > >
> > > > > > > > > > > I want to load test my MySql Database. I was reading the
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > JMeter user
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > manual
> > > > > > > > > > > on how to do this and found the following page on it:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > In the first few lines i found , " This example uses the
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > MySQL
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > database
> > > > > > > > > > > driver. To use this driver, its containing .jar file
> must be
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > copied
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > to
> > > > > > > > > > > the
> > > > > > > > > > > JMeter *lib * directory".
> > > > > > > > > > >
> > > > > > > > > > > I dont know what database driver to pick to that JMeter
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > could contact
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > my
> > > > > > > > > > > Database. I was having the MySql Query tool in my PC
> Which
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > query's
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > the
> > > > > > > > > > > MySql
> > > > > > > > > > > DB for the constructed queries. I assume this tool also
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > needs the
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > "MySQL
> > > > > > > > > > > database driver" , so i searched for the driver in its
> lib
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > directory
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > and
> > > > > > > > > > > found the following:
> > > > > > > > > > >
> > > > > > > > > > > mysql-connector-java-5.0.4-bin.jar
> > > > > > > > > > >
> > > > > > > > > > > I am not sure whether this is the same driver that needs
> to
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > be used
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > with
> > > > > > > > > > > JMeter to connect it to my MySql Database.
> > > > > > > > > > > Please let me know if i could make use of this driver or
> i
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > need
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > anything
> > > > > > > > > > > else to load my DB.
> > > > > > > > > > >
> > > > > > > > > > > Thanks
> > > > > > > > > > > Jatin
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > For additional commands, e-mail:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > > For additional commands, e-mail:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > To unsubscribe, e-mail:
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > > For additional commands, e-mail:
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > > To unsubscribe, e-mail:
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > > For additional commands, e-mail:
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > > To unsubscribe, e-mail:
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > > For additional commands, e-mail:
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > >
> > > > > > To unsubscribe, e-mail:
> > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > > For additional commands, e-mail:
> > > > > >
> > > > > >
> > > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > >
> > > > > To unsubscribe, e-mail:
> > > > >
> > > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > >
> > > > > For additional commands, e-mail:
> > > > >
> > > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >
> > >
> > > > To unsubscribe, e-mail:
> > > >
> > > >
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >
> > >
> > > > For additional commands, e-mail:
> > > >
> > > >
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > > >
> > > >
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > >  To unsubscribe, e-mail:
> > > jmeter-user-unsubscribe@jakarta.apache.org
> > >  For additional commands, e-mail:
> > > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > >
> > >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> >
> >
> >
> >
>
> ---------------------------------------------------------------------
>  To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
>  For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
>
>

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

Re: Load Testing the MySql Database

[Jatin Davey <ja...@cisco.com>]

Hi

The leading spaces are being added by mistake as part of sending the 
mail. It is not there when i execute the Tests in JMeter. So this should 
not be the issue.
Secondly as you said i verified with WinRar to ascertain whether there 
is a class named as "Driver" in the com/mysql/jdbc  directory structure 
, it is available.

Thanks
Jatin

sebb wrote:
> On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
>   
>> Hi
>>
>>  I did put the string " com.mysql.jdbc.Driver" in the field JDBC Driver
>>     
>
> If there really is a leading space in the field then it won't work.
>
> Also, check that the class is present in the jar file (you can open a
> jar file with an application that opens zip files).
>
>   
>> class in the JDBC connection configuration.
>>
>>  I am using JMeter 2.3.4
>>
>>
>>  Thanks
>>  Jatin
>>
>>  Jakub Bia?ek wrote:
>>
>>     
>>> It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
>>> Driver class in JDBC Connection Configuration, if this still doesn't
>>> work send my your test plan.
>>>
>>> BTW. Which version of jmeter do you use?
>>>
>>> Best regards,
>>> Jakub
>>>
>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>
>>>
>>>       
>>>> Yes , JMeter was re-started after copying the .Jar file.
>>>> Still i am seeing the same error.
>>>>
>>>> Thanks
>>>> Jatin
>>>>
>>>> Jakub Bia?ek wrote:
>>>>
>>>>
>>>>         
>>>>> Do you restart jmeter after you copy
>>>>> mysql-connector-java-5.0.4-bin.jar to lib directory?
>>>>>
>>>>> Jakub
>>>>>
>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>
>>>>>
>>>>>
>>>>>           
>>>>>> I copied the
>>>>>>
>>>>>> mysql-connector-java-5.0.4-bin.jar into JMeter's
>>>>>>             
>> lib directory as it was
>>     
>>>>>> working fine with the MySql Query browser with my DB. But when i run
>>>>>>             
>> it
>>     
>>>>>> with
>>>>>> JMeter i got the following error message in the listeners's Tree:
>>>>>>
>>>>>> Response message: java.sql.SQLException: No suitable driver found
>>>>>>             
>> for
>>     
>>>>>> jdbc:mysql://172.20.106.119:3309/ciscomd
>>>>>>
>>>>>> I am trying to connect to a data base remotely. Adding one more
>>>>>>             
>> point ,
>>     
>>>>>> this
>>>>>> is what i used as the JDBC Driver class: com.mysql.jdbc.Driver in
>>>>>>             
>> the
>>     
>>>>>> JDBC
>>>>>> connection configuration.
>>>>>>
>>>>>> Please let me know if i am missing something.
>>>>>>
>>>>>>
>>>>>> Thanks
>>>>>> Jatin
>>>>>>
>>>>>>
>>>>>> Jakub Bia?ek wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>> You only have to copy this jar to jmeter lib directory, remember
>>>>>>>               
>> to
>>     
>>>>>>> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x,
>>>>>>>               
>> don't
>>     
>>>>>>> mix them!
>>>>>>> Then you need to configure connection and sampler:
>>>>>>>
>>>>>>>               
>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>     
>>>>>>> Best regards,
>>>>>>> Jakub
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>>>> I downloaded the driver from the location mentioned below.
>>>>>>>>                 
>> Should i
>>     
>>>>>>>> copy
>>>>>>>> only the .Jar file into JMeter's lib directory or anything else
>>>>>>>>                 
>> is also
>>     
>>>>>>>> required.
>>>>>>>> Please let me know.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Jatin
>>>>>>>>
>>>>>>>> Jakub Bia?ek wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>>>>>>> Hi!
>>>>>>>>>
>>>>>>>>> Yes, you can use this driver, it's a bit old but if you use
>>>>>>>>>                   
>> MySQL
>>     
>>>>>>>>> 5.0.x it should work fine.
>>>>>>>>> For MySQL 5.1.x you need another driver, here is place where
>>>>>>>>>                   
>> you can
>>     
>>>>>>>>> download appropriate connector (for all version of MySQL db):
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>     
>>>>>>>>> Best regards,
>>>>>>>>> Jakub
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>>>>>>>>>> Hi All
>>>>>>>>>>
>>>>>>>>>> I want to load test my MySql Database. I was reading the
>>>>>>>>>>                     
>> JMeter user
>>     
>>>>>>>>>> manual
>>>>>>>>>> on how to do this and found the following page on it:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>     
>>>>>>>>>> In the first few lines i found , " This example uses the
>>>>>>>>>>                     
>> MySQL
>>     
>>>>>>>>>> database
>>>>>>>>>> driver. To use this driver, its containing .jar file must be
>>>>>>>>>>                     
>> copied
>>     
>>>>>>>>>> to
>>>>>>>>>> the
>>>>>>>>>> JMeter *lib * directory".
>>>>>>>>>>
>>>>>>>>>> I dont know what database driver to pick to that JMeter
>>>>>>>>>>                     
>> could contact
>>     
>>>>>>>>>> my
>>>>>>>>>> Database. I was having the MySql Query tool in my PC Which
>>>>>>>>>>                     
>> query's
>>     
>>>>>>>>>> the
>>>>>>>>>> MySql
>>>>>>>>>> DB for the constructed queries. I assume this tool also
>>>>>>>>>>                     
>> needs the
>>     
>>>>>>>>>> "MySQL
>>>>>>>>>> database driver" , so i searched for the driver in its lib
>>>>>>>>>>                     
>> directory
>>     
>>>>>>>>>> and
>>>>>>>>>> found the following:
>>>>>>>>>>
>>>>>>>>>> mysql-connector-java-5.0.4-bin.jar
>>>>>>>>>>
>>>>>>>>>> I am not sure whether this is the same driver that needs to
>>>>>>>>>>                     
>> be used
>>     
>>>>>>>>>> with
>>>>>>>>>> JMeter to connect it to my MySql Database.
>>>>>>>>>> Please let me know if i could make use of this driver or i
>>>>>>>>>>                     
>> need
>>     
>>>>>>>>>> anything
>>>>>>>>>> else to load my DB.
>>>>>>>>>>
>>>>>>>>>> Thanks
>>>>>>>>>> Jatin
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>> ---------------------------------------------------------------------
>>     
>>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>>                     
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>>                     
>> jmeter-user-help@jakarta.apache.org
>>     
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>                     
>> ---------------------------------------------------------------------
>>     
>>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>>                   
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>>>>>>>> For additional commands, e-mail:
>>>>>>>>>                   
>> jmeter-user-help@jakarta.apache.org
>>     
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>                   
>> ---------------------------------------------------------------------
>>     
>>>>>>>> To unsubscribe, e-mail:
>>>>>>>>                 
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>>>>>>> For additional commands, e-mail:
>>>>>>>>                 
>> jmeter-user-help@jakarta.apache.org
>>     
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>> ---------------------------------------------------------------------
>>     
>>>>>>> To unsubscribe, e-mail:
>>>>>>>               
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>>>>>> For additional commands, e-mail:
>>>>>>>               
>> jmeter-user-help@jakarta.apache.org
>>     
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>> ---------------------------------------------------------------------
>>     
>>>>>> To unsubscribe, e-mail:
>>>>>>             
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>>>>> For additional commands, e-mail:
>>>>>>             
>> jmeter-user-help@jakarta.apache.org
>>     
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>> ---------------------------------------------------------------------
>>     
>>>>> To unsubscribe, e-mail:
>>>>>           
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>>>> For additional commands, e-mail:
>>>>>           
>> jmeter-user-help@jakarta.apache.org
>>     
>>>>>
>>>>>
>>>>>
>>>>>           
>> ---------------------------------------------------------------------
>>     
>>>> To unsubscribe, e-mail:
>>>>         
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>>> For additional commands, e-mail:
>>>>         
>> jmeter-user-help@jakarta.apache.org
>>     
>>>>
>>>>
>>>>         
>>>       
>> ---------------------------------------------------------------------
>>     
>>> To unsubscribe, e-mail:
>>>       
>> jmeter-user-unsubscribe@jakarta.apache.org
>>     
>>> For additional commands, e-mail:
>>>       
>> jmeter-user-help@jakarta.apache.org
>>     
>>>
>>>
>>>       
>> ---------------------------------------------------------------------
>>  To unsubscribe, e-mail:
>> jmeter-user-unsubscribe@jakarta.apache.org
>>  For additional commands, e-mail:
>> jmeter-user-help@jakarta.apache.org
>>
>>
>>     
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>   

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

Re: Load Testing the MySql Database

[sebb <se...@gmail.com>]

On 28/09/2009, Jatin Davey <ja...@cisco.com> wrote:
> Hi
>
>  I did put the string " com.mysql.jdbc.Driver" in the field JDBC Driver

If there really is a leading space in the field then it won't work.

Also, check that the class is present in the jar file (you can open a
jar file with an application that opens zip files).

> class in the JDBC connection configuration.
>
>  I am using JMeter 2.3.4
>
>
>  Thanks
>  Jatin
>
>  Jakub Bia?ek wrote:
>
> > It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
> > Driver class in JDBC Connection Configuration, if this still doesn't
> > work send my your test plan.
> >
> > BTW. Which version of jmeter do you use?
> >
> > Best regards,
> > Jakub
> >
> > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> >
> >
> > > Yes , JMeter was re-started after copying the .Jar file.
> > > Still i am seeing the same error.
> > >
> > > Thanks
> > > Jatin
> > >
> > > Jakub Bia?ek wrote:
> > >
> > >
> > > > Do you restart jmeter after you copy
> > > > mysql-connector-java-5.0.4-bin.jar to lib directory?
> > > >
> > > > Jakub
> > > >
> > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > >
> > > >
> > > >
> > > > > I copied the
> > > > >
> > > > > mysql-connector-java-5.0.4-bin.jar into JMeter's
> lib directory as it was
> > > > > working fine with the MySql Query browser with my DB. But when i run
> it
> > > > > with
> > > > > JMeter i got the following error message in the listeners's Tree:
> > > > >
> > > > > Response message: java.sql.SQLException: No suitable driver found
> for
> > > > > jdbc:mysql://172.20.106.119:3309/ciscomd
> > > > >
> > > > > I am trying to connect to a data base remotely. Adding one more
> point ,
> > > > > this
> > > > > is what i used as the JDBC Driver class: com.mysql.jdbc.Driver in
> the
> > > > > JDBC
> > > > > connection configuration.
> > > > >
> > > > > Please let me know if i am missing something.
> > > > >
> > > > >
> > > > > Thanks
> > > > > Jatin
> > > > >
> > > > >
> > > > > Jakub Bia?ek wrote:
> > > > >
> > > > >
> > > > >
> > > > > > You only have to copy this jar to jmeter lib directory, remember
> to
> > > > > > use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x,
> don't
> > > > > > mix them!
> > > > > > Then you need to configure connection and sampler:
> > > > > >
> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
> > > > > >
> > > > > > Best regards,
> > > > > > Jakub
> > > > > >
> > > > > >
> > > > > >
> > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > > I downloaded the driver from the location mentioned below.
> Should i
> > > > > > > copy
> > > > > > > only the .Jar file into JMeter's lib directory or anything else
> is also
> > > > > > > required.
> > > > > > > Please let me know.
> > > > > > >
> > > > > > > Thanks
> > > > > > > Jatin
> > > > > > >
> > > > > > > Jakub Bia?ek wrote:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > > Hi!
> > > > > > > >
> > > > > > > > Yes, you can use this driver, it's a bit old but if you use
> MySQL
> > > > > > > > 5.0.x it should work fine.
> > > > > > > > For MySQL 5.1.x you need another driver, here is place where
> you can
> > > > > > > > download appropriate connector (for all version of MySQL db):
> > > > > > > >
> > > > > > > >
> http://dev.mysql.com/downloads/connector/j/5.1.html
> > > > > > > >
> > > > > > > > Best regards,
> > > > > > > > Jakub
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > 2009/9/28 Jatin Davey <ja...@cisco.com>:
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > > Hi All
> > > > > > > > >
> > > > > > > > > I want to load test my MySql Database. I was reading the
> JMeter user
> > > > > > > > > manual
> > > > > > > > > on how to do this and found the following page on it:
> > > > > > > > >
> > > > > > > > >
> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
> > > > > > > > >
> > > > > > > > > In the first few lines i found , " This example uses the
> MySQL
> > > > > > > > > database
> > > > > > > > > driver. To use this driver, its containing .jar file must be
> copied
> > > > > > > > > to
> > > > > > > > > the
> > > > > > > > > JMeter *lib * directory".
> > > > > > > > >
> > > > > > > > > I dont know what database driver to pick to that JMeter
> could contact
> > > > > > > > > my
> > > > > > > > > Database. I was having the MySql Query tool in my PC Which
> query's
> > > > > > > > > the
> > > > > > > > > MySql
> > > > > > > > > DB for the constructed queries. I assume this tool also
> needs the
> > > > > > > > > "MySQL
> > > > > > > > > database driver" , so i searched for the driver in its lib
> directory
> > > > > > > > > and
> > > > > > > > > found the following:
> > > > > > > > >
> > > > > > > > > mysql-connector-java-5.0.4-bin.jar
> > > > > > > > >
> > > > > > > > > I am not sure whether this is the same driver that needs to
> be used
> > > > > > > > > with
> > > > > > > > > JMeter to connect it to my MySql Database.
> > > > > > > > > Please let me know if i could make use of this driver or i
> need
> > > > > > > > > anything
> > > > > > > > > else to load my DB.
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > > Jatin
> > > > > > > > >
> > > > > > > > >
> ---------------------------------------------------------------------
> > > > > > > > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > > > > > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> ---------------------------------------------------------------------
> > > > > > > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > > > > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> ---------------------------------------------------------------------
> > > > > > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > > > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> ---------------------------------------------------------------------
> > > > > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > >
> > >
> > >
> > >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> >
> >
> >
> >
>
> ---------------------------------------------------------------------
>  To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
>  For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
>
>

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

Re: Load Testing the MySql Database

[Jatin Davey <ja...@cisco.com>]

Hi

I did put the string " com.mysql.jdbc.Driver" in the field JDBC Driver 
class in the JDBC connection configuration.

I am using JMeter 2.3.4

Thanks
Jatin

Jakub Bia?ek wrote:
> It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
> Driver class in JDBC Connection Configuration, if this still doesn't
> work send my your test plan.
>
> BTW. Which version of jmeter do you use?
>
> Best regards,
> Jakub
>
> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>   
>> Yes , JMeter was re-started after copying the .Jar file.
>> Still i am seeing the same error.
>>
>> Thanks
>> Jatin
>>
>> Jakub Bia?ek wrote:
>>     
>>> Do you restart jmeter after you copy
>>> mysql-connector-java-5.0.4-bin.jar to lib directory?
>>>
>>> Jakub
>>>
>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>
>>>       
>>>> I copied the
>>>>
>>>> mysql-connector-java-5.0.4-bin.jar into JMeter's lib directory as it was
>>>> working fine with the MySql Query browser with my DB. But when i run it
>>>> with
>>>> JMeter i got the following error message in the listeners's Tree:
>>>>
>>>> Response message: java.sql.SQLException: No suitable driver found for
>>>> jdbc:mysql://172.20.106.119:3309/ciscomd
>>>>
>>>> I am trying to connect to a data base remotely. Adding one more point ,
>>>> this
>>>> is what i used as the JDBC Driver class: com.mysql.jdbc.Driver in the
>>>> JDBC
>>>> connection configuration.
>>>>
>>>> Please let me know if i am missing something.
>>>>
>>>>
>>>> Thanks
>>>> Jatin
>>>>
>>>>
>>>> Jakub Bia?ek wrote:
>>>>
>>>>         
>>>>> You only have to copy this jar to jmeter lib directory, remember to
>>>>> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x, don't
>>>>> mix them!
>>>>> Then you need to configure connection and sampler:
>>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>>
>>>>> Best regards,
>>>>> Jakub
>>>>>
>>>>>
>>>>>
>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>
>>>>>
>>>>>           
>>>>>> I downloaded the driver from the location mentioned below. Should i
>>>>>> copy
>>>>>> only the .Jar file into JMeter's lib directory or anything else is also
>>>>>> required.
>>>>>> Please let me know.
>>>>>>
>>>>>> Thanks
>>>>>> Jatin
>>>>>>
>>>>>> Jakub Bia?ek wrote:
>>>>>>
>>>>>>
>>>>>>             
>>>>>>> Hi!
>>>>>>>
>>>>>>> Yes, you can use this driver, it's a bit old but if you use MySQL
>>>>>>> 5.0.x it should work fine.
>>>>>>> For MySQL 5.1.x you need another driver, here is place where you can
>>>>>>> download appropriate connector (for all version of MySQL db):
>>>>>>>
>>>>>>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>>>>>>
>>>>>>> Best regards,
>>>>>>> Jakub
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>>>> Hi All
>>>>>>>>
>>>>>>>> I want to load test my MySql Database. I was reading the JMeter user
>>>>>>>> manual
>>>>>>>> on how to do this and found the following page on it:
>>>>>>>>
>>>>>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>>>>>
>>>>>>>> In the first few lines i found , " This example uses the MySQL
>>>>>>>> database
>>>>>>>> driver. To use this driver, its containing .jar file must be copied
>>>>>>>> to
>>>>>>>> the
>>>>>>>> JMeter *lib * directory".
>>>>>>>>
>>>>>>>> I dont know what database driver to pick to that JMeter could contact
>>>>>>>> my
>>>>>>>> Database. I was having the MySql Query tool in my PC Which query's
>>>>>>>> the
>>>>>>>> MySql
>>>>>>>> DB for the constructed queries. I assume this tool also needs the
>>>>>>>> "MySQL
>>>>>>>> database driver" , so i searched for the driver in its lib directory
>>>>>>>> and
>>>>>>>> found the following:
>>>>>>>>
>>>>>>>> mysql-connector-java-5.0.4-bin.jar
>>>>>>>>
>>>>>>>> I am not sure whether this is the same driver that needs to be used
>>>>>>>> with
>>>>>>>> JMeter to connect it to my MySql Database.
>>>>>>>> Please let me know if i could make use of this driver or i need
>>>>>>>> anything
>>>>>>>> else to load my DB.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Jatin
>>>>>>>>
>>>>>>>> ---------------------------------------------------------------------
>>>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>                 
>>>>>>> ---------------------------------------------------------------------
>>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>> ---------------------------------------------------------------------
>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>           
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>         
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>>
>>>       
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>     
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>   

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

Re: Load Testing the MySql Database

[Jakub Białek <ra...@gmail.com>]

It looks like you didn't put com.mysql.jdbc.Driver in field JDBC
Driver class in JDBC Connection Configuration, if this still doesn't
work send my your test plan.

BTW. Which version of jmeter do you use?

Best regards,
Jakub

2009/9/28 Jatin Davey <ja...@cisco.com>:
> Yes , JMeter was re-started after copying the .Jar file.
> Still i am seeing the same error.
>
> Thanks
> Jatin
>
> Jakub Bia?ek wrote:
>>
>> Do you restart jmeter after you copy
>> mysql-connector-java-5.0.4-bin.jar to lib directory?
>>
>> Jakub
>>
>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>
>>>
>>> I copied the
>>>
>>> mysql-connector-java-5.0.4-bin.jar into JMeter's lib directory as it was
>>> working fine with the MySql Query browser with my DB. But when i run it
>>> with
>>> JMeter i got the following error message in the listeners's Tree:
>>>
>>> Response message: java.sql.SQLException: No suitable driver found for
>>> jdbc:mysql://172.20.106.119:3309/ciscomd
>>>
>>> I am trying to connect to a data base remotely. Adding one more point ,
>>> this
>>> is what i used as the JDBC Driver class: com.mysql.jdbc.Driver in the
>>> JDBC
>>> connection configuration.
>>>
>>> Please let me know if i am missing something.
>>>
>>>
>>> Thanks
>>> Jatin
>>>
>>>
>>> Jakub Bia?ek wrote:
>>>
>>>>
>>>> You only have to copy this jar to jmeter lib directory, remember to
>>>> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x, don't
>>>> mix them!
>>>> Then you need to configure connection and sampler:
>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>
>>>> Best regards,
>>>> Jakub
>>>>
>>>>
>>>>
>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>
>>>>
>>>>>
>>>>> I downloaded the driver from the location mentioned below. Should i
>>>>> copy
>>>>> only the .Jar file into JMeter's lib directory or anything else is also
>>>>> required.
>>>>> Please let me know.
>>>>>
>>>>> Thanks
>>>>> Jatin
>>>>>
>>>>> Jakub Bia?ek wrote:
>>>>>
>>>>>
>>>>>>
>>>>>> Hi!
>>>>>>
>>>>>> Yes, you can use this driver, it's a bit old but if you use MySQL
>>>>>> 5.0.x it should work fine.
>>>>>> For MySQL 5.1.x you need another driver, here is place where you can
>>>>>> download appropriate connector (for all version of MySQL db):
>>>>>>
>>>>>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>>>>>
>>>>>> Best regards,
>>>>>> Jakub
>>>>>>
>>>>>>
>>>>>>
>>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>>
>>>>>>
>>>>>>
>>>>>>>
>>>>>>> Hi All
>>>>>>>
>>>>>>> I want to load test my MySql Database. I was reading the JMeter user
>>>>>>> manual
>>>>>>> on how to do this and found the following page on it:
>>>>>>>
>>>>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>>>>
>>>>>>> In the first few lines i found , " This example uses the MySQL
>>>>>>> database
>>>>>>> driver. To use this driver, its containing .jar file must be copied
>>>>>>> to
>>>>>>> the
>>>>>>> JMeter *lib * directory".
>>>>>>>
>>>>>>> I dont know what database driver to pick to that JMeter could contact
>>>>>>> my
>>>>>>> Database. I was having the MySql Query tool in my PC Which query's
>>>>>>> the
>>>>>>> MySql
>>>>>>> DB for the constructed queries. I assume this tool also needs the
>>>>>>> "MySQL
>>>>>>> database driver" , so i searched for the driver in its lib directory
>>>>>>> and
>>>>>>> found the following:
>>>>>>>
>>>>>>> mysql-connector-java-5.0.4-bin.jar
>>>>>>>
>>>>>>> I am not sure whether this is the same driver that needs to be used
>>>>>>> with
>>>>>>> JMeter to connect it to my MySql Database.
>>>>>>> Please let me know if i could make use of this driver or i need
>>>>>>> anything
>>>>>>> else to load my DB.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Jatin
>>>>>>>
>>>>>>> ---------------------------------------------------------------------
>>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

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

Re: Load Testing the MySql Database

[Jatin Davey <ja...@cisco.com>]

Yes , JMeter was re-started after copying the .Jar file.
Still i am seeing the same error.

Thanks
Jatin

Jakub Bia?ek wrote:
> Do you restart jmeter after you copy
> mysql-connector-java-5.0.4-bin.jar to lib directory?
>
> Jakub
>
> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>   
>> I copied the
>>
>> mysql-connector-java-5.0.4-bin.jar into JMeter's lib directory as it was
>> working fine with the MySql Query browser with my DB. But when i run it with
>> JMeter i got the following error message in the listeners's Tree:
>>
>> Response message: java.sql.SQLException: No suitable driver found for
>> jdbc:mysql://172.20.106.119:3309/ciscomd
>>
>> I am trying to connect to a data base remotely. Adding one more point , this
>> is what i used as the JDBC Driver class: com.mysql.jdbc.Driver in the JDBC
>> connection configuration.
>>
>> Please let me know if i am missing something.
>>
>>
>> Thanks
>> Jatin
>>
>>
>> Jakub Bia?ek wrote:
>>     
>>> You only have to copy this jar to jmeter lib directory, remember to
>>> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x, don't
>>> mix them!
>>> Then you need to configure connection and sampler:
>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>
>>> Best regards,
>>> Jakub
>>>
>>>
>>>
>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>
>>>       
>>>> I downloaded the driver from the location mentioned below. Should i copy
>>>> only the .Jar file into JMeter's lib directory or anything else is also
>>>> required.
>>>> Please let me know.
>>>>
>>>> Thanks
>>>> Jatin
>>>>
>>>> Jakub Bia?ek wrote:
>>>>
>>>>         
>>>>> Hi!
>>>>>
>>>>> Yes, you can use this driver, it's a bit old but if you use MySQL
>>>>> 5.0.x it should work fine.
>>>>> For MySQL 5.1.x you need another driver, here is place where you can
>>>>> download appropriate connector (for all version of MySQL db):
>>>>>
>>>>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>>>>
>>>>> Best regards,
>>>>> Jakub
>>>>>
>>>>>
>>>>>
>>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>>
>>>>>
>>>>>           
>>>>>> Hi All
>>>>>>
>>>>>> I want to load test my MySql Database. I was reading the JMeter user
>>>>>> manual
>>>>>> on how to do this and found the following page on it:
>>>>>>
>>>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>>>
>>>>>> In the first few lines i found , " This example uses the MySQL database
>>>>>> driver. To use this driver, its containing .jar file must be copied to
>>>>>> the
>>>>>> JMeter *lib * directory".
>>>>>>
>>>>>> I dont know what database driver to pick to that JMeter could contact
>>>>>> my
>>>>>> Database. I was having the MySql Query tool in my PC Which query's the
>>>>>> MySql
>>>>>> DB for the constructed queries. I assume this tool also needs the
>>>>>> "MySQL
>>>>>> database driver" , so i searched for the driver in its lib directory
>>>>>> and
>>>>>> found the following:
>>>>>>
>>>>>> mysql-connector-java-5.0.4-bin.jar
>>>>>>
>>>>>> I am not sure whether this is the same driver that needs to be used
>>>>>> with
>>>>>> JMeter to connect it to my MySql Database.
>>>>>> Please let me know if i could make use of this driver or i need
>>>>>> anything
>>>>>> else to load my DB.
>>>>>>
>>>>>> Thanks
>>>>>> Jatin
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>           
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>         
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>>
>>>       
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>     
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>   

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

Re: Load Testing the MySql Database

[Jakub Białek <ra...@gmail.com>]

Do you restart jmeter after you copy
mysql-connector-java-5.0.4-bin.jar to lib directory?

Jakub

2009/9/28 Jatin Davey <ja...@cisco.com>:
> I copied the
>
> mysql-connector-java-5.0.4-bin.jar into JMeter's lib directory as it was
> working fine with the MySql Query browser with my DB. But when i run it with
> JMeter i got the following error message in the listeners's Tree:
>
> Response message: java.sql.SQLException: No suitable driver found for
> jdbc:mysql://172.20.106.119:3309/ciscomd
>
> I am trying to connect to a data base remotely. Adding one more point , this
> is what i used as the JDBC Driver class: com.mysql.jdbc.Driver in the JDBC
> connection configuration.
>
> Please let me know if i am missing something.
>
>
> Thanks
> Jatin
>
>
> Jakub Bia?ek wrote:
>>
>> You only have to copy this jar to jmeter lib directory, remember to
>> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x, don't
>> mix them!
>> Then you need to configure connection and sampler:
>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>
>> Best regards,
>> Jakub
>>
>>
>>
>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>
>>>
>>> I downloaded the driver from the location mentioned below. Should i copy
>>> only the .Jar file into JMeter's lib directory or anything else is also
>>> required.
>>> Please let me know.
>>>
>>> Thanks
>>> Jatin
>>>
>>> Jakub Bia?ek wrote:
>>>
>>>>
>>>> Hi!
>>>>
>>>> Yes, you can use this driver, it's a bit old but if you use MySQL
>>>> 5.0.x it should work fine.
>>>> For MySQL 5.1.x you need another driver, here is place where you can
>>>> download appropriate connector (for all version of MySQL db):
>>>>
>>>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>>>
>>>> Best regards,
>>>> Jakub
>>>>
>>>>
>>>>
>>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>>
>>>>
>>>>>
>>>>> Hi All
>>>>>
>>>>> I want to load test my MySql Database. I was reading the JMeter user
>>>>> manual
>>>>> on how to do this and found the following page on it:
>>>>>
>>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>>
>>>>> In the first few lines i found , " This example uses the MySQL database
>>>>> driver. To use this driver, its containing .jar file must be copied to
>>>>> the
>>>>> JMeter *lib * directory".
>>>>>
>>>>> I dont know what database driver to pick to that JMeter could contact
>>>>> my
>>>>> Database. I was having the MySql Query tool in my PC Which query's the
>>>>> MySql
>>>>> DB for the constructed queries. I assume this tool also needs the
>>>>> "MySQL
>>>>> database driver" , so i searched for the driver in its lib directory
>>>>> and
>>>>> found the following:
>>>>>
>>>>> mysql-connector-java-5.0.4-bin.jar
>>>>>
>>>>> I am not sure whether this is the same driver that needs to be used
>>>>> with
>>>>> JMeter to connect it to my MySql Database.
>>>>> Please let me know if i could make use of this driver or i need
>>>>> anything
>>>>> else to load my DB.
>>>>>
>>>>> Thanks
>>>>> Jatin
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

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

Re: Load Testing the MySql Database

[Jatin Davey <ja...@cisco.com>]

I copied the

mysql-connector-java-5.0.4-bin.jar into JMeter's lib directory as it was working fine with the MySql Query browser with my DB. But when i run it with JMeter i got the following error message in the listeners's Tree:

Response message: java.sql.SQLException: No suitable driver found for jdbc:mysql://172.20.106.119:3309/ciscomd

I am trying to connect to a data base remotely. Adding one more point , this is what i used as the JDBC Driver class: com.mysql.jdbc.Driver in the JDBC connection configuration.

Please let me know if i am missing something.


Thanks
Jatin


Jakub Bia?ek wrote:
> You only have to copy this jar to jmeter lib directory, remember to
> use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x, don't
> mix them!
> Then you need to configure connection and sampler:
> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>
> Best regards,
> Jakub
>
>
>
> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>   
>> I downloaded the driver from the location mentioned below. Should i copy
>> only the .Jar file into JMeter's lib directory or anything else is also
>> required.
>> Please let me know.
>>
>> Thanks
>> Jatin
>>
>> Jakub Bia?ek wrote:
>>     
>>> Hi!
>>>
>>> Yes, you can use this driver, it's a bit old but if you use MySQL
>>> 5.0.x it should work fine.
>>> For MySQL 5.1.x you need another driver, here is place where you can
>>> download appropriate connector (for all version of MySQL db):
>>>
>>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>>
>>> Best regards,
>>> Jakub
>>>
>>>
>>>
>>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>>
>>>       
>>>> Hi All
>>>>
>>>> I want to load test my MySql Database. I was reading the JMeter user
>>>> manual
>>>> on how to do this and found the following page on it:
>>>>
>>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>>
>>>> In the first few lines i found , " This example uses the MySQL database
>>>> driver. To use this driver, its containing .jar file must be copied to
>>>> the
>>>> JMeter *lib * directory".
>>>>
>>>> I dont know what database driver to pick to that JMeter could contact my
>>>> Database. I was having the MySql Query tool in my PC Which query's the
>>>> MySql
>>>> DB for the constructed queries. I assume this tool also needs the "MySQL
>>>> database driver" , so i searched for the driver in its lib directory and
>>>> found the following:
>>>>
>>>> mysql-connector-java-5.0.4-bin.jar
>>>>
>>>> I am not sure whether this is the same driver that needs to be used with
>>>> JMeter to connect it to my MySql Database.
>>>> Please let me know if i could make use of this driver or i need anything
>>>> else to load my DB.
>>>>
>>>> Thanks
>>>> Jatin
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>         
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>>
>>>       
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>     
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>   

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

Re: Load Testing the MySql Database

[Jakub Białek <ra...@gmail.com>]

You only have to copy this jar to jmeter lib directory, remember to
use connector 5.1.10 for MySQL 5.1.x and 5.0.8 for MySQL 5.0.x, don't
mix them!
Then you need to configure connection and sampler:
http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html

Best regards,
Jakub



2009/9/28 Jatin Davey <ja...@cisco.com>:
> I downloaded the driver from the location mentioned below. Should i copy
> only the .Jar file into JMeter's lib directory or anything else is also
> required.
> Please let me know.
>
> Thanks
> Jatin
>
> Jakub Bia?ek wrote:
>>
>> Hi!
>>
>> Yes, you can use this driver, it's a bit old but if you use MySQL
>> 5.0.x it should work fine.
>> For MySQL 5.1.x you need another driver, here is place where you can
>> download appropriate connector (for all version of MySQL db):
>>
>> http://dev.mysql.com/downloads/connector/j/5.1.html
>>
>> Best regards,
>> Jakub
>>
>>
>>
>> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>>
>>>
>>> Hi All
>>>
>>> I want to load test my MySql Database. I was reading the JMeter user
>>> manual
>>> on how to do this and found the following page on it:
>>>
>>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>>
>>> In the first few lines i found , " This example uses the MySQL database
>>> driver. To use this driver, its containing .jar file must be copied to
>>> the
>>> JMeter *lib * directory".
>>>
>>> I dont know what database driver to pick to that JMeter could contact my
>>> Database. I was having the MySql Query tool in my PC Which query's the
>>> MySql
>>> DB for the constructed queries. I assume this tool also needs the "MySQL
>>> database driver" , so i searched for the driver in its lib directory and
>>> found the following:
>>>
>>> mysql-connector-java-5.0.4-bin.jar
>>>
>>> I am not sure whether this is the same driver that needs to be used with
>>> JMeter to connect it to my MySql Database.
>>> Please let me know if i could make use of this driver or i need anything
>>> else to load my DB.
>>>
>>> Thanks
>>> Jatin
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>>
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

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

Re: Load Testing the MySql Database

[Jatin Davey <ja...@cisco.com>]

I downloaded the driver from the location mentioned below. Should i copy 
only the .Jar file into JMeter's lib directory or anything else is also 
required.
Please let me know.

Thanks
Jatin

Jakub Bia?ek wrote:
> Hi!
>
> Yes, you can use this driver, it's a bit old but if you use MySQL
> 5.0.x it should work fine.
> For MySQL 5.1.x you need another driver, here is place where you can
> download appropriate connector (for all version of MySQL db):
>
> http://dev.mysql.com/downloads/connector/j/5.1.html
>
> Best regards,
> Jakub
>
>
>
> 2009/9/28 Jatin Davey <ja...@cisco.com>:
>   
>> Hi All
>>
>> I want to load test my MySql Database. I was reading the JMeter user manual
>> on how to do this and found the following page on it:
>>
>> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>>
>> In the first few lines i found , " This example uses the MySQL database
>> driver. To use this driver, its containing .jar file must be copied to the
>> JMeter *lib * directory".
>>
>> I dont know what database driver to pick to that JMeter could contact my
>> Database. I was having the MySql Query tool in my PC Which query's the MySql
>> DB for the constructed queries. I assume this tool also needs the "MySQL
>> database driver" , so i searched for the driver in its lib directory and
>> found the following:
>>
>> mysql-connector-java-5.0.4-bin.jar
>>
>> I am not sure whether this is the same driver that needs to be used with
>> JMeter to connect it to my MySql Database.
>> Please let me know if i could make use of this driver or i need anything
>> else to load my DB.
>>
>> Thanks
>> Jatin
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>>     
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>   

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

Re: Load Testing the MySql Database

[Jakub Białek <ra...@gmail.com>]

Hi!

Yes, you can use this driver, it's a bit old but if you use MySQL
5.0.x it should work fine.
For MySQL 5.1.x you need another driver, here is place where you can
download appropriate connector (for all version of MySQL db):

http://dev.mysql.com/downloads/connector/j/5.1.html

Best regards,
Jakub



2009/9/28 Jatin Davey <ja...@cisco.com>:
> Hi All
>
> I want to load test my MySql Database. I was reading the JMeter user manual
> on how to do this and found the following page on it:
>
> http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
>
> In the first few lines i found , " This example uses the MySQL database
> driver. To use this driver, its containing .jar file must be copied to the
> JMeter *lib * directory".
>
> I dont know what database driver to pick to that JMeter could contact my
> Database. I was having the MySql Query tool in my PC Which query's the MySql
> DB for the constructed queries. I assume this tool also needs the "MySQL
> database driver" , so i searched for the driver in its lib directory and
> found the following:
>
> mysql-connector-java-5.0.4-bin.jar
>
> I am not sure whether this is the same driver that needs to be used with
> JMeter to connect it to my MySql Database.
> Please let me know if i could make use of this driver or i need anything
> else to load my DB.
>
> Thanks
> Jatin
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

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