This is a PDF version of Article CS229265 and may be out of date. For the latest version click here
Article - CS229265
  4 Votes

Unable to connect Oracle database in ThingWorx - Correct Syntax for Oracle DB Connection String

Created: 10-Feb-2016   |   Modified: 10-Jan-2019   

Applies To

  • ThingWorx Platform 7.0 to 8.3

Description

  • Cannot configure DatabaseThing to connect to Oracle database
    • Error: "Unable to Invoke Service <name> on <database> : No suitable driver found for jdbc:<name>://<server>:<port>/<sid>?param=value"
    • Error: "Thing[<DatabaseThing>] is not running"
  • How to configure the JDBC Connector Extension
  • The SQL services cannot be executed