Hi Steve,

My name is Mark Piermarini and I work for Tom Kyte. He asked me to finish helping you with this problem. I see the environment variable "user.region" is set to "US" -- I will look into that more. For now, I wrote some Java to set the default timezone for JVM session. It has to be called but only once. It will either take a valid named time zone like 'Australia/Sydney' or an offset from GMT. It will also set the default based on the session time from the database. Can you load the java class and PL/SQL package and then test to see if it works for you? Bug 2124255 is closely related to this problem. Below I listed the source code and a test run.
============================================================
create or replace and compile java source named "TZ_Stuff" as
import java.sql.*;
import java.util.*;
import oracle.jdbc.driver.OracleDriver;

// Set the default JVM timezone to be either a user-defined value or a
// value that is retrieved from the database session time zone. One of
// the setDefault() methods should be called before any Java time zone
// work is done and it only needs to be executed once for a JVM. All
// methods are exposed in the PL/SQL wrapper package. list() method
// will show all valid named time zones.
//
// Bug 2124255 in the Oracle Metalink is similar problem.
//
public class TZ_Stuff {

public static void list() {
String[] ids = TimeZone.getAvailableIDs();
for (int i = 0; i < ids.length; i++) {
System.out.println(ids[i]);
}
}

// Accept a time zone in the form of "Australia/Sydney" or
// "GMT[|-]hh[[:]mm]". Using a custom time zone might have
// implications on daylight savings. This method is not exhaustive
// in its' error and input handling. There is a debug message
// displayed which can be removed.
public static void setDefault(String tz) {
String theTZ = tz;

// If the string starts with a plus or minus sign then the caller
// is using a raw offset so prefix with GMT.
if (tz.startsWith("+") || tz.startsWith("-")) {
theTZ = "GMT" + tz;
}

// Now set the default timezone
System.out.println("NEW DEFAULT TZ = " + TimeZone.getTimeZone(theTZ));
TimeZone.setDefault(TimeZone.getTimeZone(theTZ));
}

// Find the value from the database and set it to the default. Only
// execute this once so we do not bother keeping the connection or
// caching a prepared statement. Or anything for that matter.
public static void setDefault() throws Exception {
Connection c = new OracleDriver().defaultConnection();
Statement s = c.createStatement();
ResultSet rs = s.executeQuery("select sessiontimezone from dual");
while (rs.next()) {
setDefault(rs.getString(1));
}

rs.close();
s.close();
c.close();
}
}
/
show errors

create or replace package tz_stuff as
procedure list as
language java name 'TZ_Stuff.list()';

procedure sync_1 as
language java name 'TZ_Stuff.setDefault()';

procedure sync_2(p_time_zone in varchar2) as
language java name 'TZ_Stuff.setDefault(java.lang.String)';
end;
/
show errors

exec tz_stuff.list
exec tz_stuff.sync_2('Australia/Sydney')


-- -------------------------------------------------------------
-- -- This is your code....
-- -------------------------------------------------------------
create or replace and compile java source named JTime as
public class JTime {
public static void ShowDate() {
java.util.Date dt = new java.util.Date ();
java.util.TimeZone tz = java.util.TimeZone.getDefault ();
System.out.println ("dt = " + dt);
System.out.println ("tz = " + tz);
}
}
/

create or replace procedure JTime
is language java name 'JTime.ShowDate()';
/

set serveroutput on size 1000000
exec dbms_java.set_output (1000000);
begin
JTime;
dbms_output.put_line (
'Sysdate = ' ||
to_char (sysdate, 'YYYY-Mon-DD HH24:MI:SS'));
end;
/

============================================================
============================================================

Could you run this:


create or replace and compile java source named "props" as
public class props {
public static void show_props() {
System.getProperties().list(System.out);
}
}
/
show errors
create or replace procedure java_props
as language java name 'props.show_props()';
/
show errors
set serveroutput on size 10000
exec dbms_java.set_output(10000)
exec java_props


and let us know what it says...