Is there any examples of using inverse relationships in CB, I am
finding it hard to get my head around using my link tables in CB. for
example updating or getting a recorded and its relationships.
so say I have a user and that user belongs to a company. my user.cfc
looks a bit like this...
/* link tables */
property name="user" fieldtype="many-to-many" CFC="company"
inversejoincolumn="com_id" lazy="true" cascade="all" orderby="com_id";
this creates the look up table "user2company"
now say I want to find a user and the company they belong to, would
userService.executeQuery("from user as userTable inner join
userTable.com_id as companyID");
not sure I am getting it despite reading lots. could someone explain
in the context of CB.
second on updating a new user how does hibernate know what to update/
add in the link table? does hiernate handle this or do I manually
update this table?