How can I map insert false update false on a composite-id key-property which is also used in a one-to-many FK

Question

I am working on a legacy code base with an existing DB schema  The existing code uses SQL and PL SQL to execute queries on the DB  We have been tasked with making a small part of the project database-engine agnostic  at first  change everything eventually   We have chosen to use Hibernate 3 3 2 GA and    hbm xml  mapping files  as opposed to annotations   Unfortunately  it is not feasible to change the existing schema because we cannot regress any legacy features   The problem I am encountering is when I am trying to map a uni-directional  one-to-many relationship where the FK is also part of a composite PK  Here are the classes and mapping file     CompanyEntity java  public class CompanyEntity       private Integer id      private Set lt CompanyNameEntity gt  names              CompanyNameEntity java  public class CompanyNameEntity implements Serializable       private Integer id      private String languageId      private String name              CompanyNameEntity hbm xml   lt  xml version  1 0   gt   lt  DOCTYPE hibernate-mapping PUBLIC          -  Hibernate Hibernate Mapping DTD 3 0  EN           http   www jboss org dtd hibernate hibernate-mapping-3 0 dtd  gt    lt hibernate-mapping package  com example  gt        lt class name  com example CompanyEntity  table  COMPANY  gt           lt id name  id  column  COMPANY ID   gt           lt set name  names  table  COMPANY NAME  cascade  all-delete-orphan  fetch  join  batch-size  1  lazy  false  gt               lt key column  COMPANY ID   gt               lt one-to-many entity-name  vendorName   gt           lt  set gt       lt  class gt        lt class entity-name  companyName  name  com example CompanyNameEntity  table  COMPANY NAME  gt           lt composite-id gt               lt key-property name  id  column  COMPANY ID   gt               lt key-property name  languageId  column  LANGUAGE ID   gt           lt  composite-id gt           lt property name  name  column  NAME  length  255   gt       lt  class gt    lt  hibernate-mapping gt    This code works just fine for SELECT and INSERT of a Company with names  I encountered a problem when I tried to update and existing record  I received a BatchUpdateException and after looking through the SQL logs I saw Hibernate was trying to do something stupid     update COMPANY NAME set COMPANY ID null where COMPANY ID     Hibernate was trying to dis-associate child records before updating them  The problem is that this field is part of the PK and not-nullable  I found the quick solution to make Hibernate not do this is to add  not-null  true   to the  key  element in the parent mapping  SO now may mapping looks like this     CompanyNameEntity hbm xml   lt  xml version  1 0   gt   lt  DOCTYPE hibernate-mapping PUBLIC          -  Hibernate Hibernate Mapping DTD 3 0  EN           http   www jboss org dtd hibernate hibernate-mapping-3 0 dtd  gt    lt hibernate-mapping package  com example  gt        lt class name  com example CompanyEntity  table  COMPANY  gt           lt id name  id  column  COMPANY ID   gt           lt set name  names  table  COMPANY NAME  cascade  all-delete-orphan  fetch  join  batch-size  1  lazy  false  gt               lt key column  COMPANY ID  not-null  true   gt               lt one-to-many entity-name  vendorName   gt           lt  set gt       lt  class gt        lt class entity-name  companyName  name  com example CompanyNameEntity  table  COMPANY NAME  gt           lt composite-id gt               lt key-property name  id  column  COMPANY ID   gt               lt key-property name  languageId  column  LANGUAGE ID   gt           lt  composite-id gt           lt property name  name  column  NAME  length  255   gt       lt  class gt    lt  hibernate-mapping gt    This mapping gives the exception     org hibernate MappingException  Repeated column in mapping for entity  companyName column  COMPANY ID  should be mapped with insert  false  update  false     My problem now is that I have tryed to add these attributes to the key-property element but that is not supported by the DTD  I have also tryed changing it to a key-many-to-one element but that didn t work either  So     How can I map  insert  false  update  false   on a composite-id key-property which is also used in a one-to-many FK

User · Accepted Answer

I think the annotation you are looking for is:

public class CompanyName implements Serializable {
//...
@JoinColumn(name = "COMPANY_ID", referencedColumnName = "COMPANY_ID", insertable = false, updatable = false)
private Company company;

And you should be able to use similar mappings in a hbm.xml as shown here (in 23.4.2):

http://docs.jboss.org/hibernate/core/3.3/reference/en/html/example-mappings.html

User · Answer

Dino TW  has provided the link to the comment Hibernate Mapping Exception   Repeated column in mapping for entity which has the vital information   The link hints to provide  inverse true  in the set mapping  I tried it and it actually works  It is such a rare situation wherein a Set and Composite key come together  Make inverse true  we leave the insert  amp  update of the table with Composite key to be taken care by itself   Below can be the required mapping     lt class name  com example CompanyEntity  table  COMPANY  gt       lt id name  id  column  COMPANY ID   gt       lt set name  names  inverse  true  table  COMPANY NAME  cascade  all-delete-orphan  fetch  join  batch-size  1  lazy  false  gt           lt key column  COMPANY ID  not-null  true   gt           lt one-to-many entity-name  vendorName   gt       lt  set gt   lt  class gt

[hibernate-mapping] How can I map "insert='false' update='false'" on a composite-id key-property which is also used in a one-to-many FK?

Examples related to hibernate-mapping

Examples related to hbm

Examples related to hibernate-onetomany

Examples related to hbmxml