Skip to main content
1-Visitor
April 26, 2017
Solved

JDBC Driver Class Not Found: oracle.jdbc.OracleDriver

  • April 26, 2017
  • 2 replies
  • 67499 views

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!

Best answer by pkodur

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

2 replies

20-Turquoise
April 26, 2017

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

Using a third party Jar file for Database connection

pkodur1-VisitorAuthorAnswer
1-Visitor
April 27, 2017

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

pkodur1-VisitorAuthor
1-Visitor
April 27, 2017

corrected JDBC connection string:

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

5-Regular Member
April 27, 2017

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.

pkodur1-VisitorAuthor
1-Visitor
April 27, 2017

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