Hello,

I'am having problems with the sql generated by hibernate, I was expecting it to generate a sql with joins.

My mapping is:

<class name="Objeto" table="OBJETO">
<id name="id" column="OBJE_NR_ID">
<generator class="uuid.hex"/>
</id>
<map name="valoresData" table="VALORDATA" outer-join="true" lazy="false">
<key column="OBJE_NR_ID"/>
<index-many-to-many column="ATRI_NR_ID" class="Atributo"/>
<element column="VLDT_DT_VALOR" type="date" not-null="true"/>
</map>

If a load all instances of Objeto, it does the following:

select * from objeto

then for each objeto:

select * from valordata where objeto.id = ?

*** The sqls above are not the real ones, it's only for demonstrating what is happening.


Anyone can help me to tune this?

I want: select * from objeto, valordata where ...

Thanks,
Felipe;

hql:

Thanks, it worked perfectly.

I have 3 maps in class Objeto. I tried this and did not work:

from Object as obj left join fetch obj.valoresData left join fetch obj.valoresTexto left join fetch obj.valoresNumerico where where objeto.id = ?

It didnt fetch the values correctly.

Thanks in advance,
Felipe;

only one collection can be fetch.... :(

This is not a bad, but very good limitation.

yes i know but for him it can be a bad new lol

fgoldin,
if more than one collection would be fetch, imagine the generated SQL....