Re: [libreoffice-users] JDBC params - the J "null date" problem

2015-02-02 Thread Mark Stanton
In article <54cf6b6e.6030...@aon.at>, Heinrich Stöllinger wrote: > Also - one obviously specify MORE than just ONE parameter in the connection > string, such as > dbname?autoReconnect=true&zeroDateTimeBehavior=convertToNull > Heinrich > Alex Thurgood schrieb: > > The way is to add the parameter in

[libreoffice-users] JDBC params - the J "null date" problem

2015-02-02 Thread Mark Stanton
I'm accessing a MariaDb (howzatt Tom? ;-) ) database through a JDBC connection on Linux (the native connector doesn't work, not sure why, yet). When accessing a datetime column with some rows set to '-00-00 00:00:00' Base complains and refuses due to this being an invalid (js) date. I note