[Hibernate] How to map "decode" tables?
- From: Jim Garrison <jhg@xxxxxxxxxxxxxxx>
- Date: Thu, 08 Mar 2007 17:22:40 -0600
Many database schemas contain "code" tables that map
internal attribute values to external display strings.
For instance:
create table CODE_OS_TYPE
(
OS_TYPE varchar2(4) not null primary key,
DESCRIPTION varchar2(30) not null
);
Then in your entity tables you store only OS_TYPE code
create table CR_ASSET
(
ASSET_ID integer not null,
OS_TYPE varchar2(4) not null,
....
When mapping such a schema in Hibernate, what's the
recommended way of mapping these "code" relationships
from within the entity so that the Java object has
access to both the code and description?
In the above example, the CR_ASSET mapping might look like this:
<class name="Asset">
<id name="id" column="ASSET_ID" type="long">
...
</id>
<property name="osType" column="OS_TYPE" />
<property name="osDescription" ???what goes here??? />
This is one common use-case that doesn't appear to be covered in
the otherwise excellent (if poorly indexed) "Java Persistence
with Hibernate".
One option I considered was defining osDescription as a
derived property using the formula= attribute with a
correlated subselect. I'm concerned that this would result
in greatly reduced query efficiency... then again, maybe Oracle's
optimizer is smart enough to convert the subselect to a join.
Anybody have suggestions on how to implement this, or pointers
to where this is described?
.
- Follow-Ups:
- Re: [Hibernate] How to map "decode" tables?
- From: Axel Hallez
- Re: [Hibernate] How to map "decode" tables?
- From: Robert Klemme
- Re: [Hibernate] How to map "decode" tables?
- Prev by Date: Yellowfin, Java embeddable Business Intelligence Developer version
- Next by Date: New Venture - Great Opportunity - JAVA Engineer Needed
- Previous by thread: Yellowfin, Java embeddable Business Intelligence Developer version
- Next by thread: Re: [Hibernate] How to map "decode" tables?
- Index(es):