oracle - 映射中的 oracle.sql.TIMESTAMPTZ 类的对象无法转换为 java.util.Date 类

Question

我在使用 TIMESTAMPTZ 的 eclipselink 中遇到问题。表中有一个具有时间戳和时区的列。当我运行我的程序时，我遇到了异常。

我已经在 stackOverflow 上尝试了所有类似的问题，甚至在下面的链接上。

https://www.eclipse.org/forums/index.php/t/443917/

---

Query q = em.createNativeQuery("SELECT * FROM MY_Schema.MyTable MT WHERE MT.START_DT = (SELECT MAX(START_DT) FROM MY_Schema.MyTable)",MyTable.class);

---

@Entity
@Table(name = "MyTable", schema = "MY_Schema")
public class MyTable implements Serializable {
    @EmbeddedId
    private MyTableId id;

---

@Embeddable
public class MyTableId implements Serializable {

  @Temporal(TemporalType.TIMESTAMP)
  @Column(name = "END_DT")
  private Calendar endTime;

  @Temporal(TemporalType.TIMESTAMP)
  @Column(name = "START_DT")
  private Calendar startTime;

---

错误信息：

5943 [Default Executor-thread-32] ERROR com....MyClass  - 
javax.persistence.PersistenceException: Exception [EclipseLink-3002]
(Eclipse Persistence Services - 2.6.8.WAS-v20181218-0accd7f):
org.eclipse.persistence.exceptions.ConversionException Exception
Description: The object [oracle.sql.TIMESTAMPTZ@d1f0d927], of class
[class oracle.sql.TIMESTAMPTZ], from mapping
[org.eclipse.persistence.mappings.DirectToFieldMapping[startTime--Y_Schema.MyTable.START_DT]]
with descriptor [RelationalDescriptor(com.....MyTableId -->
[DatabaseTable(MY_Schema.MyTable)])], could not be converted to [class
java.util.Date].    at
org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:551)

标签： oraclejpatimestampeclipselinkwebsphere-liberty