Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
Imported "MSSQLConnector_Extension" and copy the file "sqljdbc42.jar" into the folder ...\Tomcat 8.5\lib.
For the configuration of Database Thing based on the ThingTemplate from the JDBC extension
JDBC Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC Connection String: jdbc:sqlserver://localhost:1433;databaseName=thingworx01;applicationName=Thingworx
connectionValidationString: SELECT GETDATA();
Ensure the admin and password is valid.
When testing service "GetAllRecords: select * from table01", failed. "Unable to Invoke Service GetAllRecords on MSSQLDatabase : null"
Solved! Go to Solution.
Are you referring to this extnsion? https://marketplace.ptc.com/apps/195356/jdbc-connector-extension#!overview
If so, please note it's not supported and provided in as-is condition. I'd recommend obtaining a needed driver and creating your own extension per instructions I provided here https://community.ptc.com/t5/ThingWorx-Developers/Using-a-third-party-Jar-file-for-Database-connection/m-p/514861?author_id=269584&collapse_discussion=true&filter=authorId&q=jdbc&search_type=thread
Are you referring to this extnsion? https://marketplace.ptc.com/apps/195356/jdbc-connector-extension#!overview
If so, please note it's not supported and provided in as-is condition. I'd recommend obtaining a needed driver and creating your own extension per instructions I provided here https://community.ptc.com/t5/ThingWorx-Developers/Using-a-third-party-Jar-file-for-Database-connection/m-p/514861?author_id=269584&collapse_discussion=true&filter=authorId&q=jdbc&search_type=thread
change the connectionValidationString from SELECT GETDATA() to SELECT 1, then it works successfully.