Do you restart jmeter after you copy mysql-connector-java-5.0.4-bin.jar to lib directory?
Jakub 2009/9/28 Jatin Davey <jasho...@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 <jasho...@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 <jasho...@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-unsubscr...@jakarta.apache.org >>>>> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >>>>> >>>>> >>>>> >>>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >>>> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >>>> >>>> >>>> >>>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >>> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >>> >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org >> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >> >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org > For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org