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 Sep 24, 2018 4:31 AM

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

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

Gaz in Oz Sep 24, 2018 10:39 AM (in response to pstein-JavaNet)

There are a couple of suggestions you can try, mentioned here:
Connecting to MySQL 8.0
. Tinker with the serverTimeZone setting, setting it to "+00:00"
. Setup an Advanced connection, and use a URL like this, for example:
jdbc:mysql://localhost:3306/<databasename>?zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=UTC
substituting localhost:3306/<databasename> with your specific database connectivity...
1 person found this helpful
Like Show 0 Likes(0)

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

pstein-JavaNet Oct 17, 2018 3:53 AM (in response to Gaz in Oz)

@Gaz in Oz:

Thank you for the hint.

BUT: Where exactly do I have to add the new part of the connection string?

An "Advanced" connection type as you suggested is only possible for Oracle DBs and NOT for MySQL DBs

Can I switch an existing Basic (MySQL) connection later into an advanced (MySQL) connection or do I have to setup it again from scratch?

Peter
Like Show 0 Likes(0)

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

thatJeffSmith-Oracle Oct 17, 2018 7:23 AM (in response to pstein-JavaNet)

You can use the advanced connection type for a MySQL connection string
Like Show 0 Likes(0)

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

pstein-JavaNet Oct 23, 2018 6:50 PM (in response to thatJeffSmith-Oracle)

There is NO Advanced connection type for MySQL (only for Oracle).

So again: How do I create an "advanced" connection otherwise?
Like Show 0 Likes(0)

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

thatJeffSmith-Oracle Oct 23, 2018 7:20 PM (in response to pstein-JavaNet)

You use the Oracle advanced connection type and put in a MySQL jdbc url
Like Show 0 Likes(0)

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

Gaz in Oz Oct 24, 2018 5:05 AM (in response to thatJeffSmith-Oracle)

Please post an example of the Oracle Advanced connection with a jdbc:mysql URL, working. I have tried with no success in getting that method to work.
For example in SQL Developer 18.3.0.277.2354 Connections -> Oracle -> Advanced both these formats fail:
jdbc:mysql://192.168.1.8:3306/mysql
jdbc:mysql:@//192.168.1.8:3306/mysql
Result in
When pressing the Test button.
Like Show 0 Likes(0)

Actions

Go to original post