When fetching a List backed by a NULL PostgreSQL array, a NPE is thrown

[marceloverdijk]

I have PostgreSQL table with the following column:

previous_names VARCHAR(255)[] DEFAULT NULL

and mapped it to:

@Entity
@TypeDefs({
        @TypeDef(name = "string-array", typeClass = StringArrayType.class)
})
public class Project {

    @Column(name = "previous_names")
    @Type(type = "string-array")
    private List<String> previousNames = new ArrayList<>();
}

When querying this entity I get:

java.lang.NullPointerException: null
        at java.base/java.lang.reflect.Array.newArray(Native Method) ~[na:na]
        at java.base/java.lang.reflect.Array.newInstance(Array.java:78) ~[na:na]
        at com.vladmihalcea.hibernate.type.array.internal.ArrayUtil.unwrapArray(ArrayUtil.java:199) ~[hibernate-types-52-2.9.0.jar:na]
        at com.vladmihalcea.hibernate.type.array.internal.AbstractArrayTypeDescriptor.wrap(AbstractArrayTypeDescriptor.java:83) ~[hibernate-types-52-2.9.0.jar:na]
        at com.vladmihalcea.hibernate.type.array.internal.ArraySqlTypeDescriptor$2.doExtract(ArraySqlTypeDescriptor.java:55) ~[hibernate-types-52-2.9.0.jar:na]
        at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47) ~[hibernate-core-5.4.9.Final.jar:5.4.9.Final]

I just upgraded from 2.8.0 to 2.9.0 to be able to map List<String> types instead of String[].

Do I need some other configuration maybe?

[marceloverdijk]

Never mind, I overlooked the ListArrayType.

[vladmihalcea]

The issue could be valid. But I need a replication test case for that.

[vladmihalcea]

Fixed.

[marceloverdijk]

You were quicker fixing it than I could have a look at it ;-) Do you have a plan to release 2.10.0 or could this go in a 2.9.1 bigfix release?

[vladmihalcea]

I could do a 2.9.1 bugfix release as well. I think that's better, as I plan on releasing 2.10.0 only in February.

[marceloverdijk]

That would be appreciated (if you have time to do it).

[vladmihalcea]

I released the 2.9.1 version. You can check it out from Maven Central as soon as it's synced with Sonatype.

[amarkin]

@vladmihalcea, is this issue resolved. We are using hypersistence-utils-hibernate-55 version: 3.7.2 and still getting this error. Implemented the entity mappings exactly as described in here https://vladmihalcea.com/postgresql-array-java-list/

It works fine in my local windows machine, but we get this error when we deploy to other environments. To be exact the Array we are retrieving from DB is not even null.

[vladmihalcea]

If it works fine locally, then for sure the issue is not related to this framework.