Hibernate version: 3.2.5.ga

Mapping documents: simply a class with a property mapped as a lava.lang.String

Name and version of the database you are using: Oracle 10g


I have a problem with a HQL query on the String propery of that class:

the query is "from CLASS where code=?".

This query works correcly except when the question mark is substituted with a String containing the character "§". In this case the search fails and the query returns no results, even if in the DB there are results.

Why?
It seams that hibernate translate the § character and so does not find results.
It is a string coding problem?

Bye

Check out the below two links.
http://opensource.atlassian.com/project ... e/HHH-2077
http://forum.hibernate.org/viewtopic.ph ... 657fdd6e14

May be useful to you:-)

thank you, but these do not solve the problem.

Any other idea?

Could it be character set issue, i.e. the symbol being encoded into a character set (most likely by the JDBC driver) different to what Oracle is assuming?

Can you enable some form of query logging in Oracle and see what the server is actually getting?

resolved, it was not an hibernate problem, but the parameter passed to my method was wrong