休眠@OneToOne不能添加或更新子行：外键约束

问题描述：

我使用JPA，休眠，春天和MySQL休眠@OneToOne不能添加或更新子行：外键约束

不能添加或更新子行，外键约束失败（db1。 stock_detail，约束FK_STOCK_ID外键（STOCK_ID）参考文献stock（STOCK_ID））

创建脚本

CREATE TABLE IF NOT EXISTS `stock` (
    `STOCK_ID` int(10) unsigned NOT NULL, 
    `STOCK_CODE` varchar(10) NOT NULL, 
    `STOCK_NAME` varchar(20) NOT NULL 
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8; 

CREATE TABLE IF NOT EXISTS `stock_detail` (
    `STOCK_ID` int(10) unsigned NOT NULL, 
    `COMP_NAME` varchar(100) NOT NULL, 
    `COMP_DESC` varchar(255) NOT NULL 
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8; 

ALTER TABLE `stock` 
    ADD PRIMARY KEY (`STOCK_ID`) USING BTREE, 
    ADD UNIQUE KEY `UNI_STOCK_NAME` (`STOCK_NAME`), 
    ADD UNIQUE KEY `UNI_STOCK_CODE` (`STOCK_CODE`) USING BTREE; 

ALTER TABLE `stock_detail` 
    ADD PRIMARY KEY (`STOCK_ID`) USING BTREE; 

ALTER TABLE `stock` 
    MODIFY `STOCK_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=86; 

ALTER TABLE `stock_detail` 
    MODIFY `STOCK_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=72; 

ALTER TABLE `stock_detail` 
    ADD CONSTRAINT `FK_STOCK_ID` FOREIGN KEY (`STOCK_ID`) REFERENCES `stock` (`STOCK_ID`);

股票实体

@Entity 
@Table(name = "stock") 
@XmlRootElement 
@Component("astock") 
@NamedQueries({ 
    @NamedQuery(name = "Stock.findAll", query = "SELECT s FROM Stock s"), 
    @NamedQuery(name = "Stock.findByStockId", query = "SELECT s FROM Stock s WHERE s.stockId = :stockId"), 
    @NamedQuery(name = "Stock.findByStockCode", query = "SELECT s FROM Stock s WHERE s.stockCode = :stockCode"), 
    @NamedQuery(name = "Stock.findByStockName", query = "SELECT s FROM Stock s WHERE s.stockName = :stockName")}) 
public class Stock implements Serializable { 
    private static final long serialVersionUID = 1L; 
    @Id 
    @GeneratedValue(strategy = GenerationType.IDENTITY) 
    @Basic(optional = false) 
    @Column(name = "STOCK_ID") 
    private Integer stockId; 
    @Basic(optional = false) 

    @Size(min = 1, max = 10) 
    @Column(name = "STOCK_CODE") 
    private String stockCode; 
    @Basic(optional = false) 

    @Size(min = 1, max = 20) 
    @Column(name = "STOCK_NAME") 
    private String stockName; 
    @OneToOne(cascade = CascadeType.ALL, mappedBy = "stock") 
    private StockDetail stockDetail;

StockDetail实体

@Entity 
@Table(name = "stock_detail") 
@XmlRootElement 
@NamedQueries({ 
    @NamedQuery(name = "StockDetail.findAll", query = "SELECT s FROM StockDetail s"), 
    @NamedQuery(name = "StockDetail.findByStockId", query = "SELECT s FROM StockDetail s WHERE s.stockId = :stockId"), 
    @NamedQuery(name = "StockDetail.findByCompName", query = "SELECT s FROM StockDetail s WHERE s.compName = :compName"), 
    @NamedQuery(name = "StockDetail.findByCompDesc", query = "SELECT s FROM StockDetail s WHERE s.compDesc = :compDesc")}) 
public class StockDetail implements Serializable { 
    private static final long serialVersionUID = 1L; 
    @Id 
    @GeneratedValue(strategy = GenerationType.IDENTITY) 
    @Basic(optional = false) 
    @Column(name = "STOCK_ID") 
    private Integer stockId; 
    @Basic(optional = false) 

    @Size(min = 1, max = 100) 
    @Column(name = "COMP_NAME") 
    private String compName; 

    @Basic(optional = false) 
    @Size(min = 1, max = 255) 
    @Column(name = "COMP_DESC") 
    private String compDesc; 
    @JoinColumn(name = "STOCK_ID", referencedColumnName = "STOCK_ID") 
    @OneToOne(cascade = CascadeType.ALL) 
    private Stock stock;

如何，我想保存它。

Stock StockServices = (Stock) applicationContext.getBean("astock"); 

    Stock stock = new Stock(); 
    stock.setStockCode("123"); 
    stock.setStockName("AAPL"); 

    StockDetail stockDetail = new StockDetail(); 
    stockDetail.setCompName("Apple"); 
    stockDetail.setCompDesc("A hardware and software company"); 

    stockDetail.setStock(stock); 
    stock.setStockDetail(stockDetail); 

    sessionFactory.getCurrentSession().saveOrUpdate(stock);

看起来你忘了在你的桌子上创建主键。 – Everv0id

答

你的问题是，您尝试使用stock_detail.STOCK_ID既是PRIMARY KEY为stock_detail和FOREIGN KEY从股市和你为他们分配不同的自动递增值。

当Hibernate保存它们时，它试图用STOCK_ID =86和stock_detail和STOCK_ID=72来储存股票，该股票打破了外键契约。

请在您的stock_detail表E.g stock_detail_id中作为单独的主键，并将stock_id作为单独的列。

答

同意接受的答案。

仍然如果你想坚持使用外键作为子表中的主键，请在子表上使用Foreign Key Generator。通过这种方式，我们可以减少用于创建太多独特ID的DB引擎的开销。

参考：ForeignKeyGeneratorUsage

休眠@OneToOne不能添加或更新子行：外键约束

相关推荐