[castor-dev] mapping single table to multiple classes

[Maring, Steve]

I've come up with the following cheezy example to illustrate conceptually
what it is that I am trying to do:

Imagine that you have been provided the following table schema:

create table populations (      stateName       varchar(20) primary key,
                                cityName        varchar(20) primary key,
                                statePopulation int,
                                cityPopulation  int )

and you have to unmarshal this from Java objects into XML that looks like
this:

<populations>
        <state>
                <name></name>
                <population></population>
                <city>
                        <name></name>
                        <population></population>
                </city>
                <city>
                        <name></name>
                        <population></population>
                </city>
        </state>
        <state>
                ...
        </state>
</populations>

So you would basically end up with a Populations, State, and City java bean
objects.

Since mappings appear to be class based, I will end up with three classes,
two of which are mapped to different fields in the same table.

How do I populate the objects?  Will an OQL query let me do this?

Thanks.
-Steve Maring

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev