java udr datetime problem

Posted in 2009

STEVEN WEISS — Mon, 23 Mar 2009 06:41:34 — source: IIUG Forums & Mailing Lists

Hi, Ive got a Java UDR that tries to insert a row with a datetime column. e.g. java.sql.Timestamp = new Timstamp(Calendar.getTimeInMillis()); The datetime is coming back incorrectly in the inserted row. It comes back for the GMT timezone when my default is actually Central Africa (Africa/Harare). I've tested the logic outside the UDR using the same J/Foundation JRE (1.4.2 SR7) and get the same problem. I however do not get the problem using a SUN JRE 1.5+. I've also tried loading JTZU Version 1.6.8i patch with no success. Can anyone can shed some light on this? Regards Steven