Hi, hope someone can help me with this issue.

I'm trying to create a JDBC db profile connection to an Oracle 12c or 19c database, but have not been successful. 

This is what I specified in the DB Profile:

I use the JDB JDBC Database Interface GUI and specify,

Profile name: DWH10JDBC

Driver name: oracle.jdbc.driver.OracleDriver

URL:  jdbc:oracle:thin:@DWH:1577:DWH10

LogID: user1

Password: *******

This is the preview looks like:

// Profile DWH10JDBC
SQLCA.DBMS = "JDBC"
SQLCA.LogPass = <********>
SQLCA.LogId = "user1"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Driver='oracle.jdbc.driver.OracleDriver',URL='jdbc:oracle:thin:@DWH10:1577:DWH10'"

Then I created a CLASSPATH env variable under my user to point to the Oracle 19c 32-bit directories which I hope might contain one of the files required by PB:

C:\app\0ra19300_32-bit\Oracle_193000_32-bit\jdbc\lib

C:\app\0ra19300_32-bit\Oracle_193000_32-bit\jdk\jre\lib

C:\app\0ra19300_32-bit\Oracle_193000_32-bit\jdk\lib

When I test the profile, I still have the same error, which is:

Non SQL Error:  Could not load class oracle.jdbc.driver.OracleDriver

Please help.

Thanks.