Problem in Oracle JDBC Connection Configuration/JDBC Request - JMETER

Question

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:

lister.ora file:

My login in Oracle DB:

Could someone help me?

Thanks!!!

Dmitri T · Accepted Answer · 2022-02-17 16:34:22Z

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

Correct JDBC Driver fully qualified name is oracle.jdbc.driver.OracleDriver
The "Validation query" should be select 1 from dual
You will need to download Oracle JDBC Driver and drop it to JMeter Classpath

More information:

answered Feb 17, 2022 at 16:34

Dmitri T

169k6 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Estevao FPM Over a year ago

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 Over a year ago

DmitriT, I added a print of the listener.ora file in description. How would I get his URL?

Estevao FPM Over a year ago

I added other print in description, about my login in Oracle DB!

Estevao FPM Over a year ago

??? =/ !!!!!!!!!

Nirmala · Accepted Answer · 2022-02-17 22:23:38Z

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

answered Feb 17, 2022 at 22:23

Nirmala

1,3501 gold badge10 silver badges12 bronze badges

4 Comments

Estevao FPM Over a year ago

Nirmala, I added the URL but to no avail... =/

Estevao FPM Over a year ago

I added other print in description, about my login in Oracle DB!

Estevao FPM Over a year ago

??? =/ !!!!!!!!!

Nirmala Over a year ago

Can you check tnsnames.ora on the database side and verify if the connection works through sqlplus?

Kuassi Mensah · Accepted Answer · 2022-02-18 16:13:03Z

1

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

answered Feb 18, 2022 at 16:13

Kuassi Mensah

3151 silver badge6 bronze badges

2 Comments

Estevao FPM Over a year ago

But it doesn't work... I tried: jdbc:oracle:thin:CAMILA_JDCCS2019/keyUser@localhost:5221:orcl

Estevao FPM Over a year ago

The error below: java.sql.SQLException: Cannot create PoolableConnectionFactory (Erro de ES: The Network Adapter could not establish the connection)

Collectives™ on Stack Overflow

Problem in Oracle JDBC Connection Configuration/JDBC Request - JMETER

3 Answers 3

4 Comments

4 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related