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

On 12/15/2012 05:49 PM, receiver wrote:
> Yes, that was something that naturally came to mind so I did try it and 
> it does solve the problem of the zero valued date.  However, my 
> objective is to develop a database file (i.e., .odb) that I can send to 
> a community of users who may lack the technical savvy to wrestle with 
> prerequisite setup requirements.  In this sense ODBC is a bit of a 
> beast.  It seems to rely on something that Windows refers to as data 
> sources which are external to the .odb file.  There are lots of options 
> which would make one think that it should be possible to invest in some 
> extra work when creating the .odb file that makes life simpler for the 
> technically challenged community of users. However, I wasn't able to 
> achieve such a result.  In fact it appears as though LibreOffice Base 
> does not even allow the use of what Windows calls the file type of data 
> source.
>
> Both ODBC and JDBC require my users to have connectors installed.  I 
> haven't yet determined that JDBC is good enough to solve the problem, of 
> having my users know about server connections, but it does look like 
> more of the database (i.e., MySQL server) connection specific setup is 
> confined to the .odb file.  This is why I'd like to make JDBC work.  
> Insofar as zero valued dates seem to be quite natural for a MySQL 
> database one would think that the MySQL supplied Connector J could deal 
> with such more elegantly.
>
> David ...
...

...

This works for me:
<http://extensions.services.openoffice.org/en/project/aoo-my-sdbc>

May be of interest as your error isn't just a Base problem
:
<http://openoffice.2283327.n4.nabble.com/Base-collapsing-on-MySQL-date-td2787416.html>

<http://docs.oracle.com/cd/E17952_01/refman-5.0-en/cj-news-5-1-11.html>
====
 With the connection string option noDatetimeStringSync set to true, and
server-side prepared statements enabled, the following exception was
generated if an attempt was made to obtain, using ResultSet.getString(),
a datetime value containing all zero components:

java.sql.SQLException: Value '0000-00-00' can not be represented as
java.sql.Date

(Bug #32525)
====
<http://bugs.mysql.com/bug.php?id=32525>


<https://duckduckgo.com/?q=+%22Value+%270000-00-00%27+can+not+be+represented+as+java.sql.Date%22>
<http://www.openkb.org/mysql-error-javasqlsqlexception-value-0000-00-00/>
<https://duckduckgo.com/?q=5.1.22+%22Value+%270000-00-00%27+can+not+be+represented+as+java.sql.Date%22?






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