org.springframework.dao.DataIntegrityViolationException：不能执行语句；SQL

Question

这是我的实体类

@Entity
@Table(name = "sofort_payment")
@Data
@EqualsAndHashCode(callSuper = true)
@Accessors(chain = true)
@AllArgsConstructor
@NoArgsConstructor
@Builder
@ToString
public class SofortPaymentEntity extends BasicEntity {

    @Id
    @GeneratedValue(generator = "UUID")
    @GenericGenerator(name = "UUID", strategy = "org.hibernate.id.UUIDGenerator")
    @Column(name = "id", updatable = false, nullable = false)
    private UUID id;
    @Column(name = "referenced_transaction")
    private UUID referencedTransaction;
    @Column(name = "status")
    private String status;
    @Column(name = "reason")
    private String reason;
    @Column(name = "external_payment_id")
    private String externalPaymentId;
    @Column(name = "currency")
    private String currency;
    @Column(name = "amount")
    private BigDecimal amount;
    @Column(name = "iban")
    private String iban;
    @Column(name = "back_name")
    private String bankName;
    @Column(name = "sender_holder")
    private String senderHolder;
    @Column(name = "bic")
    private String bic;
    @Column(name = "bank_code")
    private String bankCode;
    @Column(name = "country_code")
    private String countryCode;

}

@MappedSuperclass
@Data
@Accessors(chain = true)
public abstract class BasicEntity {
  @Column(name = "created_at")
  @CreationTimestamp
  private LocalDateTime createdAt;
  @Column(name = "updated_at")
  @UpdateTimestamp
  private LocalDateTime updatedAt;
}

and this is my table

create table sofort_payment
(
    id                          UUID         NOT NULL
        constraint sofort_payment_pkey primary key,
    referenced_transaction      UUID references transaction(id) NOT NULL,
    status                      varchar(255) NOT NULL,
      reason                      text,
    external_payment_id         varchar(255) NOT NULL,
    currency                    varchar(255) NOT NULL,
    amount                      numeric(19, 2) NOT NULL,
      iban                        varchar(255) NOT NULL,
      back_name                   varchar(255) NOT NULL,
    sender_holder               varchar(255) NOT NULL,
    bic                         varchar(255) NOT NULL,
    bank_code                   varchar(255) NOT NULL,
    country_code                varchar(255) NOT NULL,
    created_at                  timestamp without time zone NOT NULL,
    updated_at                  timestamp without time zone NOT NULL
);

sofortPaymentRepository.save(sofortPaymentEntity.builder()
                                                 .id(sofortPaymentEntity.getId())
                                                 .referencedTransaction(sofortPaymentEntity.getReferencedTransaction())
                                                 .externalPaymentId(statusNotification.getTransId())
                                                 .amount(BigDecimal.valueOf(paymentTransactionDetails.getAmount()))
                                                 .currency(paymentTransactionDetails.getCurrencyCode())
                                                 .reason(paymentTransactionDetails.getStatusReason().toString())
                                                 .bankCode(paymentTransactionDetails.getSender().getBankCode())
                                                 .bankName(paymentTransactionDetails.getSender().getBankName())
                                                 .bic(paymentTransactionDetails.getSender().getBic())
                                                 .iban(paymentTransactionDetails.getSender().getIban())
                                                 .countryCode(paymentTransactionDetails.getSender().getCountryCode())
                                                 .senderHolder(paymentTransactionDetails.getSender().getHolder())
                                                 .status(paymentTransactionDetails.getStatus().toString()).build());

Generic exception caught: 

org.springframework.dao.DataIntegrityViolationException：不能执行语句；SQL[N/A]；约束[created_at]；嵌套异常是org.hibernate.exception.constraintViolationException：在org.springframework.orm.jpa.vendor.hibernatejpaction.converthibernateAccessException（Hibernatejpaction.java:296)在org.springframework.orm.jpa.vendor.hibernatejpaction.java.translateExceptionIfprobley（Hibernatejpaction.java:253)在manager.java:746)在org.springframework.transaction.support.AbstractPlatformTransactionManager.Commit（AbstractPlatformTransactionManager.java:714)在org.springframework.transaction.interceptor.transaction.Transaction.Transaction.Transaction.TransactionSupport.CommittTransactionAfterRetting（TransactionSupport.java:534)在interceptor.transactioninterceptor.invoke（transactioninterceptor.java:98)在org.springframework.aop.framework.reflectiveMethodInvocation.proce(reflectiveMethodInvocation.java:186)在org.springframework.dao.support.persistenceExceptionTranslationInterceptor.invoke(persistenceExceptionTranslationInterceptor.java:139)在（crudmethodMetadatapostProcessor.java:138)在org.springframework.aop.framework.reflectiveMethodInvocation.java:186)在org.springframework.aop.interceptor.exposeInvocation.java:186)在org.springframework.aop.interceptor.exposeInvocation.invoke(exposeInvocation.java:93)，在ndingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)在org.springframework.aop.framework.ReflectiveMethodInvocation.proce(ReflectiveMethodInvocation.java:186)

Answer 1

在创建表时给出默认的时间戳值，如

created_at timestamp without time zone default CURRENT_TIMESTAMP NOT NULL

或者为特定于数据库提供程序的@Column注释设置columnDefinition属性，并使用@Temporal。ex PSQL：

@Column(columnDefinition = "TIMESTAMP DEFAULT CURRENT_TIMESTAMP", nullable = false)
@Temporal(TemporalType.TIMESTAMP)
private java.util.Date createdAt