Error when date field is null

I am seeing errors in DBVisualizer (nothing stopping things from working) when my date fields are set to null (allowed in my schema). DB is Mysql 5.1.65 and the field is defined as date (not date-time) Error showing in the client is java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date Connection info is Product: DbVisualizer Pro 9.0.5 Build: #1924 (2013/03/05 13:16) Java VM: Java HotSpot(TM) 64-Bit Server VM Java Version: 1.7.0_17 Java Vendor: Oracle Corporation OS Name: Windows 7 OS Arch: amd64 OS Version: 6.1 Current profile: mysql Current facade: mysql MySQL 5.1.65-log MySQL-AB JDBC Driver mysql-connector-java-5.1.21 ( Revision: ${bzr.revision-id} )

Hi Doug, Are you sure the value is null? The message should only be displayed when the value is all zeros. Anyway, you can try setting the "zeroDateTimeBehavior" driver property to "convertToNull" in the Properties tab for the connection. See this page for details about the property: http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html Best Regards, Hans

Thanks Hans, Yes I am sure, Here is a screen shot of the output I was seeing before setting the property (changing it fixed the issue). Thanks again

Hi Doug, Glad to hear it solved the problem. Just note that the value is shown as null in the grid even if it's all zeros because of the exception, so you can't tell from the screenshot. Best Regards, Hans