Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

pstein-JavaNetSep 24 2018 — edited Oct 24 2018

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 21 2018
Added on Sep 24 2018
6 comments
2,499 views