• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven

Hibernate on DB's w/o Primary Keys

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey All -

This is my first post here, so go easy on me

The system I am working on has 2 main databases (we'll call them DB1 and DB2), with tables spread among several schemas. DB2 is accessed via synonyms in DB1, so the application only logs into DB1. To complicate things, tables in DB1 have foreign key mappings into tables in DB2. The tables in DB2 don't have primary keys, only unique indexes.

So, middlegen is not giving me very accurate HBM files. It is basically giving me a class that has no relation to any other table, and it has a composite-id made out of every column.

Has anyone out there dealt with this? I'm not really sure what other information you might need to help me with this, so please ask if I left some stuff out (which I'm sure I did).

Thanks a ton!
Lavie
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to JavaRanch Lavie

Unique indices should be enough to uniquely identify rows, so the lack of PKs shouldn't be an issue in that regards. You can map your id property to the fields in the unique index and use an "assigned" key generator.

Of course, you can't have any real referential integrity if you don't use PKs, so that is presumably why middlegen is not producing mapping files with associations. I'd revert to manually writing your mapping files. A little tedious, but if you don't have a proper relational data model to work with there is not much else you can do I'm afraid.
 
Lavie Tobey
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I was afraid of that

Thanks for the response!
 
No one can make you feel inferior without your consent - Eleanor Roosevelt. tiny ad:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic