java - datetimeoffset hibernate mapping

Question

I'm trying to use hibernate with ms sql server and have difficulties mapping the sql type datetimeoffset to java. If I try to set the mapping type in the reverse engineering configuration with:

I get an error saying sth. like org.hibernate.MappingException: jdbc-type: microsoft.sql.Types.DATETIMEOFFSET is not a known JDBC Type nor a valid number

I guess only the detault jdbc types can be used in this context.

Any ideas about how to solve this issue?

Answer 1

Your can provide a custom Hibernate user type. For example by implementing org.hibernate.type.MutableType.

Refer Hibernate Reference for more information.