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