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 ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
