Skip to main content
T
Timo69713-Aquamarine
13-Aquamarine
September 24, 2018
Solved

Unable to communicate using the MySQL v8.0.12 JDBC driver

  • September 24, 2018
  • 3 replies
  • 1908 views

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.
Best answer by posipova

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.

3 replies

P
posipova20-Turquoise
20-Turquoise
October 1, 2018

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.

 

 

T
Timo69713-AquamarineAuthor
13-Aquamarine
October 1, 2018

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.

 

 

P
posipova20-TurquoiseAnswer
20-Turquoise
October 1, 2018

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.

Terms & ConditionsAccessibility statement