cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Thing is not running - SQL JDBC

SOLVED
Highlighted
Regular Member

Thing is not running - SQL JDBC

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!

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Thing is not running - SQL JDBC

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-connecti...

View solution in original post

6 REPLIES 6
Highlighted

Re: Thing is not running - SQL JDBC

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.

Highlighted

Re: Thing is not running - SQL JDBC

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.

Highlighted

Re: Thing is not running - SQL JDBC

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


Highlighted

Re: Thing is not running - SQL JDBC

Yes- my TCP/IP is enabled.

 

do I need to install a JDBC driver on my Windows Server?...or is importing the JDBC package from the ThingWorx Marketplace sufficient? 

 

Is it possible that I need to change the JDBC metadata file?

 

thank you for your help! :-) 

Highlighted

Re: Thing is not running - SQL JDBC

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-connecti...

View solution in original post

Highlighted

Re: Thing is not running - SQL JDBC

Hi @GrafZahl,

 

Please review this post for possible solutions.  If you're still having issues, please provide more information regarding your configuration.

 

Regards.

 

--Sharon

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!