datetime / timezone (mysql jdbc) issues
datetime / timezone (mysql jdbc) issues
- Subject: datetime / timezone (mysql jdbc) issues
- From: Lachlan Deck <email@hidden>
- Date: Thu, 11 Feb 2010 16:49:41 +1100
Hi all,
I've been debugging a problem we've got where the fetched timestamp is 1 hour out for times that fall after (or close after) the date when day light savings comes off.
Viewing the data in mysql the times are correct for Sydney (unfortunately the deployment db is not in UTC but Australia/Sydney time... out of my hands). When fetching a list of records all of them have the same endTimestamp value .. but once we have an NSTimestamp the last record which falls over the boundary is wrong.
So I experimented by created another field on the entity which maps to the same external field (as a read-only field) and utilising a custom class (ISHDate) with factory method 'parseDate(String)' to see what's coming in... and it's wrong there too.
I've played with various mysql jconnector params to see what happens.
...&zeroDateTimeBehavior=convertToNull
...&useGmtMillisForDatetimes=true
...&useTimezone=true&serverTimezone=Australia/Sydney
...&useLegacyDatetimeCode=true
And I've updated all the zoneinfo stuff to the latest on my system and in all the jars/frameworks. Still no good.
Further suggestions?
Cheers.
with regards,
--
Lachlan Deck
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden