Unable to connect to an external Database using Thingworx

[VV_9240359]

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 

[Rocko]

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.

[VV_9240359 · Accepted solution]

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.