6 Replies Latest reply on Oct 24, 2018 5:05 AM by Gaz in Oz

    mysql-connector-java-8.0.12.jar does NOT work with MySQL v5.7.22 and SQLDev 8.2: zeroDateTimeBehavior issue

    pstein-JavaNet

      I can successfully access (under Windows7)  a MySQL v5.7.22 from SQL Developer v8.2.0 with MySQL Connector mysql-connector-java-5.1.47.jar and Java version v1.8.0_181

       

      Then I downloaded the newest MySQL Connector v8.0.12 and added "mysql-connector-java-8.0.12.jar" (at the topmost position) in

       

      Preferences--->Database--->ThirdParty JDBC Drivers

       

      When I now try to connect to the same Database I got an error popup telling me:

       

      "An error was encountered performing the requested operation:

      The connection property 'zeroDateTimeBehavior acceptable values are 'CONVERT_TO_NULL','EXCEPTION' or 'ROUND'.

      The value 'convertToNull' is not acceptable

       

      Whats wrong?

       

      How can I fix this?

       

      According to docs the (new) v8 Connector should be downwards compatible with v5 MySQL DBs. Other tools can use it without problems. Only SQL Developer seems to have problems.

       

      Peter