Hi,
Hibernate is generating this huge query and I am concerned something is wrong. I am using the table per subclass. My config file is at the bottom. Is this normal?
Thanks
06:30:27,638 INFO [STDOUT] Hibernate: select facilities0_.repositoryID as reposito2___, facilities0_.RID as RID__, facilitie
s0_.RID as RID1_, facilities0_1_.lastModifiedDate as lastModi3_7_1_, facilities0_1_.createdDate as createdD4_7_1_, facilities
0_1_.sid as sid7_1_, facilities0_1_.name as name7_1_, facilities0_1_.description as descript7_7_1_, facilities0_1_.isSecurity
PolicyInherited as isSecuri8_7_1_, facilities0_1_.securityPolicyID as security9_7_1_, facilities0_1_.ownerID as ownerID7_1_,
facilities0_1_.createdByID as created11_7_1_, facilities0_1_.lastModifiedByID as lastMod12_7_1_, facilities0_1_.typeDescripti
onID as typeDes13_7_1_, facilities0_1_.itemWorkspaceID as itemWor14_7_1_, facilities0_1_.itemProjectID as itemPro15_7_1_, fac
ilities0_.repositoryID as reposito2_8_1_, item1_.RID as RID0_, item1_.lastModifiedDate as lastModi3_7_0_, item1_.createdDate
as createdD4_7_0_, item1_.sid as sid7_0_, item1_.name as name7_0_, item1_.description as descript7_7_0_, item1_.isSecurityPol
icyInherited as isSecuri8_7_0_, item1_.securityPolicyID as security9_7_0_, item1_.ownerID as ownerID7_0_, item1_.createdByID
as created11_7_0_, item1_.lastModifiedByID as lastMod12_7_0_, item1_.typeDescriptionID as typeDes13_7_0_, item1_.itemWorkspac
eID as itemWor14_7_0_, item1_.itemProjectID as itemPro15_7_0_, item1_1_.repositoryID as reposito2_8_0_, item1_2_.facilityID a
s facilityID9_0_, case when item1_1_.RID is not null then 1 when item1_2_.RID is not null then 2 when item1_3_.RID is not nul
l then 3 when item1_4_.RID is not null then 4 when item1_5_.RID is not null then 5 when item1_6_.RID is not null then 6 when
item1_7_.RID is not null then 7 when item1_8_.RID is not null then 8 when item1_9_.RID is not null then 9 when item1_10_.RID
is not null then 10 when item1_11_.RID is not null then 11 when item1_12_.RID is not null then 12 when item1_13_.RID is not n
ull then 13 when item1_14_.RID is not null then 14 when item1_15_.RID is not null then 15 when item1_16_.RID is not null then
16 when item1_17_.RID is not null then 17 when item1_18_.RID is not null then 18 when item1_19_.RID is not null then 19 when
item1_20_.RID is not null then 20 when item1_21_.RID is not null then 21 when item1_.RID is not null then 0 end as clazz_0_
from IFacility facilities0_ inner join IItem facilities0_1_ on facilities0_.RID=facilities0_1_.RID left outer join IItem item
1_ on facilities0_.RID=item1_.RID left outer join IFacility item1_1_ on item1_.RID=item1_1_.RID left outer join IWorkspace it
em1_2_ on item1_.RID=item1_2_.RID left outer join IProject item1_3_ on item1_.RID=item1_3_.RID left outer join IFolder item1_
4_ on item1_.RID=item1_4_.RID left outer join IMilestoneList item1_5_ on item1_.RID=item1_5_.RID left outer join IMilestone i
tem1_6_ on item1_.RID=item1_6_.RID left outer join ITaskList item1_7_ on item1_.RID=item1_7_.RID left outer join ITask item1_
8_ on item1_.RID=item1_8_.RID left outer join ISurvey item1_9_ on item1_.RID=item1_9_.RID left outer join ISchedule item1_10_
on item1_.RID=item1_10_.RID left outer join IEvent item1_11_ on item1_.RID=item1_11_.RID left outer join IDocument item1_12_
on item1_.RID=item1_12_.RID left outer join IVersion item1_13_ on item1_.RID=item1_13_.RID left outer join IBookmark item1_1
4_ on item1_.RID=item1_14_.RID left outer join IForum item1_15_ on item1_.RID=item1_15_.RID left outer join ITopic item1_16_
on item1_.RID=item1_16_.RID left outer join IInbox item1_17_ on item1_.RID=item1_17_.RID left outer join IEmail item1_18_ on
item1_.RID=item1_18_.RID left outer join IContact item1_19_ on item1_.RID=item1_19_.RID left outer join INews item1_20_ on it
em1_.RID=item1_20_.RID left outer join INote item1_21_ on item1_.RID=item1_21_.RID where facilities0_.repositoryID=?
<hibernate-mapping>
<class name="com.intaglio.server.api.hibernate.Item" table="IItem" dynamic-update="true">
<id name="id" type="long">
<column name="RID" sql-type="bigint" not-null="true"/>
<generator class="native"/>
</id>
<discriminator column="contentType" type="string"/>
<timestamp name="lastModifiedDate" column="lastModifiedDate"/>
<property name="createdDate" type="calendar" update="false" not-null="false">
<column name="createdDate" sql-type="timestamp"/>
</property>
<property name="sid" type="string" not-null="true" unique="true">
<column name="sid" sql-type="varchar" length="255"/>
</property>
<property name="name" type="string" not-null="true">
<column name="name" sql-type="varchar" length="50"/>
</property>
<property name="description" type="string" not-null="false">
<column name="description" sql-type="varchar" length="255"/>
</property>
<property name="isSecurityPolicyInherited" type="boolean" not-null="false">
<column name="isSecurityPolicyInherited" sql-type="tinyint"/>
</property>
<one-to-one name="parent" class="com.intaglio.server.api.hibernate.Item" foreign-key="parentID"/>
<many-to-one name="securityPolicy" class="com.intaglio.server.api.hibernate.SecurityPolicy" column="securityPolicyID" not-null="false"/>
<many-to-one name="owner" class="com.intaglio.server.api.hibernate.User" column="ownerID" not-null="true"/>
<many-to-one name="createdByUser" class="com.intaglio.server.api.hibernate.User" column="createdByID" update="false" not-null="true"/>
<many-to-one name="lastModifiedByUser" class="com.intaglio.server.api.hibernate.User" column="lastModifiedByID" update="false" not-null="true"/>
<many-to-one name="typeDescription" class="com.intaglio.server.api.hibernate.TypeDescription" column="typeDescriptionID" not-null="false"/>
<many-to-one name="itemWorkspace" class="com.intaglio.server.api.hibernate.Workspace" column="itemWorkspaceID" not-null="false"/>
<many-to-one name="itemProject" class="com.intaglio.server.api.hibernate.Project" column="itemProjectID" not-null="false"/>
<joined-subclass name="com.intaglio.server.api.hibernate.Facility" table="IFacility" >
<key column="RID"/>
<set name="workspaces" table="IWorkspace" lazy="true" inverse="true">
<key column="facilityID"/>
<one-to-many class="com.intaglio.server.api.hibernate.Workspace"/>
</set>
<many-to-one name="repository" class="com.intaglio.server.api.hibernate.Repository" column="repositoryID" not-null="false"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Workspace" table="IWorkspace" >
<key column="RID"/>
<many-to-one name="facility" class="com.intaglio.server.api.hibernate.Facility" column="facilityID" not-null="false"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Project" table="IProject" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Folder" table="IFolder" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.MilestoneList" table="IMilestoneList" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Milestone" table="IMilestone" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.TaskList" table="ITaskList" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Task" table="ITask" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Survey" table="ISurvey" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Schedule" table="ISchedule" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Event" table="IEvent" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Document" table="IDocument" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Version" table="IVersion" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Bookmark" table="IBookmark" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Forum" table="IForum" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Topic" table="ITopic" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Inbox" table="IInbox" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Email" table="IEmail" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Contact" table="IContact" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.News" table="INews" >
<key column="RID"/>
</joined-subclass>
<joined-subclass name="com.intaglio.server.api.hibernate.Note" table="INote" >
<key column="RID"/>
</joined-subclass>
</class>
</hibernate-mapping>
|