Hello,

i have a pb using a simple HQL select command.

String q = "from XXX c where c.version.id = " + versionId;
List result = getDao().executeQuery(q);

this returns me always only 1 element in the result list, even if in my table i have multiples lines where the version id = the parameter !?...


If i use the following syntax instead :

String q = "from XXX where VERSION_ID = " + versionId;
List result = getDao().executeQuery(q);

(where VERSION_ID is the name of the SQL table column)
this time it returns me correctly all the lines where the version id equals my parameter !

please, can someone explain to me why these two requests don't return the same result ???...

thank you

Stephane

Hi Stephane

id is a reserved keyword in hql and it will always point to the id property and not to your version id

Reto

What does this method do ? Can you show the code that is actually performing the query ?

first of all thank you for answering me.

for Reto :
i can't see why the pb might come from the "id" as you suggest...
because in my application i have almost all objects that inherit from NamedObject, and so who have a "id" attribute that identifies them... and in the other HQL requests i make in the same way for various objects ("from XX x where x.id = myId") it seems to work correctly...

for Pksiv :
the code you asked :

public List executeQuery(String query)
{
return getHibernateTemplate().find(query);
}

Stephane,

Sorry but I don't use Spring and I'm amazed at how many problems I see posted here in regards to the getHibernateTemplate().find(query); method

The fact that it works when you specify the column name and not when you specify the property name makes me think that it's executing a SQLQuery instead of an HQL Query.

if it was the case, i would get an error when executing my request, or i would have none element found, isn't it ?
but in fact i have always as a result ONE element (the last element i have inserted in my database, with the id = to the parameter) !

how can i try to switch SQLQuery by HQLQuery with this HibernateTemplate.find request ?...