Re: [libreoffice-users] Value '0000-00-00' can not be represented as java.sql.Date

receiver wrote:
> I'm trying to create a LibreOffice (3.6.4) Base document which utilizes 
> a MySQL database.  I have installed the MySQL Connector J (5.1.22) and 
> have good results with one significant exception.  The subject error 
> prevents display of a table which does contain dates. I suspect that 
> this may be a problem with the JDBC connector and have reported it here 
> <http://forums.mysql.com/read.php?39,576155,576155#msg-576155>, however 
> it also seems possible that this is caused by LibreOffice Base.
>
> Any advice on what I may have overlooked would be appreciated.
>
> David ...
>
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Value-0000-00-00-can-not-be-represented-as-java-sql-Date-tp4024569.html
> Sent from the Users mailing list archive at Nabble.com.
>   
David,
Try this:
Edit -> Database -> Properties
Select the "Advanced Properties" tab.
Under "Name of the MySQL database", enter:

<database_name>?zeroDateTimeBehavior=convertToNull

where <database_name> is the name of your database.  No spaces anywhere.
Then click OK.

You may have to close and reopen LO/Base for this to take effect.  This 
is the string that LO/Base passes to the MySQL connector to open the 
database.

I had the same problem with zero dates and times when I read about this 
workaround years ago.  I was not sure if it is still a problem with the 
later versions, but it sounds like it is by your posting.
LO 3.5.7.2, MySQL 5.0.67, mysql-connector-java-5.0.7

Hope this helps.
Girvin Herr


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted