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.

Bug 72703 - Error when displaying MySQL table with nulls in datetime column
Summary: Error when displaying MySQL table with nulls in datetime column
Status: RESOLVED DUPLICATE of bug 71698
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: PC All
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-02-15 22:17 UTC by giorgio42
Modified: 2006-02-16 11:16 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description giorgio42 2006-02-15 22:17:16 UTC 
Using MySQL 5.0 and JDBC driver 3.1.12 I get an error message: "Cannot convert
0000-00-00 00:00:00 from column x to TIMESTAMP", if there are nulls in this
column (displaying the data of the same table works without problems in
DbVisualizer, which is alsow JDBC-based).

Georg
Comment 1 Andrei Badea 2006-02-16 09:43:12 UTC 
Looks like duplicate of issue 71698, please verify or reopen.
Comment 2 Andrei Badea 2006-02-16 11:16:25 UTC 
Marking as duplicate of issue 71698.

*** This issue has been marked as a duplicate of 71698 ***