[b]Hibernate 3.0 Alpha[/b]

[b]Oracle 8i[/b]

I have following three classes.

Organization
Person
Roles

Above classes have mapping documents in which
Organization Class has a set of Persons (One to Many Relation)
Person class has set of Roles (Many to Many Relation)

Mapping contents of Organization Class
<set name="persons" table="CE_PERSON1" lazy="true">
<key column="CE_ORGANIZATIONID"/>
<one-to-many class="com.philips.ce.cemafore.fw.persistence.Person"/>
</set>

Mapping contents of Person Class
<set name="functionRoles" table="CE_PERSON_HASFUNCTION_ROLE1" lazy="true">
<key column="CE_PERSONID"/>
<many-to-many class="com.philips.ce.cemafore.fw.persistence.RoleObject" column="CE_ROLEID"/>
</set>

I wanted to find all the organizations along with the persons and corresponding roles of those persons in one single query.

I dont see any example where i can navigate two levels down using criteria or HQL api.

Basically i want to start finding organization with its related persons and roles related to those persons.

List data = session.createCriteria(Organization.class)
.setFetchMode("persons", FetchMode.EAGER).list();

Above code retrieves organization with its persons but how do i retrieve roles from person using FetchMode.EAGER.

Does anybody know how to do it using outer join on both levels with HQL or Criteria with single query.

You can't - only one eager fetch per query is possible.

Incorrect, only one _collection role_ fetch is allowed per query, avoiding cartesian product.

Tried implementing above scenario using HQL but noticed unwanted queries being executed. Could anyone explain why these queries are executed.

Mapping of Organization Class
-----------------------------------------
<!-- Parent Organization -->
<many-to-one name="parentOrganization" column="CE_PARENTID" class="com.philips.ce.cemafore.fw.persistence.Organization"/>

<!-- Child Organizations -->
<set name="childOrganizations" table="CE_ORGANIZATION1" inverse="true">
<key column="CE_PARENTID"/>
<one-to-many class="com.philips.ce.cemafore.fw.persistence.Organization"/>
</set>

<!-- Implementing Persons -->
<set name="persons" table="CE_PERSON1" lazy="true">
<key column="CE_ORGANIZATIONID"/>
<one-to-many class="com.philips.ce.cemafore.fw.persistence.Person"/>
</set>

Mapping of Person Class
-----------------------------------------
<set name="functionRoles" table="CE_PERSON_HASFUNCTION_ROLE1" lazy="true">
<key column="CE_PERSONID"/>
<many-to-many class="com.philips.ce.cemafore.fw.persistence.RoleObject" column="CE_ROLEID"/>
</set>


Below is the code used for above example.....

List data = session.createQuery("from Organization o left join fetch o.persons p left join fetch p.functionRoles").list();

for (Iterator it = data.iterator(); it.hasNext();) {
Organization org = (Organization) it.next();

System.out.println("\n");
System.out.println("Org = "+org);
Set persons = org.getPersons();
System.out.println("Persons = "+persons);

Iterator itr = persons.iterator();
while (itr.hasNext()) {
Person person = (Person) itr.next();
Set usesRoles = person.getFunctionRoles();
System.out.println("Function Roles = "+usesRoles);
}
}

I have no idea why the queries marked in red are executed, bcos no where in my code i have asked for parent or child organization.

Query marked in green to retrieve person from organization is repeated even inspite of same query being executed which are in blue color.
Blue color query retrieves all the organizations with its persons and their corresponding roles. So why do they query again to retrieve person (queries in green).

Could someone explain. Thanks in advance........


I have copied the hiberate log down here....


[color=blue]Hibernate: select organizati0_.MASTER_ID as MASTER_ID0_, persons1_.MASTER_ID as MASTER_ID1_, roleobject3_.MASTER_ID as MASTER_ID2_, organizati0_.HASREALID as HASREALID0_0_, organizati0_.CE_NAME as CE_NAME0_0_, organizati0_.CE_TYPE as CE_TYPE0_0_, organizati0_.CE_DESCRIPTION as CE_DESCR5_0_0_, organizati0_.MASTER_STATE as MASTER_S6_0_0_, organizati0_.MASTER_REASON as MASTER_R7_0_0_, organizati0_.MASTER_CREATEDBY as MASTER_C8_0_0_, organizati0_.MASTER_ORIGINATED as MASTER_O9_0_0_, organizati0_.MASTER_BEGINDATE as MASTER_10_0_0_, organizati0_.MASTER_MODIFIED as MASTER_11_0_0_, organizati0_.MASTER_ENDDATE as MASTER_12_0_0_, organizati0_.CE_ORIGINALID as CE_ORIG13_0_0_, organizati0_.CE_SYNCID as CE_SYNCID0_0_, organizati0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, organizati0_.CE_PARENTID as CE_PARE16_0_0_, persons1_.HASREALID as HASREALID1_1_, persons1_.CE_NAME as CE_NAME1_1_, persons1_.CE_TYPE as CE_TYPE1_1_, persons1_.CE_DESCRIPTION as CE_DESCR5_1_1_, persons1_.MASTER_STATE as MASTER_S6_1_1_, persons1_.MASTER_REASON as MASTER_R7_1_1_, persons1_.MASTER_CREATEDBY as MASTER_C8_1_1_, persons1_.MASTER_ORIGINATED as MASTER_O9_1_1_, persons1_.MASTER_BEGINDATE as MASTER_10_1_1_, persons1_.MASTER_MODIFIED as MASTER_11_1_1_, persons1_.MASTER_ENDDATE as MASTER_12_1_1_, persons1_.CE_FRISTNAME as CE_FRIS13_1_1_, persons1_.CE_MIDDLENAME as CE_MIDD14_1_1_, persons1_.CE_LASTNAME as CE_LAST15_1_1_, persons1_.CE_DELEGATE as CE_DELE16_1_1_, persons1_.CE_EMAILADDRESS as CE_EMAI17_1_1_, persons1_.CE_ORIGINALID as CE_ORIG18_1_1_, persons1_.CE_WORKPHONENUMBER as CE_WORK19_1_1_, persons1_.CE_FUNCTION as CE_FUNC20_1_1_, persons1_.CE_ISACTIVE as CE_ISAC21_1_1_, persons1_.CE_SYNCID as CE_SYNCID1_1_, persons1_.CE_ORGANIZATIONID as CE_ORGA23_1_1_, roleobject3_.HASREALID as HASREALID5_2_, roleobject3_.CE_NAME as CE_NAME5_2_, roleobject3_.CE_TYPE as CE_TYPE5_2_, roleobject3_.CE_DESCRIPTION as CE_DESCR5_5_2_, roleobject3_.MASTER_STATE as MASTER_S6_5_2_, roleobject3_.MASTER_REASON as MASTER_R7_5_2_, roleobject3_.MASTER_CREATEDBY as MASTER_C8_5_2_, roleobject3_.MASTER_ORIGINATED as MASTER_O9_5_2_, roleobject3_.MASTER_BEGINDATE as MASTER_10_5_2_, roleobject3_.MASTER_MODIFIED as MASTER_11_5_2_, roleobject3_.MASTER_ENDDATE as MASTER_12_5_2_, roleobject3_.CE_DERIVEDFROM as CE_DERI13_5_2_, roleobject3_.CE_ORIGINALID as CE_ORIG14_5_2_, roleobject3_.CE_SYNCID as CE_SYNCID5_2_, roleobject3_.CE_ORGANIZATIONID as CE_ORGA16_5_2_, functionro2_.CE_PERSONID as CE_PERSO1___, functionro2_.CE_ROLEID as CE_ROLEID__ from CE_ORGANIZATION1 organizati0_, CE_PERSON1 persons1_, CE_PERSON_HASFUNCTION_ROLE1 functionro2_, CE_ROLE1 roleobject3_ where organizati0_.MASTER_ID=persons1_.CE_ORGANIZATIONID(+) and persons1_.MASTER_ID=functionro2_.CE_PERSONID(+) and functionro2_.CE_ROLEID=roleobject3_.MASTER_ID(+)[/color]

[color=red]Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?

Hibernate: select childorgan0_.CE_PARENTID as CE_PARE16___, childorgan0_.MASTER_ID as MASTER_ID__, childorgan0_.MASTER_ID as MASTER_ID0_, childorgan0_.HASREALID as HASREALID0_0_, childorgan0_.CE_NAME as CE_NAME0_0_, childorgan0_.CE_TYPE as CE_TYPE0_0_, childorgan0_.CE_DESCRIPTION as CE_DESCR5_0_0_, childorgan0_.MASTER_STATE as MASTER_S6_0_0_, childorgan0_.MASTER_REASON as MASTER_R7_0_0_, childorgan0_.MASTER_CREATEDBY as MASTER_C8_0_0_, childorgan0_.MASTER_ORIGINATED as MASTER_O9_0_0_, childorgan0_.MASTER_BEGINDATE as MASTER_10_0_0_, childorgan0_.MASTER_MODIFIED as MASTER_11_0_0_, childorgan0_.MASTER_ENDDATE as MASTER_12_0_0_, childorgan0_.CE_ORIGINALID as CE_ORIG13_0_0_, childorgan0_.CE_SYNCID as CE_SYNCID0_0_, childorgan0_.CE_ADMINISTRATOR as CE_ADMI15_0_0_, childorgan0_.CE_PARENTID as CE_PARE16_0_0_ from CE_ORGANIZATION1 childorgan0_ where childorgan0_.CE_PARENTID=?[/color]

System out from above program
------------------------------------------------
Org = com.philips.ce.cemafore.fw.persistence.Organization@1deeb40
[color=green]Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?[/color]
Persons = [com.philips.ce.cemafore.fw.persistence.Person@cafb56]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@3ae941]


Org = com.philips.ce.cemafore.fw.persistence.Organization@12f9ee
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@1d6a56e]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@106fc94]


Org = com.philips.ce.cemafore.fw.persistence.Organization@1b06041
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@7f5580]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@6f9b8e]


Org = com.philips.ce.cemafore.fw.persistence.Organization@14db0e3
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@676437]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@1e4853f]


Org = com.philips.ce.cemafore.fw.persistence.Organization@1e808ca
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@992bae]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@2bd3a]


Org = com.philips.ce.cemafore.fw.persistence.Organization@26d607
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@1ad98ef]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@138c63]


Org = com.philips.ce.cemafore.fw.persistence.Organization@165f738
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@149b290]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@16a38b5]


Org = com.philips.ce.cemafore.fw.persistence.Organization@55a338
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@4ee70b]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@22ab57]


Org = com.philips.ce.cemafore.fw.persistence.Organization@1eec35
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@25c828]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@77ef83]


Org = com.philips.ce.cemafore.fw.persistence.Organization@d85cc
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = [com.philips.ce.cemafore.fw.persistence.Person@1cb52ae]
Function Roles = [com.philips.ce.cemafore.fw.persistence.RoleObject@1a12495]


Org = com.philips.ce.cemafore.fw.persistence.Organization@68c26c
Hibernate: select persons0_.CE_ORGANIZATIONID as CE_ORGA23___, persons0_.MASTER_ID as MASTER_ID__, persons0_.MASTER_ID as MASTER_ID0_, persons0_.HASREALID as HASREALID1_0_, persons0_.CE_NAME as CE_NAME1_0_, persons0_.CE_TYPE as CE_TYPE1_0_, persons0_.CE_DESCRIPTION as CE_DESCR5_1_0_, persons0_.MASTER_STATE as MASTER_S6_1_0_, persons0_.MASTER_REASON as MASTER_R7_1_0_, persons0_.MASTER_CREATEDBY as MASTER_C8_1_0_, persons0_.MASTER_ORIGINATED as MASTER_O9_1_0_, persons0_.MASTER_BEGINDATE as MASTER_10_1_0_, persons0_.MASTER_MODIFIED as MASTER_11_1_0_, persons0_.MASTER_ENDDATE as MASTER_12_1_0_, persons0_.CE_FRISTNAME as CE_FRIS13_1_0_, persons0_.CE_MIDDLENAME as CE_MIDD14_1_0_, persons0_.CE_LASTNAME as CE_LAST15_1_0_, persons0_.CE_DELEGATE as CE_DELE16_1_0_, persons0_.CE_EMAILADDRESS as CE_EMAI17_1_0_, persons0_.CE_ORIGINALID as CE_ORIG18_1_0_, persons0_.CE_WORKPHONENUMBER as CE_WORK19_1_0_, persons0_.CE_FUNCTION as CE_FUNC20_1_0_, persons0_.CE_ISACTIVE as CE_ISAC21_1_0_, persons0_.CE_SYNCID as CE_SYNCID1_0_, persons0_.CE_ORGANIZATIONID as CE_ORGA23_1_0_ from CE_PERSON1 persons0_ where persons0_.CE_ORGANIZATIONID=?
Persons = []