CODEWITHSUNDEEP
javaoracle-databasejdbcjmeter
Estevao FPM
Estevao FPM

Reputation: 111

Problem in Oracle JDBC Connection Configuration/JDBC Request - JMETER

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!!!

Upvotes: 0

Views: 1140

Answers (3)

Kuassi Mensah
Kuassi Mensah

Reputation: 312

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

Upvotes: 1

Nirmala
Nirmala

Reputation: 1338

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

Upvotes: 1

Dmitri T
Dmitri T

Reputation: 168197

  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:

Upvotes: 1

Related Questions