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

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 
'0000-00-00 00:00:00' Base complains and refuses due to this being an 
invalid (js) date.

I note from a quick search that this is a well known problem. There 
are some solutions involving to the JDBC connector load string, which 
seems to not be accessible from Base. Is that a good idea?

The only solution that I've found involves casting the field to a 
string. It works, but I'd prefer not to have to.

Is there something I've missed?

Mark Stanton
One small step for mankind...



-- 
To unsubscribe e-mail to: users+unsubscribe@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