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

No, my users will gain access by having Internet access.  The database 
is to be located on a hosting service which offers MySQL Server.  I'm 
thinking this is what you might mean when saying "1 single database 
back-end".  My users will not be updating the database.  Rather they are 
using it to pull reports from a database that I am updating.  I plan to 
author the reports which may get updated/revised/extended from time to 
time and then redistributed to them in the form of new .odb files.

David ...

-------- Original Message --------
Subject:        Re: Fwd: Re: [libreoffice-users] Value '0000-00-00' can not be 
represented as java.sql.Date
Date:   Sun, 16 Dec 2012 14:59:50 +0000 (GMT)
From:   Tom Davies <tomdavies04@yahoo.co.uk>
Reply-To:       Tom Davies <tomdavies04@yahoo.co.uk>
To:     receiver <receiver@gowdygroup.net>, "users@global.libreoffice.org" 
<users@global.libreoffice.org>



Hi :)
Are all the community of users on the same Local Area Network, such as a 
compnay network or something?  If so it might be better to have 1 single 
database back-end (with all the data in it) held centrally and just send 
the users the Base front-end.

Your current plan creates a duplicate set of data for each user which 
they will presumably each add to independantly.  Would their updates 
need to be synchronised again later and then make each independant 
locally held copy up-to-date with everyone's updates?  If so then a 
single centrally held copy of the data would avoid a lot of the syncing 
trouble.  It's not always possible to have a centrally held copy of course.
Regards from
Tom :)


    ------------------------------------------------------------------------
    *From:* receiver <receiver@gowdygroup.net>
    *To:* users@global.libreoffice.org
    *Sent:* Sunday, 16 December 2012, 1:49
    *Subject:* Fwd: Re: [libreoffice-users] Value '0000-00-00' can not
    be represented as java.sql.Date

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

    -------- Original Message --------
    Subject:     Re: [libreoffice-users] Value '0000-00-00' can not be
    represented as java.sql.Date
    Date:     Sat, 15 Dec 2012 17:54:39 -0500
    From:     Jay Lozier <jslozier@gmail.com <mailto:jslozier@gmail.com>>
    To: users@global.libreoffice.org <mailto:users@global.libreoffice.org>



    On 12/15/2012 04:03 PM, 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 ...
     >
    David,

    What OS are you using? You might find an alternate connector at
    http://dev.mysql.com/downloads/connector/ that will work. I would try
    the ODBC connector for your OS.

    Jay

    -- 
    Jay Lozier
    jslozier@gmail.com <mailto:jslozier@gmail.com>


    -- 
    For unsubscribe instructions e-mail to:
    users+help@global.libreoffice.org <mailto: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







    --
    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-tp4024588.html
    Sent from the Users mailing list archive at Nabble.com.
    -- 
    For unsubscribe instructions e-mail to:
    users+help@global.libreoffice.org <mailto: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









--
View this message in context: 
http://nabble.documentfoundation.org/Fwd-Re-Fwd-Re-libreoffice-users-Value-0000-00-00-can-not-be-represented-as-java-sql-Date-tp4024687.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