Unable to communicate using the MySQL v8.0.12 JDBC driver

[Timo697]

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?

[posipova]

Please refer to the helpcenter configuration examples:

http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx%2FHelp%2FExtensibility%2FJDBCExtension%2FJDBCConfigurationExamples.html%23

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.

[Timo697]

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.

[posipova · Accepted solution]

If it's working with a different jdbc driver, then it's likely the driver issue. Unfortunately, nothing we can do from the platform side.