After installing the jdbc driver in ThingWorx, I could not get it to communicate with the MySQL server. I set up the string settings the same as other MySQL versions.
- JDBC Driver Class Name: com.mysql.jdbc.Driver
- JDBC Connection String: jdbc:mysql://localhost:3306/test
- connectionValidationString: SELECT NOW()
Has anyone else run into this issue? If so, what was your solution?
Solved! Go to Solution.
Please refer to the helpcenter configuration examples:
What is the error you are getting when trying to connect right now? Application Log (found in Thingworx Storage/logs folder) would contain more details.
There is no error displayed in the application log. It installed fine. It just won't connect. That being said, I did get an error message when I created a sql query service and tried to browse the tables.
Error Getting Tables : The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable.
When I use an earlier JDBC driver (mysql-connector-java-5.1.47.jar), it connects just fine using the same connection strings mentioned earlier.