fastexcel VS hypersistence-utils

fastexcel the fastest xlsx generation library

I've only had memory problems with apache poi. I only use https://github.com/dhatim/fastexcel now

You might want to take a look to fastexcel

Unfortunately, you cannot smoothly wrap the sequence-based IDs with value objects. There are solutions, but they are rather cumbersome. I left the proposal to the Hibernate types project of adding support to this feature. You’ve already seen the benefits of user-defined types. So, you can rate up my issue to make it more popular.

The Hibernate Types project.

I'm not aware of any JSON support coming in Hibernate 6, but I'll surely provide support for Hibernate 6 in the Hibernate Types OSS project, so you are going to be able to use the generic JsonType with Hibernate 6 as well.

I will blog about it in the following months. So far, I managed to add a new Hibernate Types module for Hibernate 6 and released the 2.15 version.

For current work, hibernate-types works great to support json/jsonb.

Now, related to your question. The entity field type has to be saved to a column type that JDBC has support for because you need to call the proper setXXX method on the JDBC PreparedStatement. In your case, which one of the standard PreparedStatement binding methods would you call to save that Map? That's a problem the Hibernate Types solves for you, and you can have whatever you want at the entity level: Map, JsonNode, POJO, List, String. And, the generic JsonType I created works for Oracle, PostgreSQL, MySQL, SQL Server, and H2 without any code change.

Complex DB structures are not a problem. You can map any database type you want: JSON, HStore, Ranges, Inet, as I did in this hypernate-types project.

Hibernate Types