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: [email protected] 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
