I hate to use up a credit on this but I am perplexed with whether I can do exactly this complex mapping - I can only find simple example in books, forums and the net
Requirements
** One person has many addresses **
** Address knows nothing of person **
** Lets keep model/schema sensible: Two classes, two tables **
** One <business, ..etc > has many addresses **
class Person {
private int id;
private String name;
private AddressList addresses;
}
class Address {
private int addressType;
private String street;
}
class AddressList implements Iterable {
private List<Address> list = new List<Address>();
public Iterator<Address> iterator() {
}
}
create table person (
person_id number primary key,
name varchar(30)
)
create table address (
address_id number primary key,
foreign_table_id number,
foreign_table_name varchar(30),
street varchar(255)
)
insert into person (100,'Tim');
insert into address (1,100,'PERSON','166 myavenue')
Is it even possible to map these together???
|