java.sql.Date error
Posted by: David Gowdy
Date: December 15, 2012 10:05AM

I just installed the MySQL Connector J (Version 5.1.22). I then created a document using LibreOffice (Version 3.6.4) Base to connect to a MySQL database. My initial queries and reports work well with one exception. I receive an error which says, "Value '0000-00-00' can not be represented as java.sql.Date", when I attempt to display a table which does contain dates. It seems like having unknown dates is quite normal and MySQL should be able to store them as it chooses. If java wants them in a different form, which of course is irrelevant to a user of LibreOffice Base, then isn't it the purpose of the JDBC connector to handle that properly. The Base user trying to create queries and reports is not able to dictate how information is stored in the database.

Is this a bug in the connector, or possibly LibreOffice, or have I overlooked something?

Options: ReplyQuote


Subject
Written By
Posted
java.sql.Date error
December 15, 2012 10:05AM
December 16, 2012 01:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.