• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

OneToOne composite key

 
Ranch Hand
Posts: 580
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I get this failure by mapping a OneToOne-Relationship:



The ProductID of table Product is a composite key which has the SAME Columns than the composite key ItemID in table Item:







This HQL works and returns the item-instance of a product:



This HQL does not work and returns the exception:







Instead of JoinColumn, I have tried it with PrimaryKeyJoinColumns (the same exception occurs):



(Another point is, when I annotate the @OneToOne above the getter instead above the field, then Hibernate totally ignores my OneToOne-Mapping and recognices the Item-Instance (or Product-Instance) as a column instead of a relationship, hence it produces false sql-selects)


I have also tried to use the PrimaryKeyJoinColumns-Relation in Class Product:



and delete the relation in Class Item
(to make the oneToOne at least unidirectional):



Doing that HQL:



returns the same failure:



Do I have to use Hibernates ForeignGenerator within my Item-Class (I have a composite key!) ?:




Please, can you say me: What is wrong with my mapping?


It is really hard to believe that such a OneToOne-Mapping with a composite key is so hard to implement by using ORM (Hibernate).
Such relationships are very common.
 
A lot of people cry when they cut onions. The trick is not to form an emotional bond. This tiny ad told me:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic