topic Re: ERROR MySQL connection in ThingWorx Developers

ERROR MySQL connection

mmicciche1 — Mon, 09 Apr 2018 13:16:42 GMT

Hi,

I try to connect a thing (with MySqlServer template) to my db (MySQL), but the property isConnected is always set to false and the service that i create for test the connection give this error: "Unable to Invoke Service <nameservice> on <nameThing>: null".

In the thing configuration I set JDBC Driver Class Name and the JDBC Connection String as following:

1) com.microsoft.sqlserver.jdbc.SQLServerDriver

2) jdbc:mysql://localhost:3306;databaseName=dbmesfava_dbo

Someone can help me? the version of thingworx is 8.2. Searching for this problem I find solution just for previous versions.

Re: ERROR MySQL connection

hchanana — Mon, 09 Apr 2018 14:35:34 GMT

Greetings @mmicciche1,

Please try the thing configuration as follows :

JDBC Driver Class Name : com.mysql.jdbc.Driver

JDBC Connection String : jdbc:mysql://127.0.0.1:3306/dbmesfava_dbo?allowMultiQueries=true

connectionValidationString : SELECT NOW()

Regards,

Himanshu

Re: ERROR MySQL connection

mmicciche1 — Mon, 09 Apr 2018 15:02:47 GMT

Greetings @hchanana,

Thanks for your support, I tried your solution but it doesn't work.. maybe can the problem regard the firewall?

Re: ERROR MySQL connection

hchanana — Wed, 02 May 2018 05:08:42 GMT

Greetings @mmicciche1,

Please let us know if this issue is resolved.

This might be a permission issue or firewall issue. If the issue still persists, please check that proper permissions are provided to the user.

Please refer the following community for reference

https://community.ptc.com/t5/ThingWorx-Developers/Error-connecting-to-the-MySQL-server/m-p/523006

Regards,

Himanshu