I am using JPA with Hibernate and have a sql-result-set-mapping as follows:
Code:
<sql-result-set-mapping name="searchResults">
<column-result name="ID" />
<column-result name="SUBJECT" />
<column-result name="POINTS" />
</sql-result-set-mapping>
The field POINTS is mapped by a custom mapping. When I do this, I get the following:
Code:
org.hibernate.MappingException: No Dialect mapping for JDBC type: 2002
The weird thing is that if I let Hibernate handle the ORM on its own, then it works. It knows how to map the database type to my custom type.
Do custom mappings not work with sql-result-set-mapping? Is there anything else I can try?
Thanks for any insight.