This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Summary: | SQL editor cannot display dates with value 0000-00-00 | ||
---|---|---|---|
Product: | db | Reporter: | dkkeen <dkkeen> |
Component: | MySQL | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED WONTFIX | ||
Severity: | blocker | CC: | rperazzo |
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | PC | ||
OS: | Linux | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
dkkeen
2009-02-26 10:02:38 UTC
It's a known problem in MySQL, need to set a special parameter in MySQL driver - http://bugs.mysql.com/bug.php?id=13261. With this parameter is works better. Please, use zeroDateTimeBehavior=convertToNull while connecting to your databse. E.g.: jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull *** Issue 157309 has been marked as a duplicate of this issue. *** *** Issue 175226 has been marked as a duplicate of this issue. *** Omg, thanks a lot. very obscured reason:-( I tried to update Connector/J on version 5.1.11 because on http://bugs.mysql.com/bug.php?id=13261 is info the patch is commited (from july 2008) but still not repaired:( Thanks for help especialy jskrivanek. Very good support. My first report here and I hope no last. NetBeans is fine tool:) -- podolinek *** Bug 193562 has been marked as a duplicate of this bug. *** The zeroDateTimeBehavior=convertToNull solution should be documented somewhere or be supplied as a connection / service-property option? The current template for mysql jdbc urls leads to this: jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull The mentioned parameter is now part of the default url. No need to add something by hand. FYI this was checked against a build of core-main from a few days ago. The problem is that it throwed an exception. Shouldn't it be handled more gracefully? |