No Dialect mapping for JDBC type: -9 w/Hibernate 3 & Oracle 10g
Thanks for explaining the root cause of this.More details here: http://docs.oracle.com/cd/B19306_01/java.102/b14355/global.htm#CHDHHJDB
I was able to solve this by using a different version of Oracle JDBC driver.Downgrade of ojdbc6.jar from “11.2.0.3.0” that was on the prod server to “11.1.0.7.0-Production” used for development fixed this. The target server is NLS_RDBMS_VERSION 10.2.0.4.0