Hibernate version:
java 6.0:
mysql 6.0:
hi,
query:
Code:
hsqlQuery = "FROM client WHERE company=null ";
returns a correct result
query:
Code:
hsqlQuery = "FROM client WHERE company.name='eine Firma' ";
returns also a correct result
BUT:
Code:
hsqlQuery = "FROM client WHERE company=null OR company.name='Firma1'";
returns only companies where company NOT IS NULL.
the same problem occurs, when i try to order the clients by company.name. null companies are missing in the result.
so why does hibernate loose rows in the result, where references are NULL??
any clues/hints ?
thx in advance
franky
Code:
<class name="client" table="client">
<id name="id" column="ID" type="long">
<generator class="native"/>
</id>
<property name="firstname" column="firstname" />
<many-to-one name="company" column="ID_company" class="company" lazy="false" fetch="join"/>
</class>
<class name="company" table="company">
<id name="id" column="ID" type="long">
<generator class="native"/>
</id>
<property name="name" column="name"/>
</class>
[/code]
Login
FAQ
Search