I can't see anything else wrong with what you've got. At this point, I'd start debugging. You could be explicit in your many-to-one mapping to Usario, by including a class="Usario" (at the moment, it's inferring that from the name attribute), but I doubt that that will help.
1. class="Usuario";
2. puts fetch="join" on Atendente and Usuario relationship;
3. puts lazy="proxy";
4. Use join fetch in HQL;
5. Use FetchMode.JOIN with Criteria.
All of these without success. So, I decide to write a complete isolate testing project to see what is happen and, all works fine to this project, but I (and others here) can't see where is the diference between projects. I'm lock in this problem for a few days without success, but I really think that my problems lie on subclasses mapping because others situations where I load objects from this hierarchy have the same problem (come with null values). I decide to put the complete mapping here for someone take a look:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping default-lazy="false" schema="Atendimento">
<class
name="com.company.project.model.Mesa"
dynamic-update="false"
dynamic-insert="false">
<id name="id" column="id" type="long" unsaved-value="-1">
<generator class="increment"/>
</id>
<property
name="data"
type="date"
update="true"
insert="true"
column="data"/>
<many-to-one
name="agencia"
column="id_agencia"
/>
<many-to-one
name="mesaUnit"
column="mesa_unit"/>
<many-to-one name="atendente" fetch="join"/>
<property
name="status"
type="int"
update="true"
insert="true"
column="status"/>
<property
name="dataAbertura"
type="java.util.Date"
update="true"
insert="true"
column="data_abertura"/>
<many-to-one
name="usuarioAbertura"
class="com.provider.gfin.user.TBUser"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="usuario_abertura"/>
<property
name="dataFechamento"
type="java.util.Date"
update="true"
insert="true"
column="data_fechamento"/>
<many-to-one
name="usuarioFechamento"
column="usuario_fechamento"/>
<property
name="dataInicioStatus"
type="java.util.Date"
update="true"
insert="true"
column="data_inicio_status"/>
<set name="historicoMesa" lazy="true" inverse="true">
<key column="id_mesa"/>
<one-to-many class="com.company.project.model.support.HistoricoStatusMesa"/>
</set>
<joined-subclass
name="com.company.project.model.MesaRecepcao"
table="mesa_recepcao">
<key column="id"/>
</joined-subclass>
<joined-subclass
name="com.company.project.model.MesaAtendimento"
table="mesa_atendimento">
<key column="id"/>
<many-to-one
name="senhaAtual"
column="senha_atual"/>
<property
name="numeroAtendimento"
type="int"
update="true"
insert="true"
column="numero_atendimento"/>
</joined-subclass>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping default-lazy="false" schema = "ControleAcesso">
<class name="com.company.project.accesscontrol.AControlEntity">
<id name="id" unsaved-value="-1">
<generator class="increment"/>
</id>
<set name="permissions" lazy="true" batch-size="10">
<key column="permission_id"/>
<one-to-many class="com.company.project.accesscontrol.tbfunction.TBFunction"/>
</set>
<joined-subclass name="com.company.project.company.Company">
<key column="ID"/>
<property name="codigoDoGrupo" unique="true"/>
<property name="nomeDoGrupo"/>
<property name="nomeDaEmpresa"/>
<property name="nomeFantasia"/>
<property name="realm" unique="true" not-null="true"/>
<property name="pabx"/>
<property name="nire"/>
<property name="atividade"/>
<property name="industria"/>
<property name="cnpj" unique="true"/>
<property name="dataInscricaoCnpj"/>
<property name="idioma"/>
<many-to-one name="endereco" cascade="all"/>
<set name="setores" cascade="all">
<key column="company_id"/>
<one-to-many class="com.company.project.company.Setor"/>
</set>
</joined-subclass>
<joined-subclass name="com.company.project.branch.Branch">
<key column="ID"/>
<property name="cnpj"/>
<property name="pracaCompensacao"/>
<property name="idioma" not-null="true"/>
<property name="openingDate"/>
<many-to-one name="address" cascade="all"/>
<property name="name"/>
<property name="sigla"/>
<property name="code">
<column name="code" unique-key="uk"/>
</property>
<many-to-one name="diretorPresidente" cascade="all" outer-join="false"/>
<many-to-one name="diretorSecundario" cascade="all" outer-join="false"/>
<many-to-one name="responsavelContabilidade" cascade="all" outer-join="false"/>
<many-to-one name="tipo" not-null="true" column="id_tipo" outer-join="false"/>
<many-to-one name="company" not-null="true" outer-join="false">
<column name="company" unique-key="uk"/>
</many-to-one>
</joined-subclass>
<joined-subclass name="com.company.project.jobfunction.JobFunction">
<key column="ID"/>
<property name="code">
<column name="code" unique-key="uk"/>
</property>
<property name="name" not-null="true" unique="true"/>
<property name="description"/>
<many-to-one name="company" not-null="true">
<column name="company" unique-key="uk"/>
</many-to-one>
</joined-subclass>
<joined-subclass name="com.company.project.user.TBUser">
<key column="ID"/>
<property name="login" not-null="true" unique="true"/>
<property name="password" not-null="true"/>
<property name="registration" not-null="true"/>
<property name="name"/>
<property name="apelido"/>
<property name="nivel" not-null="true"/>
<property name="idioma"/>
<many-to-one name="branch"/>
<many-to-one name="jobFunction"/>
<set name="agenciasPermitidas" batch-size="5">
<key column="TBUser"/>
<many-to-many class="com.company.project.branch.Branch" />
</set>
</joined-subclass>
</class>
</hibernate-mapping>
Sorry if is so dirty read long mappings. Anyone have some idea about what is wrong?
Login
FAQ
Search
