this is what i got at the database:

table1(person_city_mapping)
column1(person_id)
column2(person_city_id)

table2(cities)
column1(city_id)
column2(city_names)


table3(persons)
column1(persons_id)
column2(persons_names)



in java i want to have following classe:

class person{//all other properties are set (e.g. id and so on)

public City getCity();


}


how it is possible to realize this trough xdoclet?

if any idea thanx....

xdoclet comes with examples, it's not that difficult to figure out.

the difficulty is not set on how to use xdoclet.....
the problem is to get an object mapped trough a third table...
your answer did'nt help me....;-)

You can't
Your remlational model describe a n-n association and you want to map it as a 1-n in your domain model. This is not possible.
But you can write a getter/Setter delegating to an hidden n-n relationship

yup sorry, I misinterpreted what you had said. I agree with emmanuel, your datamodel doesn't match your object model. But if you really want city to a many-to-one off of person, maybe you should drop the person_city_mapping table and add a city_id column to the persons table.

if i drop that table , i would need a new job.....;-)
i prefer the getter method, thanx anyway (really, thx)