ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » JDBC JMETER - No suitable driver error

Post new topic  Reply to topic
 JDBC JMETER - No suitable driver error « View previous topic :: View next topic » 
Author Message
RadhamaniRamadoss
PostPosted: Sat Jun 29, 2013 12:56 am    Post subject: JDBC JMETER - No suitable driver error Reply with quote

Apprentice

Joined: 08 Oct 2009
Posts: 42
I am doing a performance testing for Mysql database using jmeter jdbc configuration.

Plese find below configuration,

JDBC url :jdbc:mysql://DBDHUB01:3306/DD
JDBC Driver class name :com.mysql.jdbc.Driver
Username:mqbrkrs
Password:*******

I use jre1.6 from C:/Program Files/IBM/MQSI/8.0.0.1/jre16/bin/java.exe for jmeter as below in jmeter.bat ,
.%JM_LAUNCH% == . set JM_LAUNCH="C:/Program Files/IBM/MQSI/8.0.0.1/jre16/bin/java.exe"

I have copied mysql-connector-java-5.0.8.jar in below paths,
jmeter lib path -C:\apache-jmeter-2.9\apache-jmeter-2.9\lib
java lib path -C:\Program Files\IBM\MQSI\8.0.0.1\jre16\lib
java ext lib path - C:\Program Files\IBM\MQSI\8.0.0.1\jre16\lib\ext

I have also set the class path in Environment variable for mysql-connector-java-5.0.8.jar

I tried even restarting my machine albeit reopeing cmd window.

even after all the setup above,the error throws as
'Response message: java.sql.SQLException: No suitable driver' in jmeter jdbc test
----------------------------------------------------------------------------------
The jmeter log extract below,

2013/06/29 09:37:25 INFO - jmeter.threads.ThreadGroup: Started thread group number 1
2013/06/29 09:37:25 INFO - jmeter.engine.StandardJMeterEngine: All thread groups have been started
2013/06/29 09:37:25 DEBUG - jmeter.threads.TestCompiler: Subtracting node, stack size = 2
2013/06/29 09:37:25 DEBUG - jmeter.threads.TestCompiler: Subtracting node, stack size = 2
2013/06/29 09:37:25 DEBUG - jmeter.threads.TestCompiler: Subtracting node, stack size = 2
2013/06/29 09:37:25 DEBUG - jmeter.threads.TestCompiler: Subtracting node, stack size = 2
2013/06/29 09:37:25 DEBUG - jmeter.threads.TestCompiler: adding controller: org.apache.jmeter.threads.ThreadGroup@2bc22bc2 to sampler config
2013/06/29 09:37:25 DEBUG - jmeter.threads.TestCompiler: Subtracting node, stack size = 1
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread started: JDBC Thread Group 1-10
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 DEBUG - jmeter.testbeans.TestBeanHelper: Preparing class org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler
2013/06/29 09:37:25 DEBUG - jmeter.testbeans.TestBeanHelper: Setting dataSource=MYSQL
2013/06/29 09:37:25 DEBUG - jmeter.testbeans.TestBeanHelper: Setting queryType=Select Statement
2013/06/29 09:37:25 DEBUG - jmeter.testbeans.TestBeanHelper: Setting query=select * from T_CARD where CARD_NO=3747;
2013/06/29 09:37:25 DEBUG - jmeter.testbeans.TestBeanHelper: Setting queryArguments=
2013/06/29 09:37:25 DEBUG - jmeter.testbeans.TestBeanHelper: Setting queryArgumentsTypes=
2013/06/29 09:37:25 DEBUG - jmeter.testbeans.TestBeanHelper: Setting variableNames=
2013/06/29 09:37:25 DEBUG - jmeter.testbeans.TestBeanHelper: Setting resultVariable=
2013/06/29 09:37:25 DEBUG - jmeter.protocol.jdbc.sampler.JDBCSampler: sampling jdbc
2013/06/29 09:37:25 WARN - jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:387)
at java.sql.DriverManager.getConnection(DriverManager.java:415)
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.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:286)
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:146)
at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:85)
at org.apache.jmeter.threads.JMeterThread.process_sampler(JMeterThread.java:428)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:256)
at java.lang.Thread.run(Thread.java:736)

2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-1
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-1
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-3
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-3
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-7
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-7
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-5
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-5
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-9
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-9
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-2
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-2
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-4
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-4
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-8
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-8
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-6
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-6
2013/06/29 09:37:25 DEBUG - jmeter.control.GenericController: Calling next on: org.apache.jmeter.control.LoopController
2013/06/29 09:37:25 INFO - jmeter.threads.JMeterThread: Thread finished: JDBC Thread Group 1-10
2013/06/29 09:37:25 DEBUG - jmeter.threads.ThreadGroup: Ending thread JDBC Thread Group 1-10
2013/06/29 09:37:25 INFO - jmeter.engine.StandardJMeterEngine: Notifying test listeners of end of test
2013/06/29 09:37:25 DEBUG - jmeter.protocol.jdbc.config.DataSourceElement: There were 10 outstanding objects when the pool was disposed.
2013/06/29 09:37:25 INFO - jmeter.gui.util.JMeterMenuBar: setRunning(false,*local*)
2013/06/29 09:37:28 DEBUG - jmeter.gui.tree.JMeterTreeListener: value changed, updating currentPath
2013/06/29 09:37:28 DEBUG - jmeter.gui.tree.JMeterTreeListener: mouse pressed, updating currentPath
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Updating current node JDBC Thread Group
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.threads.gui.ThreadGroupGui[JDBC Thread Group,0,0,763x540,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=javax.swing.border.EmptyBorder@7e937e93,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:28 DEBUG - jmeter.gui.AbstractJMeterGuiComponent: setting element to enabled: true
2013/06/29 09:37:28 DEBUG - jmeter.gui.AbstractJMeterGuiComponent: setting element to enabled: true
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.SummaryReport[Summary Report,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Updating current node Summary Report
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.SummaryReport[Summary Report,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:28 DEBUG - jmeter.gui.AbstractJMeterGuiComponent: setting element to enabled: true
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.SummaryReport[Summary Report,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Updating gui to new node
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.SummaryReport[Summary Report,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Updating current node Summary Report
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.SummaryReport[Summary Report,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:28 DEBUG - jmeter.gui.AbstractJMeterGuiComponent: setting element to enabled: true
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.SummaryReport[Summary Report,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:28 DEBUG - jmeter.gui.GuiPackage: Updating gui to new node
2013/06/29 09:37:29 DEBUG - jmeter.gui.tree.JMeterTreeListener: value changed, updating currentPath
2013/06/29 09:37:29 DEBUG - jmeter.gui.tree.JMeterTreeListener: mouse pressed, updating currentPath
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Updating current node Summary Report
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.SummaryReport[Summary Report,0,0,763x540,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:29 DEBUG - jmeter.gui.AbstractJMeterGuiComponent: setting element to enabled: true
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.ViewResultsFullVisualizer[View Results Tree,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=javax.swing.border.EmptyBorder@64326432,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Updating current node View Results Tree
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.ViewResultsFullVisualizer[View Results Tree,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=javax.swing.border.EmptyBorder@64326432,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:29 DEBUG - jmeter.gui.AbstractJMeterGuiComponent: setting element to enabled: true
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.ViewResultsFullVisualizer[View Results Tree,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=javax.swing.border.EmptyBorder@64326432,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Updating gui to new node
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.ViewResultsFullVisualizer[View Results Tree,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=javax.swing.border.EmptyBorder@64326432,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Updating current node View Results Tree
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.ViewResultsFullVisualizer[View Results Tree,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=javax.swing.border.EmptyBorder@64326432,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:29 DEBUG - jmeter.gui.AbstractJMeterGuiComponent: setting element to enabled: true
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Gui retrieved = org.apache.jmeter.visualizers.ViewResultsFullVisualizer[View Results Tree,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=javax.swing.border.EmptyBorder@64326432,flags=9,maximumSize=,minimumSize=,preferredSize=]
2013/06/29 09:37:29 DEBUG - jmeter.gui.GuiPackage: Updating gui to new node


----------------------------------------------------------------------------------

Not sure whether version mismatch or what could be the problem .
mysql-connector-java-5.0.8.jar seems to be the latest jdbc connector

Please help ..

If this is wrong forum for this Query,please apologise and guide me the correct forum to get the resolution ....
Back to top
View user's profile Send private message
exerk
PostPosted: Sat Jun 29, 2013 2:19 am    Post subject: Reply with quote

Jedi Council

Joined: 02 Nov 2006
Posts: 6339
Moved to the Broker forum.
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys.
Back to top
View user's profile Send private message
Tibor
PostPosted: Sat Jun 29, 2013 4:22 am    Post subject: Reply with quote

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary
Why don't you use MySQL's own JDBC driver (Connector/J)? JMeter is something different, as I know.
Back to top
View user's profile Send private message
RadhamaniRamadoss
PostPosted: Sat Jun 29, 2013 10:27 pm    Post subject: Reply with quote

Apprentice

Joined: 08 Oct 2009
Posts: 42
Ya..That worked for me !
I now used mysql-connector-java-5.1.25.jar instead of mysql-connector-java-5.0.8.jar.

But my doubt is both the jars are platform independent and there is no specific mysql driver to use in jmeter.
And mysql-connector-java-5.0.8.jar works fine for me when I connect to Mysql from Linux server.But it didnt work for me when I connect from Windows machine.And in jmeter as well as in that Linux server the same version of jre is referred...Not sure why there is a version change expected for mysql driver..Please clarify..
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » JDBC JMETER - No suitable driver error
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.