Problems since new Daylight Savings Time

[Former Member]

When running a Historical Tag Query on InSQL, the datetime stamp comes up in the result data showing one hour behind.

The server that xMii is running on is on the correct time.

The server that InSQL is running on is the correct time.

When monitoring query through SQL Profiler, it also shows that the request is for one hour earlier.

Could this be related to the Applet? Or to java?

[salvatore_castro]

Ken,

The problem lies inthe underlying Java API and can be fixed by upgrading to Java 1.4.2_13. Also, be sure that you are running the SR03 release of xMII, 11.5.3.

-Sam Castro

[Former Member]

Ken,

We had to tell the JVM explicitly what timezone to use.

I.e. in the StartServletExec.bat file we added a switch similar to:

-Duser.timezone=GMT+9

Then changed it back to +8 when daylight saving finished, or removing the switch completely.

+8 and +9 were for Western Australia, I'm not sure where you are and what your offset would be.

Note: ServletExec would need to be restarted for these changes to take effect.

Hope this helps.

Regards,

Matt Tuohy

[Former Member]

Hi Ken,

What version of Java are you running? You might want to look into getting a DST-patched version. For more information please see this article:

<a href="http://java.sun.com/developer/technicalArticles/Intl/USDST/">DST Patch for Java</a>