I got following Exception: "org.hibernate.MappingException :No Dialect mapping for JDBC type: -9" , when I called:

query.list()

The solution was to override the Oracle10gDialect and add a mapping for the Type NVARCHAR.

registerHibernateType(Types.NVARCHAR, "string");

Is there any possibility for a fix in the next version?