Skip to main content
Timo69713-Aquamarine
13-Aquamarine
Sep 24, 2018 7:26 PM UTC
Solved

Unable to communicate using the MySQL v8.0.12 JDBC driver

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?

This topic has been closed for replies.
posipovaAnswer
20-Turquoise
Oct 1, 2018 2:18 PM UTC

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.

View in thread

3 replies

posipova20-Turquoise
20-Turquoise
Oct 1, 2018 1:04 PM UTC

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.

 

 

Translate
Timo69713-AquamarineAuthor
13-Aquamarine
Oct 1, 2018 1:42 PM UTC

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.

 

 

Translate
posipova20-TurquoiseAnswer
20-Turquoise
Oct 1, 2018 2:18 PM UTC

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.

Translate
Terms & ConditionsAccessibility statement