Problems connecting ThingWorx 9.2 to a external SQL server without using an external extension.

[GerardAlonso]

I followed this article to configure my database thing: https://www.ptc.com/en/support/article/cs318728

I got the database configured but when i try to run services to check the connection (the query that i'm trying is SELECT GetDate()) the following error returns: "Unable to Invoke Service RunDatabaseQuery on DatabaseConnection : Execute Query failed: java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object"

Don't know what may be wrong I used the following configuration for the database thing

 

And the property tab looks like this

 Please let me know if you need more information to help me

[slangley]

Hi @GerardAlonso 

I noticed you entered net.sourceforge.jtds.jdbc.Driver for the JDBC Driver Class Name.  Which jdbc driver did you install? 

Regards.

--Sharon

[GerardAlonso]

Hi @slangley 

I followed this guide to configure the databse thing:

https://developer.thingworx.com/en/resources/guides/external-databases/external-database-connection

The configuration mentioned in this article  https://www.ptc.com/en/support/article/cs318728 was not working for me

Regards,

Gerard

[DmitryTsarev · Accepted solution]

@GerardAlonso , I have a few clarifying notes / suggestions...

1) Just to double-check... Since you're using jTDS driver for MS SQL, are you using a compatible SQL version? AFAIK, it only supports up to SQL Server 2012

2) To narrow down the cause, I'd suggest to take Microsoft's JDBC driver (7.4 for ThingWorx 9.0+) and check if it works with it.

I've just tested with sqljdbc_7.4.1.0 and attached the config tab of my database thing.

If it works, the issue is probably related to jTDS driver.

If it still doesn't work, something is probably wrong with your database Thing configuration or network.

Below is my full JDBC Connection String since it's not seen on the screenshot.

jdbc:sqlserver://192.168.1.17:1433;databaseName=twtest;applicationName=Thingworx;

 

[GerardAlonso]

Hi @DmitryTsarev 

Thank you very much for you suggestion and clariffications, I used the JDBC driver that you mention and now the database thing is working correctly.

Thanks,

Gerard