ERROR MySQL connection

[mmicciche1]

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.

[hchanana]

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

[mmicciche1]

Greetings  @hchanana,

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

[hchanana]

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