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

Summary:	Error when displaying MySQL table with nulls in datetime column
Product:	db	Reporter:	giorgio42 <giorgio42>
Component:	Code	Assignee:	Andrei Badea <abadea>
Status:	RESOLVED DUPLICATE
Severity:	blocker
Priority:	P3
Version:	5.x
Hardware:	PC
OS:	All
Issue Type:	DEFECT	Exception Reporter:

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 ***