java - Dropwizard-Postgresql-带有LocalDateTime时区的Hibernate映射时间戳

我在java.time.LocalDateTime上映射postgresql类型“timestamp with time zone”时遇到问题。我用的是：postgresql，dropwizard和hibernate。
表格：

CREATE SEQUENCE "auth"."roles_seq_id";

CREATE TABLE "auth"."roles" (
  id        BIGINT                  NOT NULL    DEFAULT nextval('auth.roles_seq_id'),
  name      VARCHAR(50)             NOT NULL,
  createdat TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL
);

ALTER TABLE "auth"."roles" ADD CONSTRAINT "roles_id_pk" PRIMARY KEY (id);

核心：

import lombok.*;

import javax.persistence.*;
import java.io.Serializable;
import java.time.LocalDateTime;

@Getter
@Setter
@ToString(callSuper = true)
@EqualsAndHashCode(callSuper = false)
@AllArgsConstructor
@NoArgsConstructor
@Entity
@Table(schema = "auth", name = "roles")
public class Role implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "roles_id_generator")
    @SequenceGenerator(name = "roles_id_generator", sequenceName = "roles_seq_id")
    @Column(name = "id")
    private Long id;

    @NonNull
    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "createdat")
    private LocalDateTime createdAt;

}

错误：
错误[2017-07-21 08:13:43165]
io.dropwizard.jersey.errors.LoggingExceptionMapper:处理
请求：b09a66b06dd214bd。。。！导致：
org.hibernate.type.SerializationException:无法反序列化
POM.XML文件：

<dropwizard.version>1.0.6</dropwizard.version>
<postgresql.version>9.4.1212</postgresql.version>

 <dependency>
            <groupId>io.dropwizard</groupId>
            <artifactId>dropwizard-hibernate</artifactId>
            <version>${dropwizard.version}</version>
 </dependency>
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>${postgresql.version}</version>
  </dependency>

当我删除createdAt或使用private Date createdAt时（但我想使用LocalDateTime），一切正常。

最佳答案

似乎dropwizard-hibernate:1.0.6捆绑包休眠5.1。根据the manual需要额外的依赖项来支持java.time类型：

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-java8</artifactId>
    <version>5.1.0.Final</version>
</dependency>

另外，从Hibernate 5.2开始，这个额外的依赖性是不需要的，看起来功能已经被折叠到了主依赖性中。

关于java - Dropwizard-Postgresql-带有LocalDateTime时区的Hibernate映射时间戳，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/45232676/