> If it's MySQL your jdbc connection url should probably have: > ....?zeroDateTimeBehavior=convertToNull WOW! that worked! Thanks a lot!
2009/3/17 Lachlan Deck <lachlan.d...@gmail.com>: > On 18/03/2009, at 4:48 AM, Gennady Kushnir wrote: > >> Hello list. >> Is there some known hint to get rid with exception raised when dealing >> with zero dates in SQL? >> I'm taking data from database maintained with a third party program. > > What type of database? > >> When a date is undefined that program puts "0000-00-00" into database >> which is acceptable for SQL but raises an exception in WO. >> How can I make EOF treat that value normally returning null for date >> in corresponding EnterpriseObject? > > If it's MySQL your jdbc connection url should probably have: > ....?zeroDateTimeBehavior=convertToNull > > with regards, > -- > > Lachlan Deck > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
