Это мой класс сущности
@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;
}
Мой базовый класс Entity
@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;
}
Структура моей таблицы:
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
);
но когда я пытаюсь распечатать SofortPaymentEntity, он не печатает crated_dt и update_dt, а когда я пытаюсь обновить, он выдает следующее исключение. В этой таблице уже есть запись, что означает, что она создана первой, и теперь я пытаюсь ее обновить
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());
ОШИБКА:
null value in column "created_at" violates not-null constraint
Обнаружено общее исключение:
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a];
constraint [created_at];
nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:296)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:253)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:534)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:305)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:138)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
Подробнее здесь: https://stackoverflow.com/questions/591 ... cute-state
Org.springframework.dao.DataIntegrityViolationException: не удалось выполнить оператор; SQL ⇐ JAVA
Программисты JAVA общаются здесь
1731071020
Anonymous
[b]Это мой класс сущности[/b]
@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;
}
[b]Мой базовый класс Entity[/b]
@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;
}
[b]Структура моей таблицы:[/b]
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
);
но когда я пытаюсь распечатать SofortPaymentEntity, он не печатает crated_dt и update_dt, а когда я пытаюсь обновить, он выдает следующее исключение. В этой таблице уже есть запись, что означает, что она создана первой, и теперь я пытаюсь ее обновить
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());
[b]ОШИБКА[/b]:
null value in column "created_at" violates not-null constraint
[b]Обнаружено общее исключение[/b]:
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a];
constraint [created_at];
nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:296)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:253)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:534)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:305)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:138)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
Подробнее здесь: [url]https://stackoverflow.com/questions/59108626/org-springframework-dao-dataintegrityviolationexception-could-not-execute-state[/url]
Ответить
1 сообщение
• Страница 1 из 1
Перейти
- Кемерово-IT
- ↳ Javascript
- ↳ C#
- ↳ JAVA
- ↳ Elasticsearch aggregation
- ↳ Python
- ↳ Php
- ↳ Android
- ↳ Html
- ↳ Jquery
- ↳ C++
- ↳ IOS
- ↳ CSS
- ↳ Excel
- ↳ Linux
- ↳ Apache
- ↳ MySql
- Детский мир
- Для души
- ↳ Музыкальные инструменты даром
- ↳ Печатная продукция даром
- Внешняя красота и здоровье
- ↳ Одежда и обувь для взрослых даром
- ↳ Товары для здоровья
- ↳ Физкультура и спорт
- Техника - даром!
- ↳ Автомобилистам
- ↳ Компьютерная техника
- ↳ Плиты: газовые и электрические
- ↳ Холодильники
- ↳ Стиральные машины
- ↳ Телевизоры
- ↳ Телефоны, смартфоны, плашеты
- ↳ Швейные машинки
- ↳ Прочая электроника и техника
- ↳ Фототехника
- Ремонт и интерьер
- ↳ Стройматериалы, инструмент
- ↳ Мебель и предметы интерьера даром
- ↳ Cантехника
- Другие темы
- ↳ Разное даром
- ↳ Давай меняться!
- ↳ Отдам\возьму за копеечку
- ↳ Работа и подработка в Кемерове
- ↳ Давай с тобой поговорим...
Мобильная версия