0 Replies Latest reply on Aug 11, 2003 10:32 AM by clemper

    Storing GMT dates using CMP

    clemper

      Hi,

      Is there any way to store a GMT date in Oracle (or any database) using CMP? The CMP layer seems to want to store all dates (either java.sql.Date or java.util.Date) in the local time zone of the VM (or the timezone indicated by the "user.timezone" property). Basically, I need the CMP layer to call the JDBC Statement.setDate(Date, Calendar) method when setting dates, and to be able to indicate the desired timezone (i.e. GMT) for the Calendar object. Any help would be appreciated.

      Thanks!
      clemper