blocks|key|342651|text|注释您的字段并更改类型会有所帮助：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|342652|@Temporal(TemporalType.TIMESTAMP)
private+java.util.Date+modifiedTimestamp;|code-block|syntax|javascript|342653|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Anotating your field and changing the type should help:

<pre><code>@Temporal(TemporalType.TIMESTAMP)
private java.util.Date modifiedTimestamp;
</code></pre>

blocks|key|558698|text|使用@Temporal(TemporalType.TIMESTAMP)+(Javadocs)。组合with+java.util.Date。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|558699|@Temporal(TemporalType.TIMESTAMP)
@Column(name+=+"DATE_FIELD")
private+java.util.Date+modifiedTimestamp;|code-block|syntax|javascript|558700|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/javaee/6/api/javax/persistence/TemporalType.html|1|http://docs.oracle.com/javase/7/docs/api/java/util/Date.html^0|2|X|11|8|0|1D|J|1|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@$9|X|A|Y|1|Z]|$9|10|A|11|1|12]]|E|$]]|$1|F|3|G|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]|S|$5|N|O|P|E|$Q|T]]]]

Use <code>@Temporal(TemporalType.TIMESTAMP)</code> (<a href="http://docs.oracle.com/javaee/6/api/javax/persistence/TemporalType.html" rel="noreferrer">Javadocs</a>). Combined <a href="http://docs.oracle.com/javase/7/docs/api/java/util/Date.html" rel="noreferrer">with java.util.Date</a>. 

<pre><code>@Temporal(TemporalType.TIMESTAMP)
@Column(name = "DATE_FIELD")
private java.util.Date modifiedTimestamp;
</code></pre>

blocks|key|342826|text|我发现这个问题在一段时间前就已经被问到了，所以我建议你读一读this的文章。在引入java+8日期类型之后，有一些变化。我知道这不是这个问题的答案，我遇到的问题也不一样，但我之所以发布这篇文章，是因为我在答案中看到的@Temporal()注释正在破坏我的CI管道：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|342827|这是可行的：|342828|@NotNull
@Column(nullable+=+false,+columnDefinition+=+"TIME")+//+this+bit+is+different
@JsonFormat(pattern="HH:mm")
private+LocalTime+startTime;|code-block|syntax|javascript|342829|这不是：|342830|@NotNull
@Column(nullable+=+false)
@Temporal(TemporalType.TIME)
@JsonFormat(pattern="HH:mm")
private+LocalTime+startTime;|342831|entityMap|0|LINK|mutability|MUTABLE|url|https://www.baeldung.com/jpa-java-time#after-java-8^0|30|B|U|4|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|6|7|14|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|15|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|16|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|17|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

I see this question has been asked a while ago so I'd suggest giving <a href="https://www.baeldung.com/jpa-java-time#after-java-8" rel="nofollow noreferrer">this</a> article a read. There are some changes after java 8 date types were introduced. I know it's not an answer to this question and the problem I had was different but I'm posting this because the <code>@Temporal()</code> annotation I saw in the answer was breaking my CI pipeline:
This works:
<pre class="lang-java prettyprint-override"><code>@NotNull
@Column(nullable = false, columnDefinition = &quot;TIME&quot;) // this bit is different
@JsonFormat(pattern=&quot;HH:mm&quot;)
private LocalTime startTime;
</code></pre>
This doesn't:
<pre class="lang-java prettyprint-override"><code>@NotNull
@Column(nullable = false)
@Temporal(TemporalType.TIME)
@JsonFormat(pattern=&quot;HH:mm&quot;)
private LocalTime startTime;
</code></pre>

blocks|key|342731|text|如果您将类型更改为java.sql.Timestamp，那么它也应该可以工作，而不需要添加@Temporal注释。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|342732|private+java.sql.Timestamp+modifiedTimestamp;+|code-block|syntax|javascript|342733|当然，在Oracle中将字段更改为时间戳。|342734|entityMap^0|9|I|19|9|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

If you change the type to <code>java.sql.Timestamp</code> then also it should work, without adding <code>@Temporal</code> annotaion.

<pre><code>private java.sql.Timestamp modifiedTimestamp; 
</code></pre>

Of course in Oracle change field to a TIMESTAMP.

blocks|key|558815|text|这就是我在Java、MySQL+db和OpenJPA2中处理日期时间字段的方式。我希望字段是一种java.util.Calendar类型，dbfield+datetime和dbvalue作为UTC值。Mysql对时区一无所知，因此使用自定义转换器可以设置和读取"yyyy-MM-dd+HH:mm:ss“字符串。仍然是它的有效datetime+sql列和实体bean中的java.util.Calendar。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|558816|@Entity+@Table(name="user")+@Access(AccessType.FIELD)
public+class+User+{
++++@Id+@GeneratedValue(strategy=GenerationType.IDENTITY)
++++private+long+id;++++//+primary+key+(autogen+surrogate)

++++private+String+name;

++++@Column(name="updated_utc")+//+use+custom+serializer+so+that+UTC-stringified
++++@Temporal(TemporalType.TIMESTAMP)+//+db+datetime+is+properly+set+to+calendar+instance
++++@Factory("JPAUtil.db2calendar")+@Externalizer("JPAUtil.calendar2db")
++++private+Calendar+updated;

++++public+long+getId()+{+return+id;+}
++++public+void+setId(long+id)+{+this.id+=+id;+}

++++public+String+getName()+{+return+name;+}
++++public+void+setName(String+name)+{+this.name=name;+}

++++public+Calendar+getUpdated()+{+return+updated;+}
++++public+void+setUpdated(Calendar+cal)+{+updated=cal;+}

}

-+-+-+

public+class+JPAUtil+{
++++public+static+final+TimeZone+TIMEZONE_UTC+=+TimeZone.getTimeZone("UTC");

++++public+static+String+calendar2db(Calendar+val,+StoreContext+ctx)+{
++++++++SimpleDateFormat+df+=+new+SimpleDateFormat("yyyy-MM-dd+HH:mm:ss");
++++++++df.setTimeZone(TIMEZONE_UTC);
++++++++return+df.format(cal.getTime());+//+return+date+as+UTC+string+value
++++}

++++public+static+Calendar+db2calendar(String+val,+StoreContext+ctx)+{
++++++++try+{
++++++++++++//+returned+calendar+is+using+a+default+timezone,+val+was+set+as+utc+string
++++++++++++return+DateUtil.parseDateTimeFromUTC(val);
++++++++}+catch+(Exception+ex)+{+
++++++++++++return+null;
++++++++}
++++}

}

-+-+-+

CREATE+TABLE+user+(
++id+bigint+NOT+NULL+auto_increment,
++name+varchar(64)+NOT+NULL+default+'',
++updated_utc+datetime+NOT+NULL,
++PRIMARY+KEY+(id),
++UNIQUE+KEY+USERNAME+(name)
)+ENGINE=InnoDB+DEFAULT+CHARSET=utf8+;|code-block|syntax|javascript|558817|ps:+DateUtil是我的随机工具类，用于提供一些基本的转换。|558818|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This is how I handle datetime field in Java, MySQL db and OpenJPA2. I want field to be a type of java.util.Calendar, dbfield datetime and dbvalue as UTC value. Mysql knows nothing about timezone so using a custom converter can set and read "yyyy-MM-dd HH:mm:ss" string. Still its valid datetime sql column and java.util.Calendar in entity bean.

<pre><code>@Entity @Table(name="user") @Access(AccessType.FIELD)
public class User {
 @Id @GeneratedValue(strategy=GenerationType.IDENTITY)
 private long id; // primary key (autogen surrogate)

 private String name;

 @Column(name="updated_utc") // use custom serializer so that UTC-stringified
 @Temporal(TemporalType.TIMESTAMP) // db datetime is properly set to calendar instance
 @Factory("JPAUtil.db2calendar") @Externalizer("JPAUtil.calendar2db")
 private Calendar updated;

 public long getId() { return id; }
 public void setId(long id) { this.id = id; }

 public String getName() { return name; }
 public void setName(String name) { this.name=name; }

 public Calendar getUpdated() { return updated; }
 public void setUpdated(Calendar cal) { updated=cal; }

}

- - - 

public class JPAUtil {
 public static final TimeZone TIMEZONE_UTC = TimeZone.getTimeZone("UTC");

 public static String calendar2db(Calendar val, StoreContext ctx) {
 SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
 df.setTimeZone(TIMEZONE_UTC);
 return df.format(cal.getTime()); // return date as UTC string value
 }

 public static Calendar db2calendar(String val, StoreContext ctx) {
 try {
 // returned calendar is using a default timezone, val was set as utc string
 return DateUtil.parseDateTimeFromUTC(val);
 } catch (Exception ex) { 
 return null;
 }
 }

}

- - - 

CREATE TABLE user (
 id bigint NOT NULL auto_increment,
 name varchar(64) NOT NULL default '',
 updated_utc datetime NOT NULL,
 PRIMARY KEY (id),
 UNIQUE KEY USERNAME (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
</code></pre>

ps: DateUtil is my random util class to provide some basic conversions.

I'm using WebSphere 7 (Java EE 5) and OpenJPA 1.2.1.

I have a JPA object with a "<code>modifiedTimestamp</code>" attribute, something like this:

<pre><code>@Entity
public class Widget {
 /* ... */
 private java.sql.Date modifiedTimestamp;
 /* ... */
}
</code></pre>

The related field in the Oracle database is of type <code>DATE</code>.

I set the date like so ...

<pre><code>myWidget.setModifiedTimestamp(new java.sql.Data(System.currentTimeMillis());
</code></pre>

... and it gets stored, but when I read it back the time of day hasn't been stored, it allows comes back as 24:00.

Is this a JPA thing, or an Oracle thing? Any suggestions are greatly appreciated!

Thanks

how to store date AND time with JPA in Oracle?

Oracle数据库

数据库

MySQL

Java

我使用的是WebSphere 7(JavaEE5)和OpenJPA 1.2.1。我有一个带有"modifiedTimestamp“属性的JPA对象，如下所示：@Entitypublic class Widget {  /* ... */  private java.sql.Date modifiedTimestamp;  /* ... */}Oracle数据库中的相关字段属于DATE类型。我是这样

问如何在Oracle中使用JPA存储日期和时间？
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Oracle中使用JPA存储日期和时间？EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Oracle中使用JPA存储日期和时间？
EN