Time Differences between linux & windows in my Java App

MRMadhav · 05-06-2006, 06:25 AM

Hi everybody!
I am getting a big problem in java. I have a client computer in windows and a linux server. No my problem is that when i run the same application in linux and in linux there seem to be a problem with the time. In windows the time is 1 hour backwards. E.g.

if the my windows sytem time is 13:15:20
the java app returns 12:15:20

but i don't get this problem when running in linux, the time is displayed correctly.

Here is my code:

Code:

//TimeTest.java
import java.awt.*;
import java.sql.*;

public class TimeTest
{
    public static void main(String[] args)
    {
         Time t = new Time(System.currentTimeMillis());
         System.out.println("Current Time is "+t.toString());
    }
}

As you can see I am using java.sql.Time which is convinient for portability to MySQL.
Does someone knows how to correct this problem?

mrcheeks · 05-06-2006, 07:58 AM

Is your timezone configured correctly? Does the time looks ok in linux(the clock in gnome or kde)?

MRMadhav · 05-08-2006, 03:19 AM

Sorry I made a typing mistake in my first post should have said:

Quote:

my problem is that when i run the same application in linux and in windows, the time is different though the timezone and time is the same in both machines.

In linux the time is ok. My timezone is indian/mauritius and i don't use UTC. The problem is with windows, over here the timezone is +4GMT and daylight savings is enabled(Though i have tried all the other timezones and also tried without the daylight savings). The problem is that in windows the time displayed in my java app is always 1hr less than the system time. This would not have been a problem but as i use Auditing in my applications this 1hr lag can cause much problems. Didn't anyone get this type of problem before?

thermite_1033 · 05-08-2006, 01:22 PM

use the time of the sql server instead
you're just auditing so this will suffice

insert into audit(timeOfDay,auditmessage) value(now(),'barfoo');

MRMadhav · 05-09-2006, 04:21 AM

Ok thanks for your help! That's a very useful feature in MySQL which i didn't even know existed!