HibernateTypesContributor does not register Types on Hibernate 5 and 4 for Oracle, SQL Server, and PostgreSQL

[SergeiKhmelevSPA]

Hibernate ORM core version: 5.6.8.Final
Hibernate Types 55 version: 2.16.2

During Spring Boot context creation MetadataBuildingProcess handles types provided via TypeContributor. So com.vladmihalcea.hibernate.type.HibernateTypesContributor also tries to contribute types. The problem is that it couldn't do it for Postgres because of the condition

// org.hibernate.dialect.PostgreSQLDialect
if(dialect instanceof PostgreSQLDialect)

PostgreSQLDialect is deprecated and PostgreSQL82Dialect should be used instead.

[SergeiKhmelevSPA]

And a question related to it. I tried to test contributeType() locally, but it doesn't seem to do anything. Eg. I still have to use

class CustomPostgresDialect : PostgreSQL10Dialect() {
	init {
		this.registerHibernateType(2003, StringArrayType::class.java.name)
	}
}

to allow support for StringArrayType for projections. To be honest, I expected it from contributeType(typeContributions, StringArrayType.INSTANCE).

[vladmihalcea]

Thanks for the tip. The PostgreSQLDialect is the default one in Hibernate 6, and I forgot to change it for 55.

[SergeiKhmelevSPA]

By the way, I noticed the same issue with OracleDialect

[vladmihalcea]

Don't worry, I'll amend the commit for Oracle and/or SQL Server too

[stevefranchak]

When might it be expected for 2.16.3 to be released? I'm unable to use hibernate-types until it is due to this issue.

[vladmihalcea]

I released the 2.16.3 version that features this fix.

[victornoel]

Hello @vladmihalcea, I am hitting a small issue with this fix: in my codebase, I am using version 2.16.2 and I never really realized that HibernateTypesContributor wasn't properly registering types for PostgreSQL (it seems it never was a problem when using json types).

I have legacy code that is using String[] as a type for a columns and is currently persisted as bytea in the db (this is the default behavior of hibernate 5.6 apparently).

I upgraded to 2.16.3 (because of the serialization issue from #438) and now, StringArrayType being properly registered, hibernate tries to persist my String[] column as a text[].

How would I go about disabling this only for that column?

Thank you, I hope it's ok to ask this here :)

[vladmihalcea]

First, Hibernate Types 2 is an ancient version. Thr project is called Hypersistence Utils and the latest version is 3.5.3.

Second, I no longer have the time to offer free support for this library. I only offer support via consulting.

[victornoel]

@vladmihalcea ok, thank you in any case for this great library :)

[vladmihalcea]

You're welcome.

[victornoel]

For anybody coming through here looking for the answer to my question, the solution was to force the type of the column to SerializableType as it seems to be the fallback Hibernate uses to persist String[]:

@Basic
@Type(type = "serializable")
private String[] column;