1

No suitable driver found for jdbc:oracle for JDBC request in JMeter.

Configuration details:

enter image description here

Suggest if any changes required to resolve it.

Wasi Ahmad
  • 35,739
  • 32
  • 114
  • 161
Gorantla Balakrishna
  • 49
  • 5

1 Answers1

0
  1. Make sure your add Oracle JDBC driver to JMeter Classpath and restart JMeter afterwars.
  2. I am not sure that copying and pasting tnsnames.ora into the JDBC URL is supported, as far as I'm aware you need to set oracle.net.tns_admin system property and use TNS entry in the JDBC URL like jdbc:oracle:thin:@your_entry_name_here
  3. I also believe you should change your "Validation query" to SELECT 1 FROM DUAL

More information:

Dmitri T
  • 159,985
  • 5
  • 83
  • 133
  • I made the changes as per your suggetion, still could not able to resolve the issue. see the logs and Response data for SQL select 2017/07/18 08:17:28 WARN - jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver found for oracle.tcdms.db.url=jdbc:oracle:thin:@do2701.oracle.uprr.com:1521:do2701 Response Data : No suitable driver found for oracle.tcdms.db.url=jdbc:oracle:thin:@do2701.oracle.uprr.com:1521:do2701 – Gorantla Balakrishna Jul 18 '17 at 13:18
  • Can you elaborate the solution and let me know if you want more details – Gorantla Balakrishna Jul 18 '17 at 13:20