Hi,

This is perhaps a silly question. I need to optimize the selects to the database. I only need this when serching for Incident objects. Problem is that this object have lots of dependencies and therefore hibernate picks up all objects. This makes, in a web enviroment, that all forms that show or modify an Incident object go very slowly and sometimes just crack down.

Is there any property that forces an objet's search to only pick up the information on the object's table?This is, not persist the other objects that are involved

I'm using hibernate 2.1, Microsoft SQLServer 8.00.194

this is my mapping document:

[code]
<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<class name="attend.entity.User" table="hk_users" >

<id name="id" column="usr_userid" type="int" unsaved-value="null">
<generator class="assigned" />
</id>
<property name="userName" column="usr_usrnme" type="string" />
<property name="fullName" column="usr_fulnme" type="string" />
<property name="firstname" column="usr_finame" type="string" />
<property name="secondname" column="usr_sename" type="string" />
<property name="thirdname" column="usr_thname" type="string" />
<property name="nif" column="usr_usrnif" type="string" />
<property name="password" column="usr_passwrd" type="string" />
<property name="idClient" column="usr_idclie" type="string" />
<property name="idTech" column="usr_idtech" type="string" />
<property name="language" column="usr_usrlan" type="string" />
<property name="country" column="usr_contry" type="string" />

<set name="rols" table="hk_rolematch" lazy="false" cascade="none">
<key column="rmt_userid" />
<element column="rmt_roleid" type="string"/>
</set>

<set name="action_perm" table="hk_actionst" lazy="false" cascade="none">
<key column="act_userid" />
<element column="act_actpid" type="string" />
</set>

<property name="active" column="usr_usract" type="string" />
<property name="observations" column="usr_usrobs" type="string" />
</class>



<class name="attend.entity.Technician" table="hk_technicians">
<id name="code" column="tec_teccod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>

<property name="firstname" column="tec_finame" type="string" />
<property name="secondname" column="tec_sename" type="string" />
<property name="thirdname" column="tec_thname" type="string" />
<property name="nif" column="tec_tecnif" type="string" />
<property name="fullName" column="tec_funame" type="string" />
<property name="type" column="tec_tectyp" type="string" />
<many-to-one name="main" column="tec_lomain" class="attend.entity.LocClient" cascade="none" />

<set name="locations" table="hk_locclient" lazy="false" where="clo_clotyp='T'" cascade="none">
<key column="clo_clocod" />
<one-to-many class="attend.entity.LocClient" />
</set>

<set name="groupCode" table="hk_techgroup" lazy="false" cascade="none">
<key column="tgr_teccod" />
<many-to-many column="tgr_grpcod" class="attend.entity.Group" />
</set>

<property name="observations" column="tec_tecobs" type="string" />

<property name="iduser" column="tec_tecnid" type="int" />
<property name="active" column="tec_tecact" type="string" />

<set name="manager" table="hk_mnggroup" lazy="false" cascade="none">
<key column="mng_teccod" />
<many-to-many column="mng_grpcod" class="attend.entity.Group" />
</set>
</class>

<class name="attend.entity.Role" table="hk_roles">
<id name="id" column="rol_roleid" type="string">
<generator class="assigned" />
</id>
<!--<property name="name" column="rol_roldes" type="string" />-->
</class>

<class name="attend.entity.Incident" table="hk_incident">
<id name="id" column="inc_inccod" type="int">
<generator class="assigned" />
</id>
<property name="entryDate" column="inc_entdat" type="timestamp" />
<property name="resDate" column="inc_resdat" type="timestamp" />
<property name="asigDate" column="inc_asgdat" type="timestamp" />
<property name="transDate" column="inc_trfdat" type="timestamp" />
<property name="retentDate" column="inc_retdat" type="timestamp" />
<property name="returnDate" column="inc_rtudat" type="timestamp" />
<property name="clsDate" column="inc_clsdat" type="timestamp" />
<property name="releaseDate" column="inc_reldat" type="timestamp" />
<property name="cauDate" column="inc_caudat" type="timestamp" />
<property name="anuDate" column="inc_anudat" type="timestamp" />
<property name="finalizeDate" column="inc_findat" type="timestamp" />
<property name="answerLimit" column="inc_anslim" type="timestamp" />
<property name="resolutionLimit" column="inc_reslim" type="timestamp" />
<property name="answerLimitI" column="inc_anslii" type="timestamp" />
<property name="resolutionLimitI" column="inc_reslii" type="timestamp" />
<property name="state" column="inc_incstt" type="string" />
<property name="retenCode" column="inc_rtacod" type="string" />
<many-to-one name="clsCode" column="inc_clscod" class="attend.entity.ClosingType" cascade="none" />
<property name="priorCode" column="inc_prtcod" type="string" />
<property name="originCode" column="inc_ogncod" type="string" />
<many-to-one name="userCode" column="inc_clicod" class="attend.entity.Client" cascade="none" />
<property name="clsDescrip" column="inc_clsdes" type="string" />
<many-to-one name="companyCode" column="inc_cmpcod" class="attend.entity.Company" cascade="none" />
<many-to-one name="type" column="inc_inctyp" class="attend.entity.Typology" cascade="none" />
<many-to-one name="resolType" column="inc_rsttyp" class="attend.entity.TypologyR" cascade="none" />
<property name="subjInc" column="inc_incsbj" type="string" />
<many-to-one name="equipment" column="inc_inceqp" class="attend.entity.Inventory" cascade="none" />
<many-to-one name="locCode" column="inc_loccli" class="attend.entity.LocClient" cascade="none" />
<property name="description" column="inc_descri" type="string" />
<property name="cancellation" column="inc_cancel" type="string" />

<many-to-one name="assigTec" column="inc_asgtec" class="attend.entity.Technician" cascade="none" />
<many-to-one name="assigGroup" column="inc_asggrp" class="attend.entity.Group" cascade="none" />
<many-to-one name="transTec" column="inc_trftec" class="attend.entity.Technician" cascade="none" />
<many-to-one name="transGroup" column="inc_trfgrp" class="attend.entity.Group" cascade="none" />
<many-to-one name="internSLA" column="inc_intsla" class="attend.entity.SLA" cascade="none" />
<many-to-one name="externSLA" column="inc_extsla" class="attend.entity.SLA" cascade="none" />

<property name="couinc" column="inc_couinc" type="int" />
<property name="resinc" column="inc_resinc" type="int" />
<property name="parentinc" column="inc_parent" type="int" />
<property name="vininc" column="inc_vininc" type="int" />
<property name="coditioninc" column="inc_codinc" type="int" />
<property name="causeRetent" column="inc_cauret" type="string" />
<property name="active" column="inc_incact" type="string" />
<property name="action" column="inc_action" type="string" />

</class>



<class name="attend.entity.IncidentS" table="hk_incident">
<id name="id" column="inc_inccod" type="string">
<generator class="assigned" />
</id>

<property name="clsDescrip" column="inc_clsdes" type="string" />

<property name="type" column="inc_inctyp" type="string" />

<property name="subjInc" column="inc_incsbj" type="string" />
<property name="description" column="inc_descri" type="string" />





</class>



<class name="attend.entity.Search" table="tmp_search">
<id name="code" column="tmp_tmpcod" type="string">
<generator class="assigned" />
</id>

<property name="ids" column="tmp_tmpids" type="string" />

<property name="entity" column="tmp_tmpent" type="string" />
<property name="entity_group" column="tmp_tmpgrp" type="string" />
<property name="entity_code" column="tmp_codent" type="string" />
<property name="entity_link" column="tmp_tmplik" type="string" />
<property name="entity_label" column="tmp_tmplab" type="string" />

<property name="entity_description" column="tmp_tmpdes" type="string" />





</class>



<class name="attend.entity.IncidentMail" table="sys_incmail">
<id name="id" column="sys_sysiid" type="string">
<generator class="assigned" />
</id>

<property name="date" column="sys_indate" type="timestamp" />

<property name="sender" column="sys_sender" type="string" />
<property name="email" column="sys_semail" type="string" />

<property name="body" column="sys_inbody" type="string" />

<property name="subject" column="sys_subject" type="string" />

<property name="attach" column="sys_attach" type="string" />

<property name="proc" column="sys_proces" type="string" />




</class>


<class name="attend.entity.ItemInventory" table="hk_itemcat">

<id name="code" column="typ_typcod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>

<property name="fathersCode" column="typ_parent" type="string" />
<property name="descript" column="typ_typdes" type="string" />
<property name="level" column="typ_typlev" type="string" />
<property name="codnum" column="typ_codnum" type="string" />
<property name="attri1" column="typ_typat1" type="string" />
<property name="attri2" column="typ_typat2" type="string" />
<property name="attri3" column="typ_typat3" type="string" />
<property name="attri4" column="typ_typat4" type="string" />
<property name="observ" column="typ_typobs" type="string" />
<property name="active" column="typ_typact" type="string" />
</class>


<class name="attend.entity.Typology" table="hk_typology">

<id name="code" column="typ_typcod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>

<property name="fathersCode" column="typ_parent" type="string" />
<property name="descript" column="typ_typdes" type="string" />
<many-to-one name="groupCode" column="typ_grpcod" class="attend.entity.Group" cascade="none" />
<many-to-one name="tec" column="typ_teccod" class="attend.entity.Technician" cascade="none" />
<many-to-one name="slaCode" column="typ_slacod" class="attend.entity.SLA" cascade="none" />
<many-to-one name="slaCodeTec" column="typ_slatec" class="attend.entity.SLA" cascade="none" />
<property name="level" column="typ_typlev" type="string" />
<property name="codnum" column="typ_codnum" type="string" />
<property name="asigaut" column="typ_assaut" type="string" />
<property name="observ" column="typ_typobs" type="string" />
<property name="active" column="typ_typact" type="string" />
<property name="script" column="typ_typscr" type="string" />
</class>

<class name="attend.entity.TypologyR" table="hk_typologyr">

<id name="code" column="typ_typcod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>


<property name="fathersCode" column="typ_parent" type="string" />
<property name="descript" column="typ_typdes" type="string" />

<property name="level" column="typ_typlev" type="string" />
<property name="codnum" column="typ_codnum" type="string" />

<property name="observ" column="typ_typobs" type="string" />
<property name="active" column="typ_typact" type="string" />
</class>

<class name="attend.entity.Organization" table="hk_organization">


<id name="key" column="org_orgkey" type="string" unsaved-value="null">
<generator class="assigned" />
</id>

<many-to-one name="company" column="org_orgcmp" class="attend.entity.Company" />
<property name="code" column="org_orgcod" type="string" />
<property name="fathersCode" column="org_parent" type="string" />
<property name="descript" column="org_orgdes" type="string" />
<property name="level" column="org_orglev" type="string" />
<property name="codnum" column="org_codnum" type="string" />
<property name="costcenter" column="org_orgcoc" type="string" />

<property name="observ" column="org_orgobs" type="string" />
<property name="active" column="org_orgact" type="string" />

</class>

<class name="attend.entity.Group" table="hk_groups">
<id name="name" column="grp_grpnam" type="string">
<generator class="assigned" />
</id>


<property name="description" column="grp_grpdes" type="string" />
<property name="type" column="grp_grptyp" type="string" />
<set name="manager" table="hk_mnggroup" cascade="none">
<key column="mng_grpcod" />
<many-to-many column="mng_teccod" class="attend.entity.Technician" />
</set>
<set name="technicians" table="hk_techgroup" cascade="none">
<key column="tgr_grpcod" />
<many-to-many column="tgr_teccod" class="attend.entity.Technician" />
</set>
<property name="active" column="grp_grpact" type="string" />
<property name="observation" column="grp_grpobs" type="string" />
</class>


<class name="attend.entity.Company" table="hk_company">
<id name="id" column="cmp_cmpcod" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>

<property name="companyName" column="cmp_cmpnam" type="string" />
<many-to-one name="mainLoc" column="cmp_locali" class="attend.entity.Location" cascade="none" />
<many-to-one name="typeClient" column="cmp_cmptcl" class="attend.entity.ClientType" cascade="none" />

<property name="typeCompany" column="cmp_cmptyp" type="string" />
<property name="nif" column="cmp_cmpnif" type="string" />
<property name="lock" column="cmp_cmploc" type="string" />
<property name="interC" column="cmp_cmpint" type="string" />
<property name="rolClient" column="cmp_rolcli" type="string" />
<property name="rolManufacture" column="cmp_rolman" type="string" />
<property name="rolSupplier" column="cmp_rolsup" type="string" />
<property name="abbrev" column="cmp_abbrev" type="string" />
<property name="shelpdesk" column="cmp_shelpd" type="string" />
<property name="sservice" column="cmp_sservi" type="string" />
<property name="ssales" column="cmp_ssales" type="string" />
<property name="stypHk" column="cmp_styphk" type="string" />
<property name="stypSv" column="cmp_stypsv" type="string" />
<property name="stypSa" column="cmp_stypsa" type="string" />
<property name="companyFact" column="cmp_cmpfac" type="string" />
<property name="companyGroup" column="cmp_cmpgro" type="string" />
<property name="observation" column="cmp_cmpobs" type="string" />
<property name="active" column="cmp_cmpact" type="string" />

</class>

<class name="attend.entity.Location" table="hk_locations">

<id name="key" column="loc_lockey" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>

<property name="code" column="loc_loccod" type="string" />


<property name="floor" column="loc_locflr" type="string" />
<property name="address" column="loc_locadr" type="string" />
<property name="city" column="loc_loccty" type="string" />
<property name="region" column="loc_locreg" type="string" />
<property name="cp" column="loc_loccop" type="string" />
<property name="contry" column="loc_locctr" type="string" />
<property name="main" column="loc_locmain" type="string" />
<property name="web" column="loc_locweb" type="string" />
<property name="email" column="loc_lemail" type="string" />
<property name="tele1" column="loc_loctl1" type="string" />
<property name="tele2" column="loc_loctl2" type="string" />
<property name="fax" column="loc_locfax" type="string" />
<many-to-one name="company" column="loc_loccmp" class="attend.entity.Company" cascade="none" />
<property name="active" column="loc_locact" type="string" />
<property name="observation" column="loc_locobs" type="string" />
</class>


<class name="attend.entity.LocClient" table="hk_locclient">

<id name="key" column="clo_clokey" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>

<property name="typeclient" column="clo_clotyp" type="string" />
<property name="codeclient" column="clo_clocod" type="string" />
<many-to-one name="loc" column="clo_cloloc" class="attend.entity.Location" cascade="none" outer-join="false" />
<many-to-one name="department" column="clo_clodep" class="attend.entity.Organization" cascade="none" />
<property name="tele1" column="clo_clotl1" type="string" />
<property name="tele2" column="clo_clotl2" type="string" />
<property name="fax" column="clo_clofax" type="string" />
<property name="ext" column="clo_cloext" type="string" />
<property name="active" column="clo_cloact" type="string" />
<property name="monday" column="clo_monday" type="string" />
<property name="tuesday" column="clo_tueday" type="string" />
<property name="wednesday" column="clo_wedday" type="string" />
<property name="thursday" column="clo_thuday" type="string" />
<property name="friday" column="clo_friday" type="string" />
<property name="observations" column="clo_cloobs" type="string" />
<property name="numberemp" column="clo_numemp" type="string" />
<property name="email" column="clo_cemail" type="string" />
<property name="locmain" column="clo_lomain" type="string" />
</class>

<class name="attend.entity.LocationView" table="vdia_locations">

<id name="key" column="loc_lockey" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>

<property name="companyName" column="cmp_cmpnam" type="string" />
<property name="code" column="loc_loccod" type="string" />
<property name="floor" column="loc_locflr" type="string" />
<property name="address" column="loc_locadr" type="string" />
<property name="city" column="loc_loccty" type="string" />
<property name="region" column="loc_locreg" type="string" />
<property name="cp" column="loc_loccop" type="string" />
<property name="contry" column="loc_locctr" type="string" />
<property name="observation" column="loc_locobs" type="string" />
<many-to-one name="company" column="loc_loccmp" class="attend.entity.Company" cascade="none" />
<property name="main" column="loc_locmain" type="string" />
<property name="email" column="loc_lemail" type="string" />
<property name="tele1" column="loc_loctl1" type="string" />
<property name="tele2" column="loc_loctl2" type="string" />
<property name="fax" column="loc_locfax" type="string" />
<property name="web" column="loc_locext" type="string" />
<property name="active" column="loc_locact" type="string" />

</class>



<class name="attend.entity.VClient" table="vdia_incclient">

<id name="locationkey" column="loc_lockey" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>

<property name="codecompany" column="cmp_cmpcod" type="string" />
<property name="namecompany" column="cmp_cmpnam" type="string" />

<property name="address" column="loc_locadr" type="string" />
<property name="city" column="loc_loccty" type="string" />
<property name="region" column="loc_locreg" type="string" />
<property name="cp" column="loc_loccop" type="string" />
<property name="firstname" column="cli_finame" type="string" />
<property name="secondname" column="cli_sename" type="string" />
<property name="thirdname" column="cli_thname" type="string" />
<property name="nif" column="cli_clinif" type="string" />
<property name="fullName" column="cli_funame" type="string" />
<property name="clientcode" column="cli_clicod" type="string" />

</class>

<class name="attend.entity.Auditory" table="hk_auditory">
<id name="code" column="aud_audcod" type="string">
<generator class="assigned" />
</id>
<property name="incident" column="aud_inccod" type="string" />
<property name="entity" column="aud_audent" type="string" />
<property name="date" column="aud_datetm" type="timestamp" />
<many-to-one name="userCode" column="aud_usecod" class="attend.entity.User" />
<property name="oldValue" column="aud_oldval" type="string" />
<property name="newValue" column="aud_newval" type="string" />
<property name="codeType" column="aud_typcod" type="string" />
</class>

<class name="attend.entity.Auditoryh" table="hk_auditoryar">
<id name="code" column="aud_audcod" type="string">
<generator class="assigned" />
</id>
<property name="incident" column="aud_inccod" type="string" />
<property name="entity" column="aud_audent" type="string" />
<property name="date" column="aud_datetm" type="date" />
<many-to-one name="userCode" column="aud_usecod" class="attend.entity.User" />
<property name="oldValue" column="aud_oldval" type="string" />
<property name="newValue" column="aud_newval" type="string" />
<property name="codeType" column="aud_typcod" type="string" />
</class>


<class name="attend.entity.Auditorykb" table="hk_auditorykb">
<id name="code" column="aud_audcod" type="string">
<generator class="assigned" />
</id>
<property name="incident" column="aud_inccod" type="string" />
<property name="entity" column="aud_audent" type="string" />
<property name="date" column="aud_datetm" type="date" />
<many-to-one name="userCode" column="aud_usecod" class="attend.entity.User" />
<property name="oldValue" column="aud_oldval" type="string" />
<property name="newValue" column="aud_newval" type="string" />
<property name="codeType" column="aud_typcod" type="string" />
</class>


<class name="attend.entity.SLA" table="hk_sla">
<id name="code" column="sla_slacod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>

<property name="description" column="sla_slades" type="string" />
<property name="respHour" column="sla_rephor" type="int" />
<property name="respMin" column="sla_repmin" type="int" />
<property name="closeHour" column="sla_clshor" type="int" />
<property name="closeMin" column="sla_clsmin" type="int" />
<many-to-one name="cal" column="sla_calcod" class="attend.entity.Calendarh" cascade="none" />
<many-to-one name="group" column="sla_grpcod" class="attend.entity.Group" cascade="none" />
<many-to-one name="tech" column="sla_teccod" class="attend.entity.Technician" cascade="none" />
<property name="shift" column="sla_shfcod" type="string" />
<property name="obs" column="sla_slaobs" type="string" />
<property name="asigaut" column="sla_asgaut" type="string" />
<property name="type" column="sla_slatyp" type="string" />
<property name="active" column="sla_slaact" type="string" />
</class>
<class name="attend.entity.Lock" table="hk_lock">
<id name="code" column="lck_lckcod" type="long" unsaved-value="null" >
<generator class="assigned" />
</id>
<property name="entity" column="lck_lckent" type="string" />
<property name="entityCode" column="lck_entcod" type="string" />
<property name="userId" column="lck_userid" type="int" />
<property name="time" column="lck_lktime" type="timestamp" />
</class>

<class name="attend.entity.Counter" table="hk_counter">
<id name="code" column="cnt_cntcod" type="long" unsaved-value="null" >
<generator class="assigned" />
</id>
<property name="entity" column="cnt_cntent" type="string" />
<property name="value" column="cnt_cntval" type="int" />
<property name="active" column="cnt_cntact" type="string" />
<property name="observation" column="cnt_cntobs" type="string" />
</class>


<class name="attend.entity.Diary" table="hk_diary">
<id name="code" column="dia_diacod" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>


<property name="date_entry" column="dia_entdat" type="timestamp" />
<property name="notification" column="dia_dianot" type="string" />
<property name="notificationt" column="dia_diantt" type="string" />
<property name="visible" column="dia_diavis" type="string" />

<many-to-one name="incident" column="dia_inccod" class="attend.entity.Incident" cascade="none" />
<many-to-one name="tech" column="dia_diatec" class="attend.entity.Technician" cascade="none" />
<property name="active" column="dia_diaact" type="string" />
<property name="observation" column="dia_diaobs" type="string" />

</class>


<class name="attend.entity.DiaryS" table="hk_diary">
<id name="code" column="dia_diacod" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>



<property name="observation" column="dia_diaobs" type="string" />

</class>


<class name="attend.entity.Diaryh" table="hk_diaryar">
<id name="code" column="dia_diacod" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>


<property name="date_entry" column="dia_entdat" type="timestamp" />
<property name="notification" column="dia_dianot" type="string" />
<property name="notificationt" column="dia_diantt" type="string" />
<property name="visible" column="dia_diavis" type="string" />

<property name="incident" column="dia_inccod" type="int" />
<property name="tech" column="dia_diatec" type="string" />
<property name="active" column="dia_diaact" type="string" />
<property name="observation" column="dia_diaobs" type="string" />

</class>


<class name="attend.entity.DiaryhS" table="hk_diaryar">
<id name="code" column="dia_diacod" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>


<property name="date_entry" column="dia_entdat" type="timestamp" />
<property name="notification" column="dia_dianot" type="string" />
<property name="notificationt" column="dia_diantt" type="string" />
<property name="visible" column="dia_diavis" type="string" />

<property name="incident" column="dia_inccod" type="int" />
<property name="tech" column="dia_diatec" type="string" />
<property name="active" column="dia_diaact" type="string" />
<property name="observation" column="dia_diaobs" type="string" />

</class>


<class name="attend.entity.Diarykb" table="hk_diarykb">
<id name="code" column="dia_diacod" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>


<property name="date_entry" column="dia_entdat" type="timestamp" />
<property name="notification" column="dia_dianot" type="string" />
<property name="notificationt" column="dia_diantt" type="string" />
<property name="visible" column="dia_diavis" type="string" />

<property name="incident" column="dia_inccod" type="int" />
<property name="tech" column="dia_diatec" type="string" />
<property name="active" column="dia_diaact" type="string" />
<property name="observation" column="dia_diaobs" type="string" />

</class>

<class name="attend.entity.DiarykbS" table="hk_diarykb">
<id name="code" column="dia_diacod" type="string" unsaved-value="null" >
<generator class="assigned" />
</id>


<property name="date_entry" column="dia_entdat" type="timestamp" />
<property name="notification" column="dia_dianot" type="string" />
<property name="notificationt" column="dia_diantt" type="string" />
<property name="visible" column="dia_diavis" type="string" />

<property name="incident" column="dia_inccod" type="int" />
<property name="tech" column="dia_diatec" type="string" />
<property name="active" column="dia_diaact" type="string" />
<property name="observation" column="dia_diaobs" type="string" />

</class>

<class name="attend.entity.WorkTime" table="hk_worktime">
<id name="code" column="wrk_wrkcod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>

<property name="incident" column="wrk_inccod" type="string" />
<property name="startHour" column="wrk_hstart" type="int" />
<property name="startMin" column="wrk_mstart" type="int" />
<property name="endHour" column="wrk_houend" type="int" />
<property name="endMin" column="wrk_minend" type="int" />
<many-to-one name="type" column="wrk_typcod" class="attend.entity.WorktimeType" cascade="none" />
<many-to-one name="tech" column="wrk_teccod" class="attend.entity.Technician" cascade="none" />
<property name="observation" column="wrk_wrkobs" type="string" />
<property name="date" column="wrk_datewt" type="date" />
<property name="active" column="wrk_wrkact" type="string" />
<property name="startTime" column="wrk_tstart" type="string" />
<property name="endTime" column="wrk_timend" type="string" />

</class>



<class name="attend.entity.WorkTimeh" table="hk_worktimear">
<id name="code" column="wrk_wrkcod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>

<property name="incident" column="wrk_inccod" type="string" />
<property name="startHour" column="wrk_hstart" type="int" />
<property name="startMin" column="wrk_mstart" type="int" />
<property name="endHour" column="wrk_houend" type="int" />
<property name="endMin" column="wrk_minend" type="int" />
<property name="type" column="wrk_typcod" type="string" />
<property name="tech" column="wrk_teccod" type="string" />
<property name="observation" column="wrk_wrkobs" type="string" />
<property name="date" column="wrk_datewt" type="date" />
<property name="active" column="wrk_wrkact" type="string" />
<property name="startTime" column="wrk_tstart" type="string" />
<property name="endTime" column="wrk_timend" type="string" />

</class>


<class name="attend.entity.WorktimeType" table="hk_wrktyp">
<id name="code" column="wty_wtycod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>
<property name="description" column="wty_wtydes" type="string" />
<property name="obs" column="wty_wtyobs" type="string" />
<property name="billWrk" column="wty_bilwrk" type="string" />
<property name="billBnk" column="wty_bilbnk" type="string" />
<property name="active" column="wty_wtyact" type="string" />
</class>

<class name="attend.entity.ClientType" table="hk_clityp">
<id name="code" column="clt_cltcod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>
<property name="description" column="clt_cltdes" type="string" />
<property name="obs" column="clt_cltobs" type="string" />
<property name="typeC" column="clt_clttyp" type="string" />
<property name="active" column="clt_cltact" type="string" />
</class>

<class name="attend.entity.ClosingType" table="hk_clotyp">

<id name="code" column="clo_clocod" type="string" unsaved-value="null">
<generator class="assigned" />
</id>

<property name="description" column="clo_clodes" type="string" />
<property name="obs" column="clo_cloobs" type="string" />
<property name="active" column="clo_cloact" type="string" />

</class>



<class name="attend.entity.Parameter" table="sys_parapp">
<id name="key" column="par_parkey" type="long" unsaved-value="null">
<generator class="assigned" />
</id>
<property name="code" column="par_parcod" type="string" />
<property name="module" column="par_partyp" type="string" />
<property name="datatype" column="par_dattyp" type="string" />
<property name="paramValue" column="par_parvla" type="string" />
<property name="obs" column="par_parobs" type="string" />
<property name="active" column="par_paract" type="string" />
</class>

<class name="attend.entity.Business" table="sys_business">
<id name="code" column="bs_cod" type="string">
<generator class="assigned" />
</id>
<property name="function" column="bs_func" type="string" />
<property name="execOrder" column="bs_ordr" type="int" />
<property name="order" column="bs_bsord" type="int" />
<property name="cat" column="bs_cat" type="string" />
<property name="srcCode" column="bs_srcc" type="string" />
<property name="srcExe" column="bs_srce" type="string" />
<property name="subject" column="bs_subjct" type="string" />
<property name="text" column="bs_txt" type="string" />
<property name="textId" column="bs_txtid" type="string" />
<property name="objType" column="bs_otyp" type="string" />
<property name="obj" column="bs_obj" type="string" />
<property name="event" column="bs_even" type="string" />
<property name="eventType" column="bs_event" type="string" />
<property name="n_Way" column="bs_nway" type="string" />
<property name="n_From" column="bs_nfrom" type="string" />
<property name="n_To" column="bs_nto" type="string" />
<property name="n_CC" column="bs_ncc" type="string" />
<property name="n_Rply" column="bs_nrply" type="string" />
<property name="n_Attch" column="bs_nattch" type="string" />
<property name="obs" column="bs_obs" type="string" />
<property name="active" column="bs_active" type="string" />
</class>



<class name="attend.entity.Logon" table="sys_logon">
<id name="key" column="sys_logkey" type="string">
<generator class="assigned" />
</id>
<property name="session" column="sys_logses" type="string" />
<property name="profile" column="sys_logpro" type="string" />
<property name="ip" column="sys_logipu" type="string" />
<property name="agentUser" column="sys_loguag" type="string" />
<property name="ext" column="sys_logext" type="string" />
<property name="date" column="sys_logdat" type="timestamp" />
<many-to-one name="user" column="sys_logidu" class="attend.entity.User" cascade="none" />

<property name="active" column="sys_active" type="string" />
</class>


<class name="attend.entity.Attachment" table="hk_attachments">
<id name="code" column="att_attcod" type="string" >
<generator class="assigned" />
</id>
<property name="entity" column="att_attent" type="string" />
<property name="entityId" column="att_enttid" type="string" />
<property name="description" column="att_attdes" type="string" />
<property name="path" column="att_atpath" type="string" />
<property name="stringPath" column="att_strpth" type="string" />
<property name="visibility" column="att_attcli" type="string" />
</class>


<class name="attend.entity.Attachmenth" table="hk_attachmentsar">
<id name="code" column="att_attcod" type="string" >
<generator class="assigned" />
</id>
<property name="entity" column="att_attent" type="string" />
<property name="entityId" column="att_enttid" type="string" />
<property name="description" column="att_attdes" type="string" />
<property name="path" column="att_atpath" type="string" />
<property name="stringPath" column="att_strpth" type="string" />
<property name="visibility" column="att_attcli" type="string" />
</class>

<class name="attend.entity.Attachmentkb" table="hk_attachmentskb">
<id name="code" column="att_attcod" type="string" >
<generator class="assigned" />
</id>
<property name="entity" column="att_attent" type="string" />
<property name="entityId" column="att_enttid" type="string" />
<property name="description" column="att_attdes" type="string" />
<property name="path" column="att_atpath" type="string" />
<property name="stringPath" column="att_strpth" type="string" />
<property name="visibility" column="att_attcli" type="string" />
</class>


<class name="attend.entity.Client" table="hk_clients">
<id name="code" column="cli_clicod" type="string">
<generator class="assigned" />
</id>


<property name="firstname" column="cli_finame" type="string" />
<property name="secondname" column="cli_sename" type="string" />
<property name="thirdname" column="cli_thname" type="string" />
<property name="nif" column="cli_clinif" type="string" />
<property name="fullName" column="cli_funame" type="string" />
<property name="typeclient" column="cli_clityp" type="string" />



<set name="locations" table="hk_locclient" where="clo_clotyp='C'" lazy="false" cascade="none">
<key column="clo_clocod" />
<one-to-many class="attend.entity.LocClient" />
</set>

<property name="active" column="cli_cliact" type="string" />
<property name="observations" column="cli_cliobs" type="string" />
<property name="iduser" column="cli_clinid" type="int" />
<many-to-one name="main" column="cli_lomain" class="attend.entity.LocClient" cascade="none" />
</class>

<class name="attend.entity.Inventory" table="hk_inventory">
<id name="code" column="inv_invcod" type="string">
<generator class="assigned" />
</id>

<many-to-one name="itemCat" column="inv_invcat" class="attend.entity.ItemInventory" cascade="none" />
<many-to-one name="itemName" column="inv_invnam" class="attend.entity.ItemInventory" cascade="none" />
<many-to-one name="itemModel" column="inv_invmod" class="attend.entity.ItemInventory" cascade="none" />

<property name="attri1" column="inv_invat1" type="string" />
<property name="attri2" column="inv_invat2" type="string" />
<property name="attri3" column="inv_invat3" type="string" />
<property name="attri4" column="inv_invat4" type="string" />

<many-to-one name="ownerContact" column="inv_owncli" class="attend.entity.Client" cascade="none" />
<many-to-one name="departament" column="inv_invdep" class="attend.entity.Organization" cascade="none" />
<property name="costCentre" column="inv_cstctr" type="string" />
<property name="ownerConfig" column="inv_owncnf" type="string" />
<many-to-one name="company" column="inv_invcmp" class="attend.entity.Company" cascade="none" />

<property name="numSer" column="inv_sernum" type="string" />
<property name="label" column="inv_invlab" type="string" />
<property name="partNumber" column="inv_prtnum" type="string" />
<many-to-one name="manufacturer" column="inv_invfac" class="attend.entity.Company" cascade="none" />
<many-to-one name="suplier" column="inv_invspl" class="attend.entity.Company" cascade="none" />
<property name="instalDate" column="inv_insdat" type="date" />

<property name="rentCode" column="inv_rencod" type="string" />
<property name="rentDateBgn" column="inv_dtbgnr" type="date" />
<property name="rentDateEnd" column="inv_dtendr" type="date" />

<property name="garantName" column="inv_garnme" type="string" />
<property name="garantDateBgn" column="inv_dtbgng" type="date" />
<property name="garantDateEnd" column="inv_dtendg" type="date" />

<many-to-one name="locat" column="inv_invloc" class="attend.entity.Location" cascade="none" />

<property name="shopDate" column="inv_shpdat" type="date" />
<property name="shopcost" column="inv_shpcst" type="string" />
<property name="shoporder" column="inv_shprdr" type="string" />
<property name="shopbill" column="inv_shpbil" type="string" />
<property name="observation" column="inv_invobs" type="string" />
<property name="active" column="inv_invact" type="string" />

</class>

<class name="attend.entity.Integrity" table="sys_integrity">
<id name="id" column="int_inteid" type="string">
<generator class="assigned" />
</id>

<property name="entity" column="int_entorg" type="string" />
<property name="dependentEntity" column="int_entdep" type="string" />
<property name="depEntityId" column="int_pkydep" type="string" />
<property name="entityValue" column="int_pkyval" type="string" />
<property name="action" column="int_action" type="string" />
<property name="Validation" column="int_valida" type="string" />

</class>


<class name="attend.entity.Calendarh" table="hk_calendarh">
<id name="id" column="ch_calhnid" type="string">
<generator class="assigned" />
</id>


<property name="description" column="ch_caldes" type="string" />
<property name="type" column="ch_caltyp" type="string" />


</class>


<class name="attend.entity.Calendard" table="hk_calendard">
<id name="id" column="cd_caldnid" type="string">
<generator class="assigned" />
</id>


<many-to-one name="idch" column="cd_calhnid" class="attend.entity.Calendarh" cascade="none" />
<many-to-one name="idsh" column="cd_horaid" class="attend.entity.Schedule" cascade="none" />
<property name="date" column="cd_cddate" type="date" />
<property name="minutes" column="cd_minutes" type="int" />
<property name="year" column="cd_year" type="string" />

</class>

<class name="attend.entity.Schedule" table="hk_timetable">
<id name="id" column="hr_horaid" type="string">
<generator class="assigned" />
</id>

<property name="hrini1" column="hr_hrini1" type="int" />
<property name="miini1" column="hr_miini1" type="int" />
<property name="hrfin1" column="hr_hrfin1" type="int" />
<property name="mifin1" column="hr_mifin1" type="int" />
<property name="hrini2" column="hr_hrini2" type="int" />
<property name="miini2" column="hr_miini2" type="int" />
<property name="hrfin2" column="hr_hrfin2" type="int" />
<property name="mifin2" column="hr_mifin2" type="int" />
<property name="hrini3" column="hr_hrini3" type="int" />
<property name="miini3" column="hr_miini3" type="int" />
<property name="hrfin3" column="hr_hrfin3" type="int" />
<property name="mifin3" column="hr_mifin3" type="int" />
<property name="minutes" column="hr_minutes" type="int" />

</class>

<class name="attend.entity.Notification" table="sys_notification">
<id name="id" column="no_notiid" type="string">
<generator class="assigned" />
</id>

<property name="server" column="no_server" type="string" />
<property name="way" column="no_nway" type="string" />
<property name="from" column="no_nfrom" type="string" />
<property name="to" column="no_nto" type="string" />
<property name="cc" column="no_ncc" type="string" />
<property name="reply" column="no_nrply" type="string" />
<property name="subject" column="no_subje" type="string" />
<property name="body" column="no_body" type

ummm .... lazy="true"?

Did you read the documentation?

I have read it, promise!

Thing is that with lazy=true gives me problems. Is there ant other option?
Anything more low-level solution?

Thanks a lot. Sorry for the boder!
;-)

Naw, thats the choice: lazy or non-lazy!

You should try to resolve your "problems". You can't use Hibernate without lazy="true". It just won't scale.