Skip to main content
M
mmicciche11-Visitor
1-Visitor
April 9, 2018
Question

ERROR MySQL connection

  • April 9, 2018
  • 1 reply
  • 2818 views

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.

 

 

1 reply

H
hchanana16-Pearl
16-Pearl
April 9, 2018

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

M
mmicciche11-VisitorAuthor
1-Visitor
April 9, 2018

Greetings  @hchanana,

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

 

H
hchanana16-Pearl
16-Pearl
May 2, 2018

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

Terms & ConditionsAccessibility statement