我不能通过邮递员提出请求，我检查了所有内容，我的电子邮件在我的数据库中表示为varchar(255(。我使用postgresql。错误：不存在必需的字符串参数"email"。我使用了response，并将其设置为：为每个接收到的值设置@RequestParam(value = "params", required = false) String params，但这没有帮助，因为程序报告我们没有发送任何内容。这和什么有关？请求是正确的，接受的参数也是正确的。
请求的样子：
{
"email" : "qwerty@mail.ru",
"name" : "Vasya",
"surname" : "Puk",
"phone" : 1234562,
"role":"ADMIN"
}
实体用户
@Data
@Entity
@Table(name = "user", schema = "task")
public class User {
@Id
@GeneratedValue(strategy= GenerationType.IDENTITY)
@Column(name = "id")
private Long id;
@OneToMany(cascade = {CascadeType.DETACH, CascadeType.MERGE, CascadeType.PERSIST,
CascadeType.REFRESH
})
@JoinColumn(name = "id")
private List<Role> role;
@OneToMany(mappedBy = "user")
private Set<Contract> contract;
@Column(name = "surname", nullable = false)
private String surname;
@Column(name = "name", nullable = false)
private String name;
@Column(name = "email", nullable = false, unique = true)
private String email;
@Column(name = "phone", nullable = false, unique = true)
private Integer phone;
}
接受的控制器：
@PostMapping
public String userPostAdd(@RequestParam String email, @RequestParam Integer phone, @RequestParam String name, @RequestParam String surname, @RequestParam String role) {
Roles roles = null;
System.out.println("TEST");
System.out.println(roles.equalsName(role));
System.out.println("TEST");
//if ()
//userRepository.save(requestUserDetails);
return "User add;
}
回购：
@Repository
public interface UserRepository extends CrudRepository<User, Long> {
}
添加日志
"C:Program FilesJetBrainsIntelliJ IDEA 2019.2.4jbrbinjava.exe" "-javaagent:C:Program FilesJetBrainsIntelliJ IDEA 2019.2.4libidea_rt.jar=55224:C:Program FilesJetBrainsIntelliJ IDEA 2019.2.4bin" -Dfile.encoding=UTF-8 -classpath C:UsersVGilenkoIdeaProjectstaskspringtargetclasses;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-data-jpa2.2.0.RELEASEspring-boot-starter-data-jpa-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-aop2.2.0.RELEASEspring-boot-starter-aop-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter2.2.0.RELEASEspring-boot-starter-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot2.2.0.RELEASEspring-boot-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-autoconfigure2.2.0.RELEASEspring-boot-autoconfigure-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-logging2.2.0.RELEASEspring-boot-starter-logging-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositorychqoslogbacklogback-classic1.2.3logback-classic-1.2.3.jar;C:UsersVGilenko.m2repositorychqoslogbacklogback-core1.2.3logback-core-1.2.3.jar;C:UsersVGilenko.m2repositoryorgapachelogginglog4jlog4j-to-slf4j2.12.1log4j-to-slf4j-2.12.1.jar;C:UsersVGilenko.m2repositoryorgapachelogginglog4jlog4j-api2.12.1log4j-api-2.12.1.jar;C:UsersVGilenko.m2repositoryorgslf4jjul-to-slf4j1.7.28jul-to-slf4j-1.7.28.jar;C:UsersVGilenko.m2repositoryorgyamlsnakeyaml1.25snakeyaml-1.25.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-aop5.2.0.RELEASEspring-aop-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgaspectjaspectjweaver1.9.4aspectjweaver-1.9.4.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-jdbc2.2.0.RELEASEspring-boot-starter-jdbc-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositorycomzaxxerHikariCP3.4.1HikariCP-3.4.1.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-jdbc5.2.0.RELEASEspring-jdbc-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryjakartaactivationjakarta.activation-api1.2.1jakarta.activation-api-1.2.1.jar;C:UsersVGilenko.m2repositoryjakartapersistencejakarta.persistence-api2.2.3jakarta.persistence-api-2.2.3.jar;C:UsersVGilenko.m2repositoryjakartatransactionjakarta.transaction-api1.3.3jakarta.transaction-api-1.3.3.jar;C:UsersVGilenko.m2repositoryorgspringframeworkdataspring-data-jpa2.2.0.RELEASEspring-data-jpa-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkdataspring-data-commons2.2.0.RELEASEspring-data-commons-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-orm5.2.0.RELEASEspring-orm-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-context5.2.0.RELEASEspring-context-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-expression5.2.0.RELEASEspring-expression-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-tx5.2.0.RELEASEspring-tx-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-beans5.2.0.RELEASEspring-beans-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-core5.2.0.RELEASEspring-core-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-jcl5.2.0.RELEASEspring-jcl-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgslf4jslf4j-api1.7.28slf4j-api-1.7.28.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-aspects5.2.0.RELEASEspring-aspects-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-data-rest2.2.0.RELEASEspring-boot-starter-data-rest-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-web2.2.0.RELEASEspring-boot-starter-web-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-json2.2.0.RELEASEspring-boot-starter-json-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositorycomfasterxmljacksondatatypejackson-datatype-jdk82.10.0jackson-datatype-jdk8-2.10.0.jar;C:UsersVGilenko.m2repositorycomfasterxmljacksondatatypejackson-datatype-jsr3102.10.0jackson-datatype-jsr310-2.10.0.jar;C:UsersVGilenko.m2repositorycomfasterxmljacksonmodulejackson-module-parameter-names2.10.0jackson-module-parameter-names-2.10.0.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-validation2.2.0.RELEASEspring-boot-starter-validation-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryjakartavalidationjakarta.validation-api2.0.1jakarta.validation-api-2.0.1.jar;C:UsersVGilenko.m2repositoryorghibernatevalidatorhibernate-validator6.0.17.Finalhibernate-validator-6.0.17.Final.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-web5.2.0.RELEASEspring-web-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkspring-webmvc5.2.0.RELEASEspring-webmvc-5.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkdataspring-data-rest-webmvc3.2.0.RELEASEspring-data-rest-webmvc-3.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkdataspring-data-rest-core3.2.0.RELEASEspring-data-rest-core-3.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgspringframeworkhateoasspring-hateoas1.0.0.RELEASEspring-hateoas-1.0.0.RELEASE.jar;C:UsersVGilenko.m2repositorycomjaywayjsonpathjson-path2.4.0json-path-2.4.0.jar;C:UsersVGilenko.m2repositorynetminidevjson-smart2.3json-smart-2.3.jar;C:UsersVGilenko.m2repositorynetminidevaccessors-smart1.2accessors-smart-1.2.jar;C:UsersVGilenko.m2repositoryorgow2asmasm5.0.4asm-5.0.4.jar;C:UsersVGilenko.m2repositoryorgspringframeworkpluginspring-plugin-core2.0.0.RELEASEspring-plugin-core-2.0.0.RELEASE.jar;C:UsersVGilenko.m2repositoryorgatteoevo-inflector1.2.2evo-inflector-1.2.2.jar;C:UsersVGilenko.m2repositorycomfasterxmljacksoncorejackson-databind2.10.0jackson-databind-2.10.0.jar;C:UsersVGilenko.m2repositorycomfasterxmljacksoncorejackson-core2.10.0jackson-core-2.10.0.jar;C:UsersVGilenko.m2repositorycomfasterxmljacksoncorejackson-annotations2.10.0jackson-annotations-2.10.0.jar;C:UsersVGilenko.m2repositoryorgspringframeworkbootspring-boot-starter-tomcat2.2.0.RELEASEspring-boot-starter-tomcat-2.2.0.RELEASE.jar;C:UsersVGilenko.m2repositoryjakartaannotationjakarta.annotation-api1.3.5jakarta.annotation-api-1.3.5.jar;C:UsersVGilenko.m2repositoryorgapachetomcatembedtomcat-embed-core9.0.27tomcat-embed-core-9.0.27.jar;C:UsersVGilenko.m2repositoryorgapachetomcatembedtomcat-embed-el9.0.27tomcat-embed-el-9.0.27.jar;C:UsersVGilenko.m2repositoryorgapachetomcatembedtomcat-embed-websocket9.0.27tomcat-embed-websocket-9.0.27.jar;C:UsersVGilenko.m2repositoryorgpostgresqlpostgresql42.2.16postgresql-42.2.16.jar;C:UsersVGilenko.m2repositoryorgcheckerframeworkchecker-qual3.5.0checker-qual-3.5.0.jar;C:UsersVGilenko.m2repositoryorghibernatehibernate-core5.4.20.Finalhibernate-core-5.4.20.Final.jar;C:UsersVGilenko.m2repositoryorgjbossloggingjboss-logging3.4.1.Finaljboss-logging-3.4.1.Final.jar;C:UsersVGilenko.m2repositoryjavaxpersistencejavax.persistence-api2.2javax.persistence-api-2.2.jar;C:UsersVGilenko.m2repositoryorgjavassistjavassist3.24.0-GAjavassist-3.24.0-GA.jar;C:UsersVGilenko.m2repositorynetbytebuddybyte-buddy1.10.1byte-buddy-1.10.1.jar;C:UsersVGilenko.m2repositoryantlrantlr2.7.7antlr-2.7.7.jar;C:UsersVGilenko.m2repositoryorgjbossspecjavaxtransactionjboss-transaction-api_1.2_spec1.1.1.Finaljboss-transaction-api_1.2_spec-1.1.1.Final.jar;C:UsersVGilenko.m2repositoryorgjbossjandex2.1.3.Finaljandex-2.1.3.Final.jar;C:UsersVGilenko.m2repositorycomfasterxmlclassmate1.5.0classmate-1.5.0.jar;C:UsersVGilenko.m2repositoryjavaxactivationjavax.activation-api1.2.0javax.activation-api-1.2.0.jar;C:UsersVGilenko.m2repositoryorgdom4jdom4j2.1.3dom4j-2.1.3.jar;C:UsersVGilenko.m2repositoryorghibernatecommonhibernate-commons-annotations5.1.0.Finalhibernate-commons-annotations-5.1.0.Final.jar;C:UsersVGilenko.m2repositoryjavaxxmlbindjaxb-api2.3.1jaxb-api-2.3.1.jar;C:UsersVGilenko.m2repositoryorgglassfishjaxbjaxb-runtime2.3.2jaxb-runtime-2.3.2.jar;C:UsersVGilenko.m2repositoryjakartaxmlbindjakarta.xml.bind-api2.3.2jakarta.xml.bind-api-2.3.2.jar;C:UsersVGilenko.m2repositoryorgglassfishjaxbtxw22.3.2txw2-2.3.2.jar;C:UsersVGilenko.m2repositorycomsunistackistack-commons-runtime3.0.8istack-commons-runtime-3.0.8.jar;C:UsersVGilenko.m2repositoryorgjvnetstaxexstax-ex1.8.1stax-ex-1.8.1.jar;C:UsersVGilenko.m2repositorycomsunxmlfastinfosetFastInfoset1.2.16FastInfoset-1.2.16.jar innotechnum.task.Application
. ____ _ __ _ _
/\ / ___'_ __ _ _(_)_ __ __ _
( ( )___ | '_ | '_| | '_ / _` |
\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |___, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v2.2.0.RELEASE)
2020-09-25 19:26:12.934 INFO 7764 --- [ main] innotechnum.task.Application : Starting Application on VGilenko with PID 7764 (C:UsersVGilenkoIdeaProjectstaskspringtargetclasses started by VGilenko in C:UsersVGilenkoIdeaProjectstaskspring)
2020-09-25 19:26:12.939 INFO 7764 --- [ main] innotechnum.task.Application : No active profile set, falling back to default profiles: default
2020-09-25 19:26:14.198 INFO 7764 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data repositories in DEFAULT mode.
2020-09-25 19:26:14.265 INFO 7764 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 59ms. Found 4 repository interfaces.
2020-09-25 19:26:14.930 INFO 7764 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-09-25 19:26:15.691 INFO 7764 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
2020-09-25 19:26:15.707 INFO 7764 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2020-09-25 19:26:15.707 INFO 7764 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.27]
2020-09-25 19:26:15.845 INFO 7764 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2020-09-25 19:26:15.845 INFO 7764 --- [ main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 2770 ms
2020-09-25 19:26:16.224 INFO 7764 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2020-09-25 19:26:16.296 INFO 7764 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.4.20.Final
2020-09-25 19:26:16.512 INFO 7764 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
2020-09-25 19:26:16.745 INFO 7764 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2020-09-25 19:26:16.882 INFO 7764 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2020-09-25 19:26:16.907 INFO 7764 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL10Dialect
Hibernate: alter table if exists task.city add constraint FKtjrg7h2j3ehgycr3usqjgnc2u foreign key (id) references task.house
2020-09-25 19:26:17.915 WARN 7764 --- [ main] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "alter table if exists task.city add constraint FKtjrg7h2j3ehgycr3usqjgnc2u foreign key (id) references task.house" via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table if exists task.city add constraint FKtjrg7h2j3ehgycr3usqjgnc2u foreign key (id) references task.house" via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) ~[spring-orm-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:378) ~[spring-orm-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1862) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1799) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1108) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at innotechnum.task.Application.main(Application.java:15) ~[classes/:na]
Caused by: org.postgresql.util.PSQLException: ОШИБКА: INSERT или UPDATE в таблице "city" нарушает ограничение внешнего ключа "fktjrg7h2j3ehgycr3usqjgnc2u"
Подробности: Ключ (id)=(1) отсутствует в таблице "house".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.16.jar:42.2.16]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.16.jar:42.2.16]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.16.jar:42.2.16]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[postgresql-42.2.16.jar:42.2.16]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[postgresql-42.2.16.jar:42.2.16]
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) ~[postgresql-42.2.16.jar:42.2.16]
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) ~[postgresql-42.2.16.jar:42.2.16]
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) ~[postgresql-42.2.16.jar:42.2.16]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279) ~[postgresql-42.2.16.jar:42.2.16]
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-3.4.1.jar:na]
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-3.4.1.jar:na]
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
... 33 common frames omitted
2020-09-25 19:26:17.957 INFO 7764 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2020-09-25 19:26:17.963 INFO 7764 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2020-09-25 19:26:19.150 INFO 7764 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor'
2020-09-25 19:26:19.635 INFO 7764 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path ''
2020-09-25 19:26:19.639 INFO 7764 --- [ main] innotechnum.task.Application : Started Application in 7.149 seconds (JVM running for 7.817)
2020-09-25 19:26:35.874 INFO 7764 --- [nio-8080-exec-2] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2020-09-25 19:26:35.875 INFO 7764 --- [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2020-09-25 19:26:35.904 INFO 7764 --- [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet : Completed initialization in 29 ms
2020-09-25 19:26:35.958 WARN 7764 --- [nio-8080-exec-2] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.bind.MissingServletRequestParameterException: Required String parameter 'email' is not present]
此控制器似乎不正确。
@PostMapping
public String userPostAdd(@RequestParam String email, @RequestParam Integer phone, @RequestParam String name, @RequestParam String surname, @RequestParam String role) {
//body
}
应该是这样的：
@PostMapping
public String userPostAdd(@RequestBody User user) {
//body
}
用户是您的对象请求，类似于您的用户实体
Error executing DDL "alter table if exists task.city add检查您的实体，然后相应地更新您的数据库架构