Skip to main content
V
VV_924035912-Amethyst
12-Amethyst
September 29, 2025
Solved

Unable to connect to an external Database using Thingworx

  • September 29, 2025
  • 1 reply
  • 437 views

Hello

With reference to this tip, I am not able to connect to external database 

In properties section of DB Thing it is showing as not connected 

 

But somehow some services are getting executed 

Best answer by VV_9240359

Hey Rocko,

Thanks for the suggestion yes the "connectionValidationString" was correct the issue got resolved after restarting Tomcat and the "isConnected" property got checked.

Thanks.

 

1 reply

Rocko
Rocko19-Tanzanite
19-Tanzanite
September 29, 2025

First off, if the services are executed as you say, and deliver a result, I think we can consider the DB as connected.

Second, to make the "isConnected" work, you need to provide a proper test query when setting up the DB connection. Check "connectionValidationString" in the configuration tab.

    V
    VV_924035912-AmethystAuthorAnswer
    12-Amethyst
    October 8, 2025

    Hey Rocko,

    Thanks for the suggestion yes the "connectionValidationString" was correct the issue got resolved after restarting Tomcat and the "isConnected" property got checked.

    Thanks.

     

    Terms & ConditionsCookie settingsAccessibility statement