我正在开发一个Web应用程序,使用JSF和JPA(EclipseLink)。我有表story
和story_translate
,它们的映射如下:
@Entity
@Table(name = "story")
public class Story{
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
private Integer id;
private String title;
private String description;
@OneToMany(mappedBy = "story", cascade=CascadeType.ALL)
private List<StoryTranslate> translateList;
//getters and setters
}
@Entity
@Table(name = "story_translate")
public class StoryTranslate{
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
private Integer id;
@Column(name="STORY_ID")
private Integer storyId;
@ManyToOne
@JoinColumn(name="story_id", referencedColumnName="id", updatable=false, insertable=false)
private Story story;
//some other fields, getters and setters
}
在一个
ManagedBean
中,我正在执行以下操作: StoryTranslate translate = new StoryTranslate(null, sessionController.getEntity().getId(), getAuthUser().getId(), language,
title, description, new Date(), false);
EntityTransaction transaction = TransactionSingleton.getActiveInstance();
Story story = storyService.read(sessionController.getEntity().getId());
if (story != null){
if (story.getTranslateList() == null){
story.setTranslateList(new ArrayList<StoryTranslate>());
}
story.getTranslateList().add(translate);
translate.setStory(story);
}
transaction.commit();
当我尝试创建新的
StoryTranslate
时,我遇到了一个 DatabaseException
,它说 story_id
不能为空。我之前处理过关联,但从未见过这个错误。
问题出在哪里?
编辑:对不起,我忘记了映射的另一部分(可能是因为睡眠不足)。
父类Story
表名设置为@Table("my_story")
,我该如何映射@JoinColumn
?这里的命名规范是什么? - dryleaf