У меня есть эта структура таблицы Postgresql: < /p>
create table messages_table (
id bigserial not null,
class_name varchar(255),
quote_date date default current_date,
date_created timestamp,
service varchar(255),
message TEXT,
message_type varchar(255),
method_name varchar(255),
payment_type varchar(255),
call_type varchar(255),
identification_id int8,
primary key (id, quote_date))
PARTITION BY RANGE (quote_date);
create table quote_table (
identification_id int8,
client_source varchar(255),
date_of_birth varchar(255),
quote_reference varchar(255),
quote_status varchar(255),
quote_type varchar(255),
transaction_id varchar(255),
quote_date date default current_date,
transaction_timestamp timestamp,
primary key (identification_id, quote_date))
PARTITION BY RANGE (quote_date);
CREATE TABLE date_created_y2025m01 PARTITION OF messages_table
FOR VALUES FROM ('2025-01-01 00:00:00.000') TO ('2025-02-01 00:00:00.000');
CREATE TABLE transaction_timestamp_y2025m01 PARTITION OF quote_table
FOR VALUES FROM ('2025-01-01 00:00:00.000') TO ('2025-02-01 00:00:00.000');
< /code>
У меня также есть эти классы в моем приложении Spring Boot: < /pbr /> @Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
@Entity
@SelectBeforeUpdate
@Table(name = "dependency_messages")
@Getter
@Setter
public class DependencyMessage {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id", nullable = false)
private Long id;
@Enumerated(EnumType.STRING)
@Column(name = "call_type")
private RequestOrResponse requestOrResponse;
@Enumerated(EnumType.STRING)
@Column(name = "message_type")
private MessageType messageType;
@Enumerated(EnumType.STRING)
@Column(name = "service")
private DependencyApplication dependencyApplication;
@Column(name = "class_name")
private String className;
@Column(name = "method_name")
private String methodName;
@Column(name = "date_created")
@CreationTimestamp
private Date dateCreated;
@Column(name = "message", columnDefinition = "TEXT")
private String message;
@Column(name = "payment_type")
private String paymentType;
@ManyToOne(cascade = CascadeType.ALL)
@JoinColumn(name = "identification_id")
private Quote quote;
}
@Builder
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table(name = "quote_table")
@Getter
@Setter
public class Quote {
@Id
@SequenceGenerator(
name = "quote_sequence",
sequenceName = "quote_sequence")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "quote_sequence")
@Column(name = "identification_id")
private Long identificationId;
@Column(name = "quote_reference")
private String quoteReference;
@Column(name = "transaction_id")
private String transactionId;
@Column(name = "date_of_birth")
private String dateOfBirth;
@Column(name = "quote_date")
@CreationTimestamp
private Date quoteDate;
@Column(name = "transaction_timestamp")
@CreationTimestamp
private LocalDateTime transactionTimestamp;
@Column(name = "client_source")
private String clientSource;
@Column(name = "quote_type")
private String quoteType;
@Column(name = "quote_status")
private String quoteStatus;
public synchronized List getDependencyMessages() {
return dependencyMessages;
}
public synchronized void setDependencyMessages(List dependencyMessages) {
this.dependencyMessages = dependencyMessages;
}
@OneToMany(mappedBy = "quoteIdentification", cascade = CascadeType.ALL, fetch = FetchType.EAGER)
private List dependencyMessages;
public synchronized void addDependencyMessage(DependencyMessage theDependencyMessage) {
if (dependencyMessages == null) {
dependencyMessages = new ArrayList();
}
dependencyMessages.add(theDependencyMessage);
theDependencyMessage.setQuoteIdentification(this);
}
}
< /code>
Я получаю эту ошибку при запуске: < /p>
16:16:25.953 Warn [service.name:quotegenerator ,,,,,,] [] Команда приема исключений. /> org.hibernate.tool.schema.spi.commandacceptanceexception: ошибка выполнения DDL "Alter Table, если существует сообщения ovestable add constraint fk5r6v0qfttbn7paigqrnhrlded foreign -key (идентификация_ид) ссылки Quote_table" через jdbc [urress and referminting and refermated at for for for worrience intories intoriebrics wairse intriews wairse ubrectable wair wairs wair wairty quote_table ". org.hibernate.tool.schema.internal.exec.generationTargetTodatabase.accept (GenerationTargetTodatabase.java:94)
at org.hibernate.tool.schema.internal.abstractschemamigrator.applysqlString (Abstrlesschemamigrator At.javavavavatrator. org.hibernate.tool.schema.internal.abstractschemamigrator.applysqlStrings (AbstractSchemamigrator.java:516)
at org.hibernate.tool.schema.internal.abstractschemamigrator.applyfuerkeyseys (Abstrlesschemamigrator. org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:269)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:112)
at org.hibernate.tool.schema.spi.schemanagementtoolcoordinator.performdatabaseaction (Schemanagementtoolcoordinator.java:280)
at org.hibernate.tool.schema.spi.schemamanagementtoolcoordinator.lambda $ Process $ 5 (Schemanagementtoolcoordinator.java:144)
at java.base /java.util.hashmap.foreach (hashmap.java:1421)
org.hibernate.tool.schema.spi.schemamanagementtoolcoordinator.process (Schemanagementtoolcoordinator.java:141)
at org.hibernate.boot.internal.sessionFactoryObserverforschemexport.sessionFactoryCreated (SessionFactoryObserverforschemaexport.java:37)
at org.hibernate.internal.sessionFactoryObserverChain.sessionFactoryCreted (SessionFactoryObserChain.Serverchain.SessionFactoryCed (SessionFactoryObserChain.35. org.hibernate.internal.sessionFactoryImpl. (SessionFactoryImpl.java:324)
at org.hibernate.boot.internal.sessionFactoryBuilderImpl.Build (SessionFactoryBuilderImpl.java:463)
org.hibernate.jpa.boot.internal.entitymanagerfactorybuilderimpl.build (EntityManagerFactoryBuilderimpl.java:1517)
at org.springframework.orm.jpa.vendor.springhibernatejpapersistenceprovider.createContainerentItyManagerFactory (SpringhibernateJpaperSistenceProvider.java:66)
at org.springframework.orm.jpa.localcontainerentitymanagerfactorybean.createnativeentityManagerFactory (localContainerentItymanagerFactorybean.java:390)
at org.springframework.orm.jpa.abstractentitymanagerfactorybean.buildativeentityManagerFactory (AbstractentityManagerFactoryBean.java:419)
at org.springframework.orm.jpa.abstractentitymanagerfactorybean.afterpropertiesset (AbstractentityManagerFactoryBean.java:400)
at org.springframework.orm.jpa.localcontainerentitymanagerfactorybean.afterpropertiesset (localcontainerentitymanagerfactorybean.java:366)
at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitMethods (Abstractautowirecapablebeanfactory.java:1859)
at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean (Abstractautowirecapablebeanfactory.java:1808)
at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreateebean (Abstractautowirecapablebeanfactory.java:601)
at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean (Abstractautowirecapablebeanfactory.java:523)
at org.springframework.beans.factory.support.abstractbeanfactory.lambda $ dogetbean $ 0 (Abstractbeanfactory.java:339)
at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton (defaultingletonbeanregistry.java:347)
at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean (Abstractbeancepory.javabeance. org.springframework.beans.factory.support.abstractbeanfactory.getbean (Abstractbeanfactory.java:207)
at org.springframework.context.support.abstractapplicationcontext.finishbeanfactialization (AbstractApplicationCplication.java: Java: 97070. org.springframework.context.support.abstractapplicationcontext.refresh (AbstractApplicationContext.java:627)
at org.springframework.boot.web.servlet.context.jerswebserpplicationcontext.refresh (servletwebserverpplication.javexerapplicationcontext.refresh (servletwebserverpplication.javebrication. org.springframework.boot.springapplication.refresh (springapplication.java:752)
at org.springframework.boot.springapplication.refreshcontext (Springapplication.java:439)
at org.springframework.boot.springapplication.run (springapplication.java:318)
at org.springframework.boot.springapplication.run (springapplication.java:1361)
org.springframework.boot.springapplication.run (SpringApplication.java:1350)
at me.quotegenator.application.main (Application.java:78)
at java.base /jdk.internal.reflect.nativevemetdaccessormpl.invoke0 (native.invoke0. java.base /jdk.internal.reflect.nativemethodaccessorimpl.invoke (nativemethodaccessorimpl.java:77)
at java.base /jdk.internal.reflect.delegatingmethodaccessormpl.invoke (delegatingMethodAccess.j.j.j.j.javationmplymplymplymplympl. java.base /java.lang.reflect.method.invoke (method.java:569)
at org.springframework.boot.devtools.restart.restartlauncher.run (restartlauncher.java:50)
org.postgresql.treble. Ссылки и ссылки на столбцы для иностранного ключа не согласны
at org.postgresql.core.v3.queryexecutorimpl.receiveerrorresponse (QueryExecutorimpl.java:2725)
org.postgresql.core.v3.queryexecutorimpl.processResults (QueryExeCutorimpl.java:2412)
at org.postgresql.core.v3.queryexecutorimpl.execut org.postgresql.jdbc.pgstatement.executeinternal (pgstatement.java:502)
at org.postgresql.jdbc.pgstatement.execute (pgstatement.java:419)
org.postgresql.jdbc.pgstatement.executewithflags (pgstatement.java:341)
at org.postgresql.jdbc.pgstatement.executecachedsql (pgstatement.java:326)
att org.postgresql.jdbc.pgstatement.executewithflags (pgstatement.java:302)
at org.postgresql.jdbc.pgstatement.execute (pgstatement.java:297)
com.zaxxer.hikari.pool.proxystatement.execute (proxystatement.java:94)
at com.zaxxer.hikari.pool.hikariproxystatement.execute (hikariproxystatement.java)
at AT org.hibernate.tool.schema.internal.exec.generationTargetTodatabase.accep (GenerationTargetTodatabase.java:80)
... 41 Общие кадры опущены < /p>
< /blockquote>
Я попытался изменить: < /p>
< /blockquote>
>
Подробнее здесь: https://stackoverflow.com/questions/797 ... pplication
