Hi there, You can map this in Cayenne via "flattened attributes" across a DbRelationship.
You'd start by mapping both tables as DbEntities, and creating 1..1 DbRelationship between them. After that you map Users ObjEntity, and then add "flattened attributes" to it, mapped to the related DbEntity columns. You can check vertical inheritance article for the details of this technique (even though you don't have inheritance here, flattened attributes are mapped similarly) : http://cayenne.apache.org/doc30/modeling-vertical-inheritance.html Cheers, Andrus On Nov 15, 2011, at 7:11 PM, [email protected] wrote: > Suppose that in legacy schema,that you are working on getting > Cayenne to work with, you aren't keeping all the information about > user with the user's main information in the users table, but in a > separate table. > > For example: > > <<table users>> > id > firstname > lastname > > <<table accounts>> > user_id <<PK>><<FK>> > username > password > email > > In my domain I wish to have User model with all properties firstname,lastname, > username,email,password > without create class model related to accounts table and relative > association. Is there a way to do this with Cayenne ? can someone please show > me a xml example? > > > >
