We have a mapping file that that has a joined subclass. Here is the dilema.
Inside the subclass, there is a ID field that is the primary key of that
table. Then there is a bag that uses another class. That class has its own
ID field.
Here is a rough idea of the mapping file.
Employee is joined to User by the EmployeeID and User is joined to
DomainUser via the UserID
<class name="Employee" table="Employee ">
<id name="EmployeeI D" column="Employe eID">
<generator class="assigned "/>
</id>
<joined-subclass name="User" table="Users">
<key column="Employe eID" />
<bag name="DomainUse rs">
<key column="UserID" />
<one-to-many class="DomainUs er" />
</bag>
</joined-subclass>
</class>
What we are trying to accomplish is retreving the employee based on the
DomainUserName. I am able to look it up and retreive the correct UserID from
the domain table but it appears to look that value up in the Users table,
however it appears to think that is the EmployeeID instead of the userID. I
need to query the table for the EmployeeID with the UserID that is returned
from the DomainUser table. Any advice. We are a bit stumped. Any help is
appreciated.
TIA,
~CK
Inside the subclass, there is a ID field that is the primary key of that
table. Then there is a bag that uses another class. That class has its own
ID field.
Here is a rough idea of the mapping file.
Employee is joined to User by the EmployeeID and User is joined to
DomainUser via the UserID
<class name="Employee" table="Employee ">
<id name="EmployeeI D" column="Employe eID">
<generator class="assigned "/>
</id>
<joined-subclass name="User" table="Users">
<key column="Employe eID" />
<bag name="DomainUse rs">
<key column="UserID" />
<one-to-many class="DomainUs er" />
</bag>
</joined-subclass>
</class>
What we are trying to accomplish is retreving the employee based on the
DomainUserName. I am able to look it up and retreive the correct UserID from
the domain table but it appears to look that value up in the Users table,
however it appears to think that is the EmployeeID instead of the userID. I
need to query the table for the EmployeeID with the UserID that is returned
from the DomainUser table. Any advice. We are a bit stumped. Any help is
appreciated.
TIA,
~CK