- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我正在编写一个 spring-boot、spring-mvc 应用程序。其中有两个实体:User 和 Task。该任务必须属于用户。我正在尝试使用外键、使用 @OneToMany、@ManyToOne 和 @JoinColumn 来执行此操作。
用户.java:
package ru.chausov.to_do_list.data_base.entities;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import ru.chausov.to_do_list.data_base.types.Gender;
import javax.persistence.*;
import java.time.LocalDate;
import java.util.HashSet;
import java.util.Set;
@Data
@Builder
@Entity
@Table(name="users")
@NoArgsConstructor
@AllArgsConstructor
public class User {
@Id
@GeneratedValue
private Long id;
private String name;
private String lastName;
private LocalDate birthDate;
private Gender gender;
private String address;
private String company;
@OneToMany(mappedBy = "id", cascade = CascadeType.ALL, orphanRemoval = true)
private final Set<Task> tasks = new HashSet<>();
}
任务.java:
package ru.chausov.to_do_list.data_base.entities;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import javax.persistence.*;
import java.time.LocalDateTime;
@Data
@Builder
@Entity
@Table(name="tasks")
@NoArgsConstructor
@AllArgsConstructor
public class Task {
@Id
@GeneratedValue
private Long id;
private String name;
private String description;
private LocalDateTime receivedDate;
private LocalDateTime toBeDone;
private boolean done;
@ManyToOne
@JoinColumn(name = "user_id")
private User user;
}
从 CrudRepository 扩展了标准存储库。
UsersRepositpry.java:
package ru.chausov.to_do_list.data_base.repositories;
import org.springframework.data.repository.CrudRepository;
import ru.chausov.to_do_list.data_base.entities.User;
public interface UsersRepository extends CrudRepository<User, Long> {
}
TasksRepository.java:
package ru.chausov.to_do_list.data_base.repositories;
import org.springframework.data.repository.CrudRepository;
import ru.chausov.to_do_list.data_base.entities.Task;
public interface TasksRepository extends CrudRepository<Task, Long> {
}
编写了 junit/spring-boot 测试。
UserRepositoryTest.java:
package ru.chausov.to_do_list.data_base.repositories;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import ru.chausov.to_do_list.data_base.entities.Task;
import ru.chausov.to_do_list.data_base.entities.User;
@RunWith(SpringRunner.class)
@SpringBootTest
public class TasksRepositoryTests {
@Autowired
private TasksRepository tasksRepository;
@Autowired
private UsersRepository usersRepository;
@Test
public void saveTest() {
User user = new User();
usersRepository.save(user);
Task taskToSave = Task.builder().user(user).build();
Task savedTask = tasksRepository.save(taskToSave);
Assert.assertEquals(savedTask, taskToSave);
}
当我启动测试时,出现错误:
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint ["FKO4W1P8Y0P6E0GSR7VHBDG76KO: PUBLIC.TASKS FOREIGN KEY(ID) REFERENCES PUBLIC.USERS(ID) (2)"; SQL statement:
insert into tasks (description, done, name, received_date, to_be_done, user_id, id) values (?, ?, ?, ?, ?, ?, ?) [23506-197]]; 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:533)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)
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)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy97.save(Unknown Source)
at ru.chausov.to_do_list.data_base.repositories.TasksRepositoryTests.saveTest(TasksRepositoryTests.java:29)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)
at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)
at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3174)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3688)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:90)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1453)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:510)
at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3282)
at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2478)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532)
... 55 more
Caused by: org.h2.jdbc.JdbcSQLException: Нарушение ссылочной целостности: "FKO4W1P8Y0P6E0GSR7VHBDG76KO: PUBLIC.TASKS FOREIGN KEY(ID) REFERENCES PUBLIC.USERS(ID) (2)"
Referential integrity constraint violation: "FKO4W1P8Y0P6E0GSR7VHBDG76KO: PUBLIC.TASKS FOREIGN KEY(ID) REFERENCES PUBLIC.USERS(ID) (2)"; SQL statement:
insert into tasks (description, done, name, received_date, to_be_done, user_id, id) values (?, ?, ?, ?, ?, ?, ?) [23506-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:332)
at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:274)
at org.h2.table.Table.fireConstraints(Table.java:995)
at org.h2.table.Table.fireAfterRow(Table.java:1013)
at org.h2.command.dml.Insert.insertRows(Insert.java:192)
at org.h2.command.dml.Insert.update(Insert.java:134)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:153)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
... 72 more
据我了解,该错误是由于外键 user_id 为 null 引起的。
我应该如何初始化user_id?
最佳答案
您需要使用您还保存的Task
填写User
上的@OneToMany
集:
@Test
public void saveTest() {
User user = new User();
usersRepository.save(user);
Task taskToSave = Task.builder().user(user).build();
user.getTasks().add(task); // -> Add this
Task savedTask = tasksRepository.save(taskToSave);
Assert.assertEquals(savedTask, taskToSave);
}
这是因为它们处于双向映射中。
关于java - @JoinColumn,如何初始化它?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/56539287/
这是简化的代码片段,省略了 IdClass 详细信息。我遇到的问题是表定义是: ClientPersonalityModel ( client_id int not null, personali
我正在编写一个 spring-boot、spring-mvc 应用程序。其中有两个实体:User 和 Task。该任务必须属于用户。我正在尝试使用外键、使用 @OneToMany、@ManyToOne
有关更多上下文,请参阅 my other question。 我想将我的 Employee 实体类加入到 Code 实体类中,但代码 PK 是复合的(DOMAIN、CODE),因为它列出了许多不同的代
我正在尝试使用 @JoinColumn 注释加入一个列,但我的列总是返回 null,我不确定为什么。 @Entity public class Blender implements Serializa
我有实体 User,其中包含实体 Actor 的字段,其中包含具有实体产品的字段。现在我希望数据库中的用户拥有有关产品 id 的信息,该信息使用产品上的 @JoinColum 存储在 Actor 中。
我使用 @JoinColumn 注释进行一对多映射: @JoinColumn(name="domainId",referencedColumnName="domainId")。 但是,表中的外键列名称
@ManyToOne @JoinColumn(name = "someValue" , referencedColumnName = "someOtherValue" ) 如果 2 个表通过 Many
我在尝试为数据库创建一些模型时遇到 JPA 问题。 我有这三个类(我只是将部分代码放在这里): GuideVersionLang @Entity public class GuideVersionLa
我可能只是误解了@JoinColumns 的工作原理,但是当我重用名称属性时出现错误。但是名称属性不映射到数据库列吗?我不应该能够重复使用它吗? 我遇到错误: Repeated column in m
根据 hibernate 文档, hibernate 团队强烈建议不要在没有连接表的情况下使用一对多单向映射。我想知道这是因为性能问题还是背后有任何其他原因。 说如果有一个员工可以有很多电话号码,那么
@ManyToOne(fetch = FetchType.LAZY) @JoinColumn (name = "account_id") private Account account; 工作正常。
我是 HQL 的初学者,并且我陷入了使用 HQL 检索 VesselOperator 记录的困境 我的代码如下所示。 CompanyId.java @Embeddable public class C
抱歉我的问题。实在无法理解我的错误。我在两个类之间有 Hibernate 关系,但是当我运行它时,日志给出了这个错误: org.hibernate.AnnotationException: mappe
我正在研究一个使用 JPA 的项目,我对此还很陌生。我遇到了一个我不太理解的逻辑。我有一个名为 A 的实体,它具有以下字段/列: @Column(name = "COD_UOP_COO") p
我正在将 JPA 与 EclipseLink (2.5.2) 结合使用。 我有以下实体: @Entity @Table(name="Consumer") public class Consumer i
我遇到以下问题:我想简单地加入表“市场”(主)和“电话”,但在使用注释执行此操作时遇到一些问题。 我只是想使用 Comercio.id 作为 Telefone.fk_id 中相应的外键,但它无法识别它
我有以下表格(仅显示最重要的列,A 和 B 不是真实姓名): table A { ... } table B { ... } table METADATA { KEY VALUE
在我的 JPA 类中,我有这个注释和我无法理解的语法 @JoinColumns({ @JoinColumn(name="RES_ID", referencedColumnName="ACCT_
有什么区别: @Entity public class Company { @OneToMany(cascade = CascadeType.ALL , fetch = FetchType.L
我有很多映射实体,它们都是从抽象类 BaseEntityImpl 扩展而来的。 在这个类中,我有 1 个属性 company,注释如下: @ManyToOne(fetch=FetchType.EAGE
我是一名优秀的程序员,十分优秀!