Hibernate throws org.hibernate.MappingException: No Dialect mapping for JDBC type: -9 with Oracle dialect

I am using org.hibernate.dialect.Oracle10gDialect for Oracle 12.2 database and using Hibernate version of 3.5.1

You need to upgrade to Hibernate 5.1, 5.2 or 5.3, and most likely the issue is already fixed.

Hibernate 3.5 is too old and no longer maintained for many years now.