Skip to main content
K
knix1-Visitor
1-Visitor
September 10, 2015
Question

Connecting to Oracle

  • September 10, 2015
  • 16 replies
  • 7280 views

Trying to connect to an Oracle database and getting the following error: "Error loading tables. Please check your configuration" when create sql query. I do not see the Oracle ojdbc14.jar file anywhere.  How do I get it to connect to an Oracle database

16 replies

P
paic1-Visitor
1-Visitor
September 10, 2015

Hi Kent, not sure if you have access to our documentation/training material and the market place.

But based on the proper jdbc jar file that you have to provide, you can use the JDBC Extension creator Extension in the Marketplace to easily create a Thingworx extension that will bring in that jdbc and will allow you to connect to your Oracle DB and interact with it.

in our training material we show an example with MySQL

K
knix1-VisitorAuthor
1-Visitor
September 10, 2015

 

I have access to the market place.  I am unable to find where the documentation/training material is located at.

A
Aanjan5-Regular Member
5-Regular Member
September 10, 2015

Kent, the training materials are available at the PTC University Precision LMS page. This specific topic should be a part of the 'Introduction to ThingWorx' course under section 'Connecting to External Data Sources'.

Here is the Marketplace link to the JDBC Extension which should make the entire process of creating a JDBC extension easier.

And finally here is a link to our Help Centers which has links to both ThingWorx 6.0 and 6.5 versions and a separate link for Edge/Connectivity.

K
knix1-VisitorAuthor
1-Visitor
September 15, 2015

We were able to use the JDBC Connector Extension to create the ThingWorx extension. We then used this template to create a new thing and connect to our data source using JDBC and we get the following Oracle Error: Unable to Invoke Service OracleDBService on Oracle DB Connection : Io exception: Oracle Error ORA-12650.

We tested to make sure we could connect to our Oracle DB using SQlDeveloper using JDBC driver from the server ThingWorx is on and we were able to.

Any thoughts on this?

A
Aanjan5-Regular Member
5-Regular Member
September 15, 2015

Error ORA-12650 usually points to errors related to encryption. Is the server setup to accept encrypted connections?

K
knix1-VisitorAuthor
1-Visitor
September 15, 2015

Which Server, Oracle or ThingWorx?  I can run ThingWorx both clear and secure and have tried them both. None of the configuration is pointing it to connect secure to Oracle.

We might have something configured wrong but not sure what.  We created another external jdbc source to a virtual database we have and we get the following error: [context: com.thingworx.webservices.context.HttpExecutionContext@78e968b6][message: Unable to Invoke Service DenService on DenConnection : connection error: Remote host closed connection during handshake]

Terms & ConditionsAccessibility statement