Hibernate only return a result when must return a lot

txupitoak · **Joined:** Fri Sep 17, 2004 1:05 pm **Posts:** 10

I have this mapping association set

<set name="historyc" cascade="all" inverse="true" lazy="true">
<key column="C536870921"/>
<many-to-many class="helpdesk.IncidenceHistoryc"/>
</set>

and the hibernate query is

select historyc0_.C536870921 as C536870921__, historyc0_.C536870921 as C5368709210_, historyc0_.C536870916 as C5368709160_, historyc0_.C3 as C30_, historyc0_.C2 as C20_, historyc0_.C536870915 as C5368709150_, historyc0_.C536870913 as C5368709130_ from REGISTRO_HISTORICO_INCIDENCIA historyc0_ where historyc0_.C536870921=?

If I execute the query in the database works perfectly but hibernate is unable to do it well

What is the problem??

txupitoak · **Joined:** Fri Sep 17, 2004 1:05 pm **Posts:** 10

protected List objectsById (String object, String id) throws DAOException {
List results = null;
Criteria c = null;
try{

Session session = HibernateSession.currentSession();
Query byId = session.createQuery("from "+object+" h where h.id like :id");

byId.setString("id", "id);

results = byId.list();

return results;

}catch(HibernateException he){
throw new DAOException(he);
}
}

some people have a idea about the problem??
I'm sure that the problem is a bad use of hibernate but I don't know where I'm wrong

anthony · **Posted:** Wed Oct 13, 2004 1:21 pm

what about showingthe 2 complete mapping files? you may have a wrong id declaration

txupitoak · **Joined:** Fri Sep 17, 2004 1:05 pm **Posts:** 10

The mapping was wrong, thanks for the idea about the possible error