Skip to main content
G
GrafZahl1-Visitor
1-Visitor
May 2, 2019
Solved

Thing is not running - SQL JDBC

  • May 2, 2019
  • 6 replies
  • 5953 views

Hello,

I try to connect a Microsoft SQL Database to ThingWorx … I installed the JDBC MSSQL Connector Extension from the Marketplace and imported it … Then I created a Thing “DB1” with the Base Thing Template MSSqlServer… In the Configuration page I tried to configured…

JDBC Driver Class Name:
com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC Connection String:
jdbc:sqlserver://127.0.0.1\SQLEXPRESS;databaseName=thingworx

connectionValidationString:
SELECT GETDATE()

Database User Name:
sa

Database Password:

my password

 

after saving I get the Message Thing[DB1] is not running…

can anybody help me?

 

I use.. 

Thingworx:8 trial

Microsoft SQL Server 2017

 

 

best regards!

Best answer by posipova

I'm suspecting the extension might have not been updated in a while and the driver supplied is old.

Could you please  take a look at my response to this thread (first comment) for detailed instructions on how to package a new jdbc driver?

https://community.ptc.com/t5/ThingWorx-Developers/Using-a-third-party-Jar-file-for-Database-connection/m-p/514861

6 replies

P
posipova20-Turquoise
20-Turquoise
May 2, 2019

It seems the db connection is not getting established. Do you have all the needed ports enabled in your SQL database? Check ThingWorx application log for errors.

G
GrafZahl1-VisitorAuthor
1-Visitor
May 3, 2019

In the ThingWorx  application log is the following message:

 

ERROR starting: JDBC Driver Class Not Found: com.microsoft.sqlserver.jdbc.SQLServerDriver

Error message: Thing is not running

 

in my SQL Management Studio my instance port 1433 is enabled. 

- the Windows Firewall is off.

- FYI my Windows Server 2017 is a VM Ware.

P
posipova20-Turquoise
20-Turquoise
May 3, 2019

Do you have TCP/IP enabled in your SQL configuration manager?

Terms & ConditionsAccessibility statement