We have Date fields with type java.time.OffsetDateTime (JAVA8) in our models. We are using Microsoft SQL Server as our database. And Table columns in database are of type datetimeoffset. We are using Hibernate as ORM in our application. But we are not able to store our java.time.OffsetDateTime fields to sql server datetimeoffset column using Hibernate.

Please let us know how can we achieve this?

The OffsetDateTimeType constructor is defined like this:



This means that the expected SQL type is TIMESTAMP, not the SQL Server-specific datetimeoffset.
What you need to do so to create a new Type, possibly extending OffsetDateTimeType.

You can check this blog post to see an example of how you can do it.
Or you can use this custom UserType described in this StackOverflow question.