Oracle 9i GMT dates

Oracle made it too easy, here's the test code producing desired results:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.util.Calendar;
import java.util.TimeZone;
import java.sql.ResultSet;

public class TestOracleDate{
  
  public static void main(String[] args){

    SQLException exception = null;
    Connection con = null;
    String connectionString = "jdbc:oracle:thin:@testbox:imstest";
    String user = "testuser";
    String password = "testpassword";
    String database = "testdb";
    String uuid="c93d4654-40c2-11da";
    String identifier="hoser date test";
    String driverClassName="oracle.jdbc.driver.OracleDriver";

    try{
      Class.forName(driverClassName).newInstance();
    }catch(Exception ex){ex.printStackTrace();}
    try{
      con = DriverManager.getConnection(connectionString,user,password);
      String insertString = "INSERT INTO TEST_TABLE (cmn_rswd_identifier,cmn_rswd_statusid,cmn_rswd_mdate,cmn_rswd_cdate,cmn_rswd_uuid) VALUES ('"+identifier+"',1,?,?,'"+uuid+"')";
      String deleteString = "DELETE FROM CMN_RESERVED_WORD where cmn_rswd_identifier='"+identifier+"'";
      //insert = con.createStatement();
      final PreparedStatement insert = con.prepareStatement(insertString);
      final PreparedStatement delete = con.prepareStatement(deleteString);
      System.out.println("executing: " + deleteString);
      delete.executeUpdate();
      System.out.println("executing: " + insertString);
      TimeZone GMT = TimeZone.getTimeZone("GMT-00:00");
      TimeZone MST = TimeZone.getTimeZone("MST7MDT");
      System.out.println("First timestamp param, using :" + GMT.getID());
      System.out.println("First timestamp param, using :" + MST.getID());      
      insert.setTimestamp(1,new Timestamp(System.currentTimeMillis()),Calendar.getInstance(GMT));
      insert.setTimestamp(2,new Timestamp(System.currentTimeMillis()),Calendar.getInstance(MST));
      
      insert.executeUpdate();

      String queryString = "SELECT * FROM CMN_RESERVED_WORD where cmn_rswd_uuid='"+uuid+"'";
      Statement query = con.createStatement();
      ResultSet rs = query.executeQuery(queryString);
      while(rs.next()){
        //System.out.println(rs);
        System.out.println("-----------------");
        System.out.println("cmn_rswd_mdate (positional param 1) " + rs.getTimestamp("cmn_rswd_mdate"));
        System.out.println("cmn_rswd_cdate (positional param 2) " + rs.getTimestamp("cmn_rswd_cdate"));
        System.out.println("-----------------");
      }
      
    }
    catch(SQLException ex){
      ex.printStackTrace();
    }
    catch  (Exception e) {
      throw new RuntimeException(e.getMessage());
    }
    finally{
      try{
        if(con != null) con.close();
      }catch(Exception ex){ex.printStackTrace();}
    }
  }
}

Sources:
http://www.oracle.com/technology/products/oracle9i/htdocs/9iober2/obe9ir2/obe-nls/html/datetime/datetime.htm

http://www.dbasupport.com/oracle/ora9i/TimeZone.shtml