0

I'm a problem in JDBC Connection Configuration. When i execute my test (only JDBC Request - insert), doesn't appear any results in report (View Results Tree):

"Cannot create JDBC driver of class 'oracle.jdbc.OracleDriver' for connect URL 'jdbc:oracle:JDTST'"

The connection is Oracle. See below the configuration:

database URL: jdbc:oracle://${myURL}

JDBC driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Username: ${user}

Password: ${password}

Print below: enter image description here

lister.ora file: enter image description here

My login in Oracle DB:

enter image description here

Could someone help me?

Thanks!!!

Estevao FPM
  • 113
  • 1
  • 9

3 Answers3

1

  1. I don't think your URL is correct, it should be something like:

    jdbc:oracle:thin:@your-oracle-hostname-or-ip-address:your-oracle-port:your-oracle-SID

  2. Correct JDBC Driver fully qualified name is oracle.jdbc.driver.OracleDriver

  3. The "Validation query" should be select 1 from dual

  4. You will need to download Oracle JDBC Driver and drop it to JMeter Classpath

More information:

Dmitri T
  • 159,985
  • 5
  • 83
  • 133
  • Dmitri T, - My URL: jdbc:oracle:thin:@${JDTST} - JDBC Driver: I tried with oracle.jdbc.driver.OracleDriver and oracle.jdbc.OracleDriver - I changed "Validation query" to select 1 from dual. Error again.. =/ See below: :java.sql.SQLException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL ' jdbc:oracle:thin:@JDTST' – Estevao FPM Feb 17 '22 at 17:01
  • DmitriT, I added a print of the listener.ora file in description. How would I get his URL? – Estevao FPM Feb 17 '22 at 17:46
  • I added other print in description, about my login in Oracle DB! – Estevao FPM Feb 18 '22 at 15:26
  • ??? =/ !!!!!!!!! – Estevao FPM Feb 22 '22 at 15:35
1

Refer to JDBC Developer's guide on how the JDBC connection URL is formed. The easiest way is to use the below URL. You can use DataSourceSample.java for checking the connection.

jdbc:oracle:thin:db_user/db_password@localhost:5221:orcl
Nirmala
  • 1,278
  • 1
  • 10
  • 11
1

Database SID is no longer supported; please use a service name as in Nirmala's response.

Kuassi Mensah
  • 274
  • 1
  • 4
  • But it doesn't work... I tried: jdbc:oracle:thin:CAMILA_JDCCS2019/keyUser@localhost:5221:orcl – Estevao FPM Feb 18 '22 at 16:49
  • The error below: java.sql.SQLException: Cannot create PoolableConnectionFactory (Erro de ES: The Network Adapter could not establish the connection) – Estevao FPM Feb 18 '22 at 16:51