You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by arihan <ar...@gmail.com> on 2011/07/05 15:33:12 UTC
Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:
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)
--
View this message in context: http://jmeter.512774.n5.nabble.com/java-sql-SQLException-No-suitable-driver-found-for-jdbc-mysql-tp4553152p4553248.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:
Posted by Philippe Mouawad <p....@ubik-ingenierie.com>.
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 <ar...@gmail.com> 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: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>
--
Cordialement.
Philippe Mouawad.
Ubik-Ingénierie
Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:
Posted by arihan <ar...@gmail.com>.
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: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org
Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:
Posted by arihan <ar...@gmail.com>.
Thats fine. I did my own and its working ok. cheers Arihan
--
View this message in context: http://jmeter.512774.n5.nabble.com/java-sql-SQLException-No-suitable-driver-found-for-jdbc-mysql-tp4553152p4553690.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:
Posted by Felix Frank <ff...@mpexnet.de>.
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: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:
Posted by arihan <ar...@gmail.com>.
if you could tell me step by step that would be really helpful.
Cheers
Arihan
--
View this message in context: http://jmeter.512774.n5.nabble.com/java-sql-SQLException-No-suitable-driver-found-for-jdbc-mysql-tp4553152p4553291.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: java.sql.SQLException: No suitable driver found for jdbc:mysql:
Posted by Felix Frank <ff...@mpexnet.de>.
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: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org