JPA-一对多合并问题

Question

现在,如果我在商品列表中添加第二个商品,我会出现以下错误：

菜单[menuid=1,menu_name=dsad,menu_description=null,类别=[category_id=1,categoryname=A,goods=[GoodsImp[id=1,Brand=asd,createddate=Mon Jan 22 18:26:35 ART 2018],价格=3.0,description=asd,type=product]],GoodsImp[id=null,Brand=dsad,createddate=null],价格=33333.0,description=SD,type=product]]],类别[category_id=2,categoryname=B,goods=[]]],business=2]

----------冬眠：

/* load models.menu.Menu */ select
    menu0_.MENU_ID as MENU_ID1_7_1_,
    menu0_.BUSINESS_ID as BUSINESS2_7_1_,
    menu0_.MENU_DESCRIPTION as MENU_DES3_7_1_,
    menu0_.MENU_NAME as MENU_NAM4_7_1_,
    categories1_.Menu_MENU_ID as Menu_MEN1_8_3_,
    category2_.CATEGORY_ID as categori2_8_3_,
    category2_.CATEGORY_ID as CATEGORY1_2_0_,
    category2_.CATEGORY_NAME as CATEGORY2_2_0_
from
    MENUES menu0_
left outer join
    MENUES_CATEGORIES categories1_
        on menu0_.MENU_ID=categories1_.Menu_MENU_ID
left outer join
    Categories category2_
        on categories1_.categories_CATEGORY_ID=category2_.CATEGORY_ID
where
    menu0_.MENU_ID=? Hibernate:
/* load models.menu.Product */ select
    product0_.GOODS_ID as GOODS_ID2_6_0_,
    product0_.GOODS_BRAND as GOODS_BR3_6_0_,
    product0_.GOODS_CREATED as GOODS_CR4_6_0_,
    product0_.GOODS_DESCRIPTION as GOODS_DE5_6_0_,
    product0_.GOODS_IMAGE as GOODS_IM6_6_0_,
    product0_.GOODS_PRICE as GOODS_PR7_6_0_
from
    GOODS product0_
where
    product0_.GOODS_ID=?
    and product0_.DTYPE='PRODUCT'

Hibernate：

/* insert models.menu.Product
    */ insert
    into
        GOODS
        (GOODS_BRAND, GOODS_CREATED, GOODS_DESCRIPTION, GOODS_IMAGE, GOODS_PRICE, DTYPE)
    values
        (?, ?, ?, ?, ?, 'PRODUCT') Hibernate:
select
    goods0_.GOODS_ID as GOODS_ID2_6_0_,
    goods0_.GOODS_ID as GOODS_ID2_6_1_,
    goods0_.GOODS_BRAND as GOODS_BR3_6_1_,
    goods0_.GOODS_CREATED as GOODS_CR4_6_1_,
    goods0_.GOODS_DESCRIPTION as GOODS_DE5_6_1_,
    goods0_.GOODS_IMAGE as GOODS_IM6_6_1_,
    goods0_.GOODS_PRICE as GOODS_PR7_6_1_,
    goods0_.GOODS_PRICE_TYPE as GOODS_PR8_6_1_,
    goods0_.DTYPE as DTYPE1_6_1_
from
    GOODS goods0_
where
    goods0_.GOODS_ID=? Hibernate:
select
    goods0_.GOODS_ID as GOODS_ID2_6_0_,
    goods0_.GOODS_ID as GOODS_ID2_6_1_,
    goods0_.GOODS_BRAND as GOODS_BR3_6_1_,
    goods0_.GOODS_CREATED as GOODS_CR4_6_1_,
    goods0_.GOODS_DESCRIPTION as GOODS_DE5_6_1_,
    goods0_.GOODS_IMAGE as GOODS_IM6_6_1_,
    goods0_.GOODS_PRICE as GOODS_PR7_6_1_,
    goods0_.GOODS_PRICE_TYPE as GOODS_PR8_6_1_,
    goods0_.DTYPE as DTYPE1_6_1_
from
    GOODS goods0_
where
    goods0_.GOODS_ID=? Hibernate:



   /* update  models.menu.Product */ update
        GOODS
    set
        GOODS_BRAND=?,
        GOODS_CREATED=?,
        GOODS_DESCRIPTION=?,
        GOODS_IMAGE=?,
        GOODS_PRICE=?
    where
        GOODS_ID=? Hibernate:
/* create one-to-many row models.menu.Category.goods */ update
    GOODS
set
    GOODS_ID=?
where
    GOODS_ID=? [warn] o.h.e.j.s.SqlExceptionHelper - SQL Error: 1062, SQLState: 23000 [error] o.h.e.j.s.SqlExceptionHelper - Duplicate

关键字“Primary”[错误]应用程序的条目“|1”-

Answer 1

我可以修好它。

问题是，一对多的关系有一个@joincolumn而不是@joincable。这就是问题，当你代码数小时，你只是没有看到明显的。

感谢大家。