发布于2022-05-19 07:40 阅读(948) 评论(0) 点赞(11) 收藏(5)
我使用了 play-spring-data-jpa 模板来启动一个项目并
我在尝试将休眠映射到使用复合主键的连接表时遇到问题。
我要连接的数据库是现有的 mysql 数据库。
请看下面:
SQL:
CREATE TABLE IF NOT EXISTS `text_advertising`.`campaign_item_slots` (
`campaign_item_id` BIGINT NOT NULL,
`advert_slot_id` BIGINT NOT NULL,
`active` TINYINT(1) NOT NULL DEFAULT TRUE,
`date_created` DATETIME NOT NULL,
`date_updated` DATETIME NOT NULL,
PRIMARY KEY (`campaign_item_id`, `advert_slot_id`),
INDEX `fk_campaign_item_slots_2_idx` (`advert_slot_id` ASC),
CONSTRAINT `fk_campaign_item_slots_1`
FOREIGN KEY (`campaign_item_id`)
REFERENCES `text_advertising`.`campaign_items` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_campaign_item_slots_2`
FOREIGN KEY (`advert_slot_id`)
REFERENCES `text_advertising`.`advert_slots` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
CampaignItemSlot 类:
@Entity
@Table(name = "campaign_item_slots")
public class CampaignItemSlot implements Serializable{
@EmbeddedId
CampaignItemSlotId campaignItemSlotId;
private boolean active;
private Timestamp date_created;
private Timestamp date_updated;
}
CampaignItemSlotId 类
@Embeddable
public class CampaignItemSlotId implements Serializable{
@Column(name="advert_slot_id")
public long advertSlot;
@Column(name="campaign_item_id")
public long campaignItem;
}
当我设置“hibernate.hbm2ddl.auto”、“validate”时,我收到以下错误:
Caused by: org.hibernate.HibernateException: Missing column: id in text_advertising.campaign_item_slots
When I set "hibernate.hbm2ddl.auto", "update" then an id field is automatically created in the campaign_item_slots table as shown when I do a show create table. This is not what I want:
| campaign_item_slots | CREATE TABLE `campaign_item_slots` (
`campaign_item_id` bigint(20) NOT NULL,
`advert_slot_id` bigint(20) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
`date_created` datetime NOT NULL,
`date_updated` datetime NOT NULL,
`id` bigint(20) NOT NULL,
`advertSlot_id` bigint(20) DEFAULT NULL,
`campaignItem_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`campaign_item_id`,`advert_slot_id`),
KEY `fk_campaign_item_slots_2_idx` (`advert_slot_id`),
KEY `FK_q87o53119u79073jwttacsqta` (`advertSlot_id`),
KEY `FK_es60h5vj30rllkf0js1qy642y` (`campaignItem_id`),
CONSTRAINT `FK_es60h5vj30rllkf0js1qy642y` FOREIGN KEY (`campaignItem_id`) REFERENCES `campaign_items` (`id`),
CONSTRAINT `fk_campaign_item_slots_1` FOREIGN KEY (`campaign_item_id`) REFERENCES `campaign_items` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_campaign_item_slots_2` FOREIGN KEY (`advert_slot_id`) REFERENCES `advert_slots` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `FK_q87o53119u79073jwttacsqta` FOREIGN KEY (`advertSlot_id`) REFERENCES `advert_slots` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
This is my build.sbt:
version := "1.0-SNAPSHOT"
libraryDependencies ++= Seq(
javaCore,
javaJpa,
javaWs % "test",
"org.springframework" % "spring-context" % "4.1.4.RELEASE",
"org.springframework.data" % "spring-data-jpa" % "1.8.0.RELEASE",
"org.springframework" % "spring-orm" % "4.1.4.RELEASE",
"org.springframework" % "spring-jdbc" % "4.1.4.RELEASE",
"org.springframework" % "spring-tx" % "4.1.4.RELEASE",
"org.springframework" % "spring-expression" % "4.1.4.RELEASE",
"org.springframework" % "spring-aop" % "4.1.4.RELEASE",
"org.springframework" % "spring-test" % "4.1.4.RELEASE" % "test", javaJpa.exclude("org.hibernate.javax.persistence", "hibernate-jpa-2.0-api"),
"org.hibernate" % "hibernate-entitymanager" % "4.3.8.Final",
"javax.inject" % "javax.inject" % "1",
"mysql" % "mysql-connector-java" % "5.1.34",
"org.json" % "json" % "20090211"
)
lazy val root = (project in file(".")).enablePlugins(PlayJava)
I've tried many different combinations of using IdClass and EmbeddedId etc as described on this site: mapping variations
So whichever combination of things I do try, after some fiddling I get to the same error of:
Caused by: org.hibernate.HibernateException: Missing column: id in text_advertising.campaign_item_slots
I'm starting to wonder if it's a spring data issue.
Would really appreciate any help with this. Thanks.
Seems like the config below did it for me:
CampaignItemSlot.java
package models;
import java.io.Serializable;
import java.sql.Timestamp;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinColumns;
import javax.persistence.ManyToOne;
import javax.persistence.MapsId;
import javax.persistence.Table;
@Entity
@Table(name = "campaign_item_slots")
public class CampaignItemSlot implements Serializable{
@EmbeddedId
private CampaignItemSlotPk campaignItemSlotPk;
@MapsId("advert_slot_id")
@JoinColumns({
@JoinColumn(name="advert_slot_id", referencedColumnName="id"),
})
@ManyToOne AdvertSlot advertSlot;
@MapsId("campaign_item_id")
@JoinColumns({
@JoinColumn(name="campaign_item_id", referencedColumnName="id"),
})
@ManyToOne CampaignItem campaignItem;
private boolean active;
private Timestamp date_created;
private Timestamp date_updated;
public CampaignItemSlot() {
super();
// TODO Auto-generated constructor stub
}
public CampaignItemSlotPk getCampaignItemSlotPk() {
return campaignItemSlotPk;
}
public void setCampaignItemSlotPk(CampaignItemSlotPk campaignItemSlotPk) {
this.campaignItemSlotPk = campaignItemSlotPk;
}
public boolean isActive() {
return active;
}
public void setActive(boolean active) {
this.active = active;
}
public Timestamp getDate_created() {
return date_created;
}
public void setDate_created(Timestamp date_created) {
this.date_created = date_created;
}
public Timestamp getDate_updated() {
return date_updated;
}
public void setDate_updated(Timestamp date_updated) {
this.date_updated = date_updated;
}
public AdvertSlot getAdvertSlot() {
return advertSlot;
}
public void setAdvertSlot(AdvertSlot advertSlot) {
this.advertSlot = advertSlot;
}
public CampaignItem getCampaignItem() {
return campaignItem;
}
public void setCampaignItem(CampaignItem campaignItem) {
this.campaignItem = campaignItem;
}
}
CampaignItemSlotPK.java
package models;
import java.io.Serializable;
import java.sql.Timestamp;
import javax.persistence.Column;
import javax.persistence.Embeddable;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
@Embeddable
public class CampaignItemSlotPk implements Serializable{
@Column(name="campaign_item_id")
private long campaignItem;
@Column(name="advert_slot_id")
private long advertSlot;
public CampaignItemSlotPk() {
// TODO Auto-generated constructor stub
}
public long getCampaignItem() {
return campaignItem;
}
public void setCampaignItem(long campaignItem) {
this.campaignItem = campaignItem;
}
public long getAdvertSlot() {
return advertSlot;
}
public void setAdvertSlot(long advertSlot) {
this.advertSlot = advertSlot;
}
}
build.sbt
javaJpa.exclude("org.hibernate.javax.persistence", "hibernate-jpa-2.0-api"),
"org.hibernate" % "hibernate-entitymanager" % "4.3.0.Final",
"mysql" % "mysql-connector-java" % "5.1.34",
This fixed it.
作者:黑洞官方问答小能手
链接:http://www.javaheidong.com/blog/article/442847/212cd36534e547f9a770/
来源:java黑洞网
任何形式的转载都请注明出处,如有侵权 一经发现 必将追究其法律责任
昵称:
评论内容:(最多支持255个字符)
---无人问津也好,技不如人也罢,你都要试着安静下来,去做自己该做的事,而不是让内心的烦躁、焦虑,坏掉你本来就不多的热情和定力
Copyright © 2018-2021 java黑洞网 All Rights Reserved 版权所有,并保留所有权利。京ICP备18063182号-2
投诉与举报,广告合作请联系vgs_info@163.com或QQ3083709327
免责声明:网站文章均由用户上传,仅供读者学习交流使用,禁止用做商业用途。若文章涉及色情,反动,侵权等违法信息,请向我们举报,一经核实我们会立即删除!