hypersistence-utils: Cannot read the array length because "" thrown by Hibernate 6 when using the PostgreSQLEnumType with Audited
In combination with Envers, Hibernate throws error
java.lang.NullPointerException: Cannot read the array length because "<local3>" is null
at org.hibernate.type.EnumType.getAnnotation(EnumType.java:228)
at org.hibernate.type.EnumType.getEnumType(EnumType.java:219)
at org.hibernate.type.EnumType.setParameterValues(EnumType.java:126)
at com.vladmihalcea.hibernate.type.basic.PostgreSQLEnumType.setParameterValues(PostgreSQLEnumType.java:46)
at org.hibernate.mapping.MappingHelper.injectParameters(MappingHelper.java:70)
when I mark up an enum with the @Type(PostgreSQLEnumType.class) annotation. The problem can be reproduced very easily by changing the test as follows:
@Audited
@Entity(name = "Post")
@Table(name = "post")
public static class Post {
...
@Enumerated(EnumType.STRING)
@Column(columnDefinition = "post_status_info")
@Type(PostgreSQLEnumType.class)
private PostStatus status;
...
}
The expected behavior would be that also for the processing of the audit log table the annotations are recognized.
Setup
+- org.springframework.boot:spring-boot-starter-web:jar:3.0.0:compile
+- org.springframework.boot:spring-boot-starter-data-jpa:jar:3.0.0:compile
| +- org.hibernate.orm:hibernate-core:jar:6.1.5.Final:compile
| | +- jakarta.persistence:jakarta.persistence-api:jar:3.1.0:compile
| | \- ...
+- org.hibernate.orm:hibernate-envers:jar:6.1.5.Final:compile
+- com.vladmihalcea:hibernate-types-60:jar:2.20.0:compile
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Reactions: 2
- Comments: 34 (14 by maintainers)
Commits related to this issue
- Envers and Hibernate 6 and PostgreSQLEnumType #519 Add test case to demonstrate that the issue was fixed in Hibernate 6.2 — committed to vladmihalcea/hypersistence-utils by vladmihalcea a year ago
I’m sure that I could get used to it, but Java has been evolveing beautifully over the past years, so I’ll stick to it.
If
6.1.7has the fix forHHH-15970, and you can still replicate this issue mentioned here, thenHHH-15970is not related toHHH-15806.@skromberg The issue no longer replicates in HIbernate 6.2, and the project provides the
hypersistence-utils-hibernate-62for Hibernate 6.2.I created this test case to prove that the problem was solved in Hibernate.
@vladmihalcea - I have now invested three hours to understand the problem. The second call (by
@Auditedannotation) of the method setParameterValues is executed without the propertyorg.hibernate.type.ParameterType.xproperty -> {JavaXProperty@7552} "status"with the related annotationsHibernate should pass this correctly. Maybe my ticket is wrong here - and should be created in Hibernate.
you still use hypersistence-utils-hibernate-60 but there is a hypersistence-utils-hibernate-62
For boot user, I’ve tried it with spring boot 3.0.5, but it doesn’t work. probably we need to wait till 6.2.x version support from boot.
@dmitry-weirdo Here’s a list of 250 Major issues from 2004 onward that are all assigned.
I think you are missing the fact that the Hibernate ORM project has a very small team that has to work on:
When I was working on Hibernate, we were 4-5 people working on the project. I bet most of you are working on teams that have more devs than the Hibernate core team.
So, you can follow my advice and provide a fix, or you can leave it to chance and see how it goes. It’s up to you.
@skromberg As an ex-Hibernate developer, if the ticket was not assigned, it’s unlikely that it will be resolved.
So, from my experience, the best way to make sure that a ticket is resolved is if you provide a Pull Request with a fix proposal for it. Otherwise, it may take years if the issue is not critical to the core team. For instance, there will always be issues that will still be unresolved after 10 or 15 years.
@skromberg- That’s sad. It is the last puzzle for migration 😦
The only way I could make enum type work for postgres is to use below
and add specify stringtype=unspecified in jdbc url.
https://hibernate.atlassian.net/browse/HHH-15806