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

It works!!!  The fact that this rather ugly bit of coding is confined to 
the .odb file is the good news.  It can be out of sight and out of mind 
for my technically challenged end user community.

Many thanks for a pretty useful tip.

For the record I'm testing with LO Base 3.6.4, MySQL Connector J 
5.1.22,  MySQL Server 5.5.16

David ...

On 12/15/2012 6:10 PM, Girvin R. Herr wrote:
> 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




--
View this message in context: 
http://nabble.documentfoundation.org/Fwd-Re-libreoffice-users-Value-0000-00-00-can-not-be-represented-as-java-sql-Date-tp4024589.html
Sent from the Users mailing list archive at Nabble.com.
-- 
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