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:

Could someone help me?

Thanks!!!

CodePudding user response：

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:

• OracleDriver Documentation
• DBCP - validationQuery for different Databases
• The Real Secret to Building a Database Test Plan With JMeter

CodePudding user response：

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