Suggstion needed for mapping of a composite field

tnguyen · **Joined:** Mon Sep 08, 2003 12:32 pm **Posts:** 10

Hi,
My table has a field that is a concatenation of several fields.
For example: "HTL34GLOBAL".
It is composed of "HTL" + "34" + "GLOBAL".

I have 2 questions:

1. How do I map this field into the 3 sub-fields.?
2. What's the best way to do a search on any combination of the subfields?

thx
tom nguyen/

emmanuel · **Posted:** Fri Nov 21, 2003 3:29 am

Code:

<composite-id>
        <key-property name="medicareNumber"/>
        <key-property name="dependent"/>
</composite-id>

See section 4.1.5 of the reference guide

Code:

from bank.Person person
where person.id.country = 'AU' 
    and person.id.medicareNumber = 123456

Where country and medicareNumber are properties of the composite-id

emmanuel · **Posted:** Fri Nov 21, 2003 3:48 am

And override equals() and hashCode()