Hibernate many-to-many error

[Wagner Danda Da Silva Filho]

Hi All,

I'm having trouble to query a many-to-many association with Hibernate. Here are the envolved hbm files:

 
------> PacoteMinutos.hbm.xml
<class name="br.com.scc.PacoteMinutos" table="PACM_PACOTE_MINUTOS">
   ...
  <bag name="planosFaturamento" table="PACP_PACOTE_PLANO">
    <key column="PACM_PACOTE_CD"/>
    <many-to-many column="TIPL_TIPO_CABS_CD"  class="br.com.scc.PlanoFaturamento"/>
  </bag>
</class>
<------
 
------> PlanoFaturamento.hbm.xml
<class name="br.com.scc.PlanoFaturamento" table="BIPL_BILL_PLAN">
   ...
  <bag name="pacoteMinutos" table="PACP_PACOTE_PLANO">
    <key column="TIPL_TIPO_CABS_CD"/>
    <many-to-many column="PACM_PACOTE_CD" class="br.com.scc.PacoteMinutos"/>
  </bag>
</class>
<------
 

Here are the classes:

 
public class PacoteMinutos {
    ...
    private Collection planosFaturamento;
    public void setPlanosFaturamento(Collection planosFaturamento) {
        this.planosFaturamento = planosFaturamento;
    }
    public Collection getPlanosFaturamento() {
        return planosFaturamento;
    }
}
 
public class PlanoFaturamento {
    private Collection pacoteMinutos;
    public void setPacoteMinutos(Collection pacoteMinutos) {
        this.pacoteMinutos = pacoteMinutos;
    }
    public Collection getPacoteMinutos() {
        return pacoteMinutos;
    }
}

Here is the Criteria I'm trying to create:

   ...
   Criteria c = getSession().createCriteria(PacoteMinutos.class);
   c.add(Restrictions.eq("planosFaturamento", planoFaturamento));
   Collection col = c.list();
   ..

Here is the output:

Hibernate: /* criteria query */ select this_.PACM_PACOTE_CD as PACM1_0_, this_.PACM_PACOTE_NO as PACM2_19_0_, this_.PACM_ENCARGO_CD as PACM3_19_0_, this_.PACM_SUBORDINADAS_QT as PACM4_19_0_, this_.PACM_EXCLUIDO_FL as PACM5_19_0_ [B]from PACM_PACOTE_MINUTOS this_ where this_.PACM_PACOTE_CD > 0 and this_.PACM_PACOTE_CD=?[/B]
SQL Error: 1008, SQLState: 72000
ORA-01008: not all variables bound

I could see that Hibernate is doing a SELECT in the wrong table! The many-to-many table is "PACP_PACOTE_PLANO", and the select is reading from "PACM_PACOTE_MINUTOS"...

What am I doing wrong?
[ September 09, 2005: Message edited by: Wagner da Silva ]

[Wagner Danda Da Silva Filho]

Hey, I found a stupid yet simple solution:

First I get a "PlanoFaturamento" object loaded from my DAO, e.g.:

PlanoFaturamento pl = planoFaturamentoDAO.load(idPlanoFaturamento);

Then I can simply call:

Collection col = pl.getPacoteMinutos();

This executes the correct query and gives me a Collection of "PacoteMinutos".