[NETBEANS-2298] Incorrect JDBC URL when using MySQL 8

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 8.2, 9.0, 10.0, 11.0
• Fix Version/s: 11.2
• Labels: pull-request-available

Environment

Observed on Windows and Mac.

• Assignee: John McDonnell
• Reporter: Kenneth Fogel
• Created: 22/Mar/19 19:14
• Updated: 03/Nov/20 15:47
• Resolved: 22/Feb/20 16:53

Description

More an annoyance than a real bug. Currently the JDBC URL appears as:

jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull

However, if using MySQL 8 with its matching driver it must be:

jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=CONVERT_TO_NULL

Issue Links

• relates to: NETBEANS-2418 Upgrade NetBeans MySQL suggested driver
• links to: GitHub Pull Request #1202