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:
Someone can help me? the version of thingworx is 8.2. Searching for this problem I find solution just for previous versions.
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()
Thanks for your support, I tried your solution but it doesn't work.. maybe can the problem regard the firewall?
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