If using postgres, you need to set the time zone before the driver loads as
well. Something like this in your application class should do
public class Application extends ERXApplication {
private static Logger log = Logger.getLogger(Application.class);
static {
// Set default time zones
TimeZone.setDefault(TimeZone.getTimeZone("GMT"));
NSTimeZone.setDefaultTimeZone(NSTimeZone.getGMT());
}
public static void main(String argv[]) {
ERXApplication.main(argv, Application.class);
}
Ramsey
On Aug 16, 2012, at 10:17 AM, WebObjects TORAcom wrote:
> Hi Jesse,
>
> The problem we got with postgresql was in the period of time day light time
> in U.S. begins because in Mexico begins later.
>
> We found the datetimes stored in our database with a one hour offset during
> that period, once daylight begins in Mexico everything gets normal . The
> server timezone was correct (America / Mexico City) but for one reason time
> zone in postgres was Chicago (or something else).
>
> I am not sure if this is your case.
>
> Hope this helps.
>
>
> On 16/08/2012, at 11:27, Jesse Tayler <[email protected]> wrote:
>
>>
>> If my app output logs report the correct time, which they do:
>>
>> Aug 16 12:21:17 WOMan[2002] DEBUG NSLog - === Commit Internal
>> Transaction
>>
>> then, WO / Java have a correct timezone too.
>>
>> therefore, this must be mysql?
>>
>>
>>
>> On Aug 16, 2012, at 12:04 PM, Jesse Tayler <[email protected]> wrote:
>>
>>> oh, that might be the trouble -- I didn't think about the database encoding.
>>>
>>> I'm using mysql, but I checked the db properties and found UTC?
>>>
>>> My server is EDT, or easter with daylight savings, for NYC. Unix reports
>>> Thu Aug 16 12:03:04 EDT 2012
>>>
>>> Should this be set to EDT? UTC is GMT right? That would be more like 8
>>> hours off, no?
>>>
>>> Anyone know how Mysql should get setup or if this is ok?
>>>
>>> thanks!
>>>
>>> <Screen Shot 2012-08-16 at 11.59.39 AM.png>
>>>
>>> On Aug 16, 2012, at 12:55 AM, WebObjects TORAcom <[email protected]> wrote:
>>>
>>>> Hi Jesse,
>>>>
>>>> The date with the problem is stored in a database?
>>>>
>>>> We got some problems with Postgresql. Date and timezone on server was ok
>>>> but not in postgres.
>>>>
>>>> We found this instruction:
>>>>
>>>> ALTER DATABASE postgres SET timezone to 'Mexico/General';
>>>>
>>>> That made the trick.
>>>>
>>>> Hope this helps.
>>>>
>>>> Miguel Torres.
>>>>
>>>> On 14/08/2012, at 11:29, Jesse Tayler <[email protected]> wrote:
>>>>
>>>>> My server time is off a suspicious negative one hour, which I presume to
>>>>> be a daylight savings problem.
>>>>>
>>>>> UNIX returns the date I expect.
>>>>>
>>>>> So, I'd guess this is a Java or WO settings issue?
>>>>>
>>>>> A long time ago, on a server far away,
>>>>>
>>>>> there were some issues with missing timezone files used by Java and
>>>>> installed by WO or vice versa?
>>>>>
>>>>> Does anyone know where best to find out what's responsible for the date
>>>>> being returned an hour off to my client?
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Do not post admin requests to the list. They will be ignored.
>>>>> Webobjects-dev mailing list ([email protected])
>>>>> Help/Unsubscribe/Update your Subscription:
>>>>> https://lists.apple.com/mailman/options/webobjects-dev/wo%40toracom.net
>>>>>
>>>>> This email sent to [email protected]
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list ([email protected])
>>> Help/Unsubscribe/Update your Subscription:
>>> https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.com
>>>
>>> This email sent to [email protected]
>>
>
>
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
