JDBC Driver Class Not Found: oracle.jdbc.OracleDriver

[pkodur]

Folks,

I'm trying to setup a connection to ORACLE 12c. I uploaded the JAR file using TW_Download_JDBC Connector Extension. I received an error when "Thing" is saved with the following details:

JDBC Driver Class Name: oracle.jbdc.driver.OracleDriver

I tried with "oracle.jdbc.OracleDriver" as well, both are unsuccessful

Any help appreciated. Thanks!

[posipova]

Please see if the answer to this topic might help you.

Using a third party Jar file for Database connection

[pkodur · Accepted solution]

Thank you for your response Polina Osipova. I figured out the problem, here are the details which might help others:

1. The server where Thingworx was installed didn't had ojdbc6.jar file under Tomcat\lib folder. Once file is added make sure server is restarted

2. Once the ojdbc6.jar extension is imported into Thingworkx composer, the configuration section holds the following entries:

JDBC Driver Class Name: oracle.jdbc.OracleDriver

JDBC Connection String: jdbc:oracle:thin:@//s.com:po

[pkodur]

corrected JDBC connection string:

JDBC Connection String: jdbc:oracle:thin:@//servername.com:port#/sid

[supandey]

Hi Pavan that's the correct connection string also there is a blog on this linking it here for reference How to configure Oracle 12c's Pluggable Database as External DataStorage for ThingWorx

[aamit]

Hi,

There is a small typo in the Class name you provided. Should be jdbc instead of jbdc.

This is what works for me:

    oracle.jdbc.driver.OracleDriver

Thanks,

Asaf.

[pkodur]

Thank you Asif for your response. I got the issue resolved. Here are my configuration details:

DBC Driver Class Name: oracle.jdbc.OracleDriver

JDBC Connection String: jdbc:oracle:thin:@//servername.com:port#/sid