• 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
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

special hibernate mapping

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I have a special case of data model, which is the following:
1- I have a table where my entities, i.e table names are stored:
CREATE TABLE [Entity_tbl]
( [id] [INT] NOT NULL , -- (PK)
[name] [NVARCHAR] NOT NULL
)

2- I have a table where I store values, which it's used by
any entity, for instance [Status] value
CREATE TABLE [Status_tbl]
( [id] [INT] NOT NULL , -- (PK)
[name] [NVARCHAR] NOT NULL
)

3- I have a table where I store values assigned to a specific
entity instance:
CREATE TABLE [Entity_Status_tbl]
( [entity_id] [INT] NOT NULL, -- (FK = [Entity_tbl].[id])
[instance_id] [INT] NOT NULL, --
[status_id] [INT] NOT NULL -- (FK = [Status_tbl].[id])
)
4- I have others tables which are considered as entities which
they handle the instances, for example a concrete entities
[Service], [Resource]
CREATE TABLE [Service_tbl]
( [id] [INT] NOT NULL , -- (PK)
[name] [NVARCHAR] NOT NULL
)

CREATE TABLE [Resource_tbl]
( [id] [INT] NOT NULL , -- (PK)
[name] [NVARCHAR] NOT NULL,
)

Having this model, I can assign a status value to any service or resource created instance, without changing [Service_tbl] and [Resource_tbl] schema.

In fact, the references (one-to-one or one-to-many) between [Service_tbl], [Resource_tbl] and [Entity_Status_tbl] could be described as following:
[Service_tbl].[id] = [Entity_Status_tbl].[instance_id]
AND
[Entity_Status_tbl].[entity_id] = id of the entity service stored
in [Entity_tbl]

[Resource_tbl].[id] = [Entity_Status_tbl].[instance_id]
AND
[Entity_Status_tbl].[entity_id] = id of the entity resource stored
in [Entity_tbl]

MY QUESTION: How I exprime these references?

THANKS A LOT.
[ February 08, 2005: Message edited by: Djamel Djemaoun ]
 
Ranch Hand
Posts: 156
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Not sure what you're asking. Do you want to map the schema you describe using Hibernate?
 
Djamel Djemaoun
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Loren Rosen:
Not sure what you're asking. Do you want to map the schema you describe using Hibernate?



--------------------------------------------------------------------------


Thanks Loren for your reply.

Ya, I want to map the schema knowing the table [Entity_Status_tbl] is kepting to references:
- one to the entity willing to support [Status]
- other to the entity instance specifing a value of [Status].

I want to have the comportment:
1- [Entity_Status_tbl] referes to [Service_tbl] when [entity_id] = to [Entity_tbl].[id] (already known value, let say 75).
2- [Entity_Status_tbl] referes to [Resource_tbl] when [entity_id] = to [Entity_tbl].[id] (already known value, let say 25).
3- All this info will be stored in XML mappings

I hope my additional info could help you to help me.

Best Regards.
 
That which doesn't kill us makes us stronger. I think a piece of pie wouldn't kill me. Tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic