java.sql.SQLException: No suitable driver found for jdbc:mysql:

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

java.sql.SQLException: No suitable driver found for jdbc:mysql:

arihan
This post has NOT been accepted by the mailing list yet.
Hi All,

I want to test the database which is installed in a different server ( say dimvidi2202). But while I am running the test it gives the error as  java.sql.SQLException: No suitable driver found for jdbc:mysql:. Any idea pls???? Is anywhere I am doing anything wrong...

I did the configuration as below

database url :- jdbc:mysql://dimvidi2202:3306/ca_tw
jdbc driver class:- com.mysql.jdbc.Driver
user name :- ca_user
password :- ca_user

Also copied the mysql-connector-java-5.0.3.jar to the jakarta-jmeter-2.3RC4\jakarta-jmeter-2.3RC4\lib
Also the driver class is present in that mysql-connector-java-5.0.3.jar
searching these jarfiles now ....

===============================================
Found: com.mysql.jdbc.Driver
Class: com.mysql.jdbc.Driver
Package: com.mysql.jdbc
Library Name: mysql-connector-java-5.0.3.jar
Library Path: C:\SequenceRender\jakarta-jmeter-2.3RC4\jakarta-jmeter-2.3RC4\lib\mysql-connector-java-5.0.3.jar
===============================================
Reply | Threaded
Open this post in threaded view
|

Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:

arihan
The error log as below
============================
2011/07/05 14:19:21 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error in JDBC sampling java.sql.SQLException: No suitable driver found for jdbc:mysql://dimvidi2202:3306/ca_tw
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:185)
        at org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLimitingPool.java:672)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:178)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
        at org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPool.java:402)
        at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:130)
        at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
        at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:150)
        at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:298)
        at java.lang.Thread.run(Thread.java:619)

Reply | Threaded
Open this post in threaded view
|

Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:

Felix Frank-2
Hi,

On 07/05/2011 03:33 PM, arihan wrote:
> 2011/07/05 14:19:21 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler: Error
> in JDBC sampling java.sql.SQLException: No suitable driver found for
> jdbc:mysql://dimvidi2202:3306/ca_tw

if your Java installation is lacking the MySQL JDBC driver, installing
that driver should help, no?

Regards,
Felix

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:

arihan
if you could tell me step by step that would be really helpful.

Cheers
Arihan
Reply | Threaded
Open this post in threaded view
|

Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:

Felix Frank-2
On 07/05/2011 03:48 PM, arihan wrote:
> if you could tell me step by step that would be really helpful.

Sorry, that's outside my area of expertise.

You may want to check the official Java/JDBC documentation.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:

arihan
Thats fine. I did my own and its working ok. cheers Arihan
Reply | Threaded
Open this post in threaded view
|

Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:

darylbarker
This post has NOT been accepted by the mailing list yet.
I'm getting the same problem while running JMeter can you tell me how you sorted this?

Thanks
Reply | Threaded
Open this post in threaded view
|

Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:

arihan
mysql-connector-java-5.0.8-bin.jar and copy that to the below locations

\jakarta-jmeter-2.3RC4\jakarta-jmeter-2.3RC4\lib

C:\Program Files (x86)\Java\jdk1.6.0_21\jre\lib\ext\mysql-connector-java-5.0.8-bin.jar
C:\Program Files (x86)\Java\jdk1.6.0_21\jre\lib\mysql-connector-java-5.0.8-bin.jar

also add in the classpath in env variable :-C:\Program Files (x86)\Java\jdk1.6.0_21\jre\lib\mysql-connector-java-5.0.8-bin.jar

Also you can check if com.mysql.jdbc.Driver is in the mysql-connector-java-5.0.8-bin.jar by copy this to C:\Program Files (x86)\Java\jdk1.6.0_21\bin and run
command as :- jar -tvf mysql-connector-java-5.0.8-bin.jar

Cheers arihan
Reply | Threaded
Open this post in threaded view
|

Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:

Philippe Mouawad
Hello,
JMeter 2.3 is a rather very old version.
Although this is not the problem, you should upgrade to 2.7.

Regards
Philippe M.
http://www.ubik-ingenierie.com

On Wed, Jul 25, 2012 at 4:15 PM, arihan <[hidden email]> wrote:

> mysql-connector-java-5.0.8-bin.jar and copy that to the below locations
>
> \jakarta-jmeter-2.3RC4\jakarta-jmeter-2.3RC4\lib
>
> C:\Program Files
> (x86)\Java\jdk1.6.0_21\jre\lib\ext\mysql-connector-java-5.0.8-bin.jar
> C:\Program Files
> (x86)\Java\jdk1.6.0_21\jre\lib\mysql-connector-java-5.0.8-bin.jar
>
> also add in the classpath in env variable :-C:\Program Files
> (x86)\Java\jdk1.6.0_21\jre\lib\mysql-connector-java-5.0.8-bin.jar
>
> Also you can check if com.mysql.jdbc.Driver is in the
> mysql-connector-java-5.0.8-bin.jar by copy this to C:\Program Files
> (x86)\Java\jdk1.6.0_21\bin and run
> command as :- jar -tvf mysql-connector-java-5.0.8-bin.jar
>
> Cheers arihan
>
>
>
> --
> View this message in context:
> http://jmeter.512774.n5.nabble.com/java-sql-SQLException-No-suitable-driver-found-for-jdbc-mysql-tp4553152p5714126.html
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>


--
Cordialement.
Philippe Mouawad.
Ubik-Ingénierie
Philippe M.
@philmdot
http://ubikloadpack.com