Find returns several recorcs when there is just one in db :(

mikesu · **Joined:** Sun Apr 04, 2004 6:19 am **Posts:** 15

Hibernate version: 2.1.7

Code:

                
list = getHibernateTemplate()
                       .createCriteria(session, Someclass.class)
                       .add(Expression.eq("name", name))
                       .list();

returns 3 copies of the same object.
There is only one record in the table.

Class overrides "equals", compares only id.

Is this considered a "feature" or a bug?

anthony · **Posted:** Mon Dec 13, 2004 1:44 pm

not enough info to help you

what about generated sql?

are you sure about unicity?

mikesu · **Joined:** Sun Apr 04, 2004 6:19 am **Posts:** 15

Class has some one-to-* associations.

Removing "outer-join=true" has "fixes" the problem ^^.

So it's a "feature"?!?

What do you mean by "unicity"?

amjn · **Posted:** Mon Dec 13, 2004 10:43 pm

It is obviously we need more info to prove your issuce.

mikesu · **Joined:** Sun Apr 04, 2004 6:19 am **Posts:** 15

I can provide any information you need. Here is generated sql:

Code:

Hibernate: select this.ATTRIBUTE_SET_TYPE_ID as ATTRIBUT1_1_, this.NAME as NAME1_, this.DESCRIPTION as DESCRIPT3_1_, enumeratio1_.ATTRIBUTE_SET_TYPE_ID as ATTRIBUT1___, enumeratio1_.ENUMERATION_ID as ENUMERAT2___, enumeratio2_.ENUMERATION_ID as ENUMERAT1_0_, enumeratio2_.DESCRIPTION as DESCRIPT2_0_, enumeratio2_.NAME as NAME0_ from ATTRIBUTE_SET_TYPE this, MM_ATT_SET_TYPE_ENUM enumeratio1_, ENUMERATION enumeratio2_ where this.NAME=? and this.ATTRIBUTE_SET_TYPE_ID=enumeratio1_.ATTRIBUTE_SET_TYPE_ID(+) and enumeratio1_.ENUMERATION_ID=enumeratio2_.ENUMERATION_ID(+)

Hibernate: select enumeratio0_.ENUMERATION_ID as ENUMERAT4___, enumeratio0_.ENUMERATION_VALUE_ID as ENUMERAT1___, enumeratio0_.ENUMERATION_VALUE_ID as ENUMERAT1_0_, enumeratio0_.NAME as NAME0_, enumeratio0_.DESCRIPTION as DESCRIPT3_0_, enumeratio0_.ENUMERATION_ID as ENUMERAT4_0_ from ENUMERATION_VALUE enumeratio0_ where enumeratio0_.ENUMERATION_ID=?

Hibernate: select enumeratio0_.ENUMERATION_ID as ENUMERAT4___, enumeratio0_.ENUMERATION_VALUE_ID as ENUMERAT1___, enumeratio0_.ENUMERATION_VALUE_ID as ENUMERAT1_0_, enumeratio0_.NAME as NAME0_, enumeratio0_.DESCRIPTION as DESCRIPT3_0_, enumeratio0_.ENUMERATION_ID as ENUMERAT4_0_ from ENUMERATION_VALUE enumeratio0_ where enumeratio0_.ENUMERATION_ID=?

Hibernate: select parameteri0_.ATTRIBUTE_SET_TYPE_ID as ATTRIBUT1___, parameteri0_.PARAMETER_NAME as PARAMETE2___, parameteri0_.PARAMETER_TYPE as PARAMETE3___, parameteri1_.PARAMETER_NAME as PARAMETE1_0_, parameteri1_.PARAMETER_TYPE as PARAMETE2_0_ from MM_ATT_SET_TYPE_PARAM_INFO parameteri0_, PARAMETER_INFO parameteri1_ where parameteri0_.ATTRIBUTE_SET_TYPE_ID=? and parameteri0_.PARAMETER_NAME=parameteri1_.PARAMETER_NAME and parameteri0_.PARAMETER_TYPE=parameteri1_.PARAMETER_TYPE

Hibernate: select enumeratio0_.ENUMERATION_ID as ENUMERAT4___, enumeratio0_.ENUMERATION_VALUE_ID as ENUMERAT1___, enumeratio0_.ENUMERATION_VALUE_ID as ENUMERAT1_0_, enumeratio0_.NAME as NAME0_, enumeratio0_.DESCRIPTION as DESCRIPT3_0_, enumeratio0_.ENUMERATION_ID as ENUMERAT4_0_ from ENUMERATION_VALUE enumeratio0_ where enumeratio0_.ENUMERATION_ID=?

here is hbm.xml file for Attribute_set_Type class:

Code:

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

<hibernate-mapping>

<class
    name="com.biofrontera.discovery.hibernate.AttributeSetType"
    table="ATTRIBUTE_SET_TYPE"
>
    <id
        name="attributeSetTypeId"
        type="java.lang.Long"
        column="ATTRIBUTE_SET_TYPE_ID"
    >
        <generator class="sequence">
            <param name="sequence">SQ_ATTRIBUTE_SET_TYPE</param>
        </generator>
    </id>

    <property
        name="name"
        type="java.lang.String"
        column="NAME"
        not-null="true"
        unique="true"
        length="50"
    >
    </property>
    <property
        name="description"
        type="java.lang.String"
        column="DESCRIPTION"
        not-null="true"
        length="200"
    >
    </property>

    <!-- Associations -->

    <!-- uni-directional many-to-many association to Enumeration -->
    <set
        name="enumerations"
        lazy="false"
        outer-join="true"
      cascade="none"
        table="MM_ATT_SET_TYPE_ENUM"
    >
        <key>
            <column name="ATTRIBUTE_SET_TYPE_ID" />
        </key>
        <many-to-many
            class="com.biofrontera.discovery.hibernate.Enumeration"
        >
            <column name="ENUMERATION_ID" />
        </many-to-many>
    </set>

    <!-- uni-directional many-to-many association to ParameterInfo -->
    <set
        name="parameterInfos"
        lazy="false"
      cascade="none"
        table="MM_ATT_SET_TYPE_PARAM_INFO"
    >
        <key>
            <column name="ATTRIBUTE_SET_TYPE_ID" />
        </key>
        <many-to-many
            class="com.biofrontera.discovery.hibernate.ParameterInfo"
        >
            <column name="PARAMETER_NAME" />
            <column name="PARAMETER_TYPE" />
        </many-to-many>
    </set>

</class>
</hibernate-mapping>

if I remove "outer-join="true"" for enumerations association only one record will be returned (as it should).

There is only one record in the ATTRIBUTE_SET_TYPE table. There are 3 corresponding entries in the Enumeration table.

Also I use the following params:

use_outer_join=true
hibernate.max_fetch_depth=3
hibernate.dialect=net.sf.hibernate.dialect.Oracle9Dialect

michael · **Posted:** Tue Dec 14, 2004 7:00 am

This is expected. Either set FetchMode.LAZY for the association, or setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY) or distinctify the result yourself.

mikesu · **Joined:** Sun Apr 04, 2004 6:19 am **Posts:** 15

michael wrote:

This is expected. Either set FetchMode.LAZY for the association, or setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY) or distinctify the result yourself.

Rather strange decision by Hibernate team... :-/

What does lazy="true" together with outer-join="true" mean? ^^

It is somewhat frustrating that tweaking the config might require to change the code...

anthony · **Posted:** Wed Dec 15, 2004 9:08 am

Quote:

What does lazy="true" together with outer-join="true" mean? ^^

you should have started here.... read hibernate in action, you'll understand ;)

Dynapen · **Joined:** Thu Dec 02, 2004 3:51 pm **Posts:** 8

anthony-

I have read hibernate in action, and I still don't get it. From what I have read turning lazy="true" and outer-join="true" in the config file for a mapping shouldn't have had that effect.

What I understand is that setting lazy to true means that hibernate does not attempt to call association until it is requested in the code. (Meaning I can map pieces to a object, define them as lazy, and in cases where I know i don't need to show them Hibernate won't build them).

Outer-join, from my understanding, is exactly that. It specifies to the DB to execute the query using outer-join. (which in my case in the posting below, I have to have becuase not every parent will have a child.)

But that doesn't explain why the parent record is in this mapping is getting duped.

http://forums.hibernate.org/viewtopic.p ... 5f9441146a

This is a posting I had on this topic a day ago. Please, help me figure out what i am not understanding, becuase at this I am about to recommend that my office not move to hibernate becuase it has so many "quirks" that you have to configure around.