Skip to main content
B
bmehringer1-Visitor
1-Visitor
October 16, 2020
Solved

MS SQL Connections in 9.0

  • October 16, 2020
  • 2 replies
  • 1198 views

I'm doing some testing on an instance of 9.0.2 and I tried importing a JDBC extension that uses the 7.2 version of the MS SQL JDBC jar file, however, I got an error indicating a new version was available (that I did not import).

 

After further review, I found a newer version of the MS SQL JDBC jar file buried in the Thingworx web application file:

 

C:\..\Tomcat 9.0\webapps\Thingworx\WEB-INF\lib

 

File: mssql-jdbc-7.4.1.jre8.jar

 

Questions:

  1. With TWX 9.0, do we no longer have to have a specific extension installed to connect to MS SQL databases?
  2. When creating a new connection to MS SQL Server for a TWX application, do we just use the "Database" Thing Template, and configure accordingly?

Method in #2 above is working, it's just different than what I'm used (started with 7.4). I think this is great, but want to be sure I'm using this as expected.

Best answer by mnarang

I believe you are seeing mssql-jar in WEB-INF/lib because either you already imported the mssql extension earlier or you have a mssql persistence provider ThingWorx installed. I have both 9.0 and 9.0.2 postgresql backed ThingWorx versions and in both I don't have this Jar coming as OOTB. That basically means the driver Jar is not included by default in all the ThingWorx (Postgresql backed/MSSQL backed/H2 Backed). As i said earlier you are seeing it because either you have mssql based ThingWorx war or you have already imported the extension earlier.

 

 

 

Thanks,

Mukul Narang

2 replies

M
mnarang5-Regular MemberAnswer
5-Regular Member
October 19, 2020

I believe you are seeing mssql-jar in WEB-INF/lib because either you already imported the mssql extension earlier or you have a mssql persistence provider ThingWorx installed. I have both 9.0 and 9.0.2 postgresql backed ThingWorx versions and in both I don't have this Jar coming as OOTB. That basically means the driver Jar is not included by default in all the ThingWorx (Postgresql backed/MSSQL backed/H2 Backed). As i said earlier you are seeing it because either you have mssql based ThingWorx war or you have already imported the extension earlier.

 

 

 

Thanks,

Mukul Narang

S
slangleyCommunity Manager
Support
November 4, 2020

Hi @bmehringer.

 

If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement