Databases
StackOverflow2013
Postsdbo
POIs there a Problem with JPA Entities, Oracle 10g and Calendar Type properties?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIs there a Problem with JPA Entities, Oracle 10g and Calendar Type properties?
    primarykey
    data
    text
    <p>I'm experiencing the following very annoying behaviour when using JPA entitys in conjunction with Oracle 10g. </p> <p>Suppose you have the following entity.</p> <pre><code>@Entity @Table(name = "T_Order") public class TOrder implements Serializable { private static final long serialVersionUID = 2235742302377173533L; @Id @GeneratedValue(strategy = GenerationType.AUTO) private Integer id; @Column(name = "activationDate") private Calendar activationDate; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Calendar getActivationDate() { return activationDate; } public void setActivationDate(Calendar activationDate) { this.activationDate = activationDate; } } </code></pre> <p>This entity is mapped to Oracle 10g, so in the DB there will be a table T_ORDER with a primary key NUMBER column "ID" and a TIMESTAMP column "activationDate".</p> <p>Lets suppose I create an instance of this class with the activation date "15. Sep 2008 00:00AM". My local timezone is CEST which is GMT+02:00. When I persist this object and select the data from the table T_ORDER using sqlplus, I find out that in the table actually "14. Sep 2008 22:00" is stored, which is ok so far, because the oracle db timezone is GMT.</p> <p>But now the annoying part. When I read this entity back into my JAVA program, I find out that the oracle time zone is ignored and I get "14. Sep 2008 22:00 CEST", which is definitly wrong. </p> <p>So basically, when writing to the DB the timezone information will be used, when reading it will be ignored.</p> <p>Is there any solution for this out there? The most simple solution I guess would be to set the oracle dbs timezone to GMT+02, but unfortunatly I can't do this because there are other applications using the same server.</p> <p>We use the following technology</p> <p>MyEclipse 6.5 JPA with Hibernate 3.2 Oracle 10g thin JDBC Driver</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. UShuo73
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIs there a Problem with JPA Entities, Oracle 10g and Calendar Type properties?
      1. USdshaw
      1. VTFavorite
    2. VO
      singulars
      1. POIs there a Problem with JPA Entities, Oracle 10g and Calendar Type properties?
      1. USArjan
      1. VTFavorite
    3. VO
      singulars
      1. POIs there a Problem with JPA Entities, Oracle 10g and Calendar Type properties?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload