When executing a sql query which returns columns of sql type char, a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char for columns of entities no such problems occur.
Test case is attached.
Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2