JDBC Driver Class Not Found: oracle.jdbc.OracleDriver
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JDBC Driver Class Not Found: oracle.jdbc.OracleDriver
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!
Solved! Go to Solution.
- Labels:
-
Connectivity
-
Troubleshooting
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please see if the answer to this topic might help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
corrected JDBC connection string:
JDBC Connection String: jdbc:oracle:thin:@//servername.com:port#/sid
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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