Thanks for reply.
I am connecting my TWX with MS SQL Database.
So for that I import SQL_Connector_Extension which I created manually by putting metadata.xml and sqljdbc4.jar file.
Then I create a thing and implement that template then add a service and fire a query after putting configuration details which are:
JDBC Driver Class Name : com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC Connection String : jdbc:sqlserver://TCIDATA1.whirlpool.com;DatabaseName=TCI_History
Now should I have to put port in the URL also???
Because I am getting this error while executing the service:
So this is the whole scenario.
I hope you are getting me.
- Try changing the connection Validation String to "SELECT GETDATE()".
- Try the Microsoft SQL Extension available on ThingWorx Marketplace. http://marketplace.thingworx.com/Items/Relational-databases-connectors
- Try Restarting the ThingWorx Tomcat.
- Try re-importing the extension i.e. Delete the extension. Then reboot your ThingWorx instance. Then import the extension again.
Hope it helps.