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

2015-02-02 Thread Heinrich Stöllinger

Also - one obviously specify MORE than just ONE parameter in the connection
string, such as
dbname?autoReconnect=truezeroDateTimeBehavior=convertToNull
Heinrich
Alex Thurgood schrieb:

Le 02/02/2015 12:34, Mark Stanton a écrit :

  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 way is to add the parameter in the field where you specify which
database to connect to :

nameofmydb?zeroDateTimeBehavior=convertToNull



Alex





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



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

2015-02-02 Thread Alex Thurgood
Le 02/02/2015 12:34, Mark Stanton a écrit :

 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 way is to add the parameter in the field where you specify which
database to connect to :

nameofmydb?zeroDateTimeBehavior=convertToNull



Alex


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