Query parameter is modified and return as null

[urswag]

I use a stateless session bean this method.

In this query the first parameter textKey is set to password.

The query returns a label object with textKey field value null.

It is completly unlogical, the property is different to the search property but an object is found.

And as consequence somewhere afte the call of the method the database field texkey will set to null.

public Label findByTextKey(String textKey, Language language) {

Label label = (Label) labelsMap.get(textKey);
if (label == null) {
Query query = manager.createQuery(
"from Label l where l.textKey = :textKey and l.language = :language");
query.setParameter("textKey", textKey);
query.setParameter("language", language);
try {
label = ((Label) query.getSingleResult());
labelsMap.put(textKey, label);
}
catch (NoResultException nre) {

}
}

return label;
}

[urswag]

label is a reserved word in MySQL.
I use this word as table name --> generates strange effects.

[urswag]

It seems to be a bug.
I have the a similar problem in a other table.

The workaround that I use now.

I call

createNativeQuery

instead of

createQuery

or

find

of the

EntityManager

.

The consequence is the field is not set to null. Because I need only one field I don't have to return a hibernate entity object.