Hibernate PostgreSQL CITEXT issue: No Dialect mapping for JDBC type: 1111

Hibernate ORM
2

Implement your own Dialect

add maven dependency:
“<“dependency>
“<“groupId>com.vladmihalcea</groupId”>”
“<“artifactId>hibernate-types-52</artifactId”>”
“<“version>2.7.0</version”>”
</dependency”>”

import java.sql.Types;
import org.hibernate.dialect.PostgreSQL95Dialect;
import com.vladmihalcea.hibernate.type.json.JsonNodeBinaryType;
public class PostgreSQL95JsonDialect extends PostgreSQL95Dialect {
public PostgreSQL95JsonDialect() {
    super();
    this.registerHibernateType(Types.OTHER, JsonNodeBinaryType.class.getName());
    }
}

in application.properties file:
spring.jpa.properties.hibernate.dialect=PostgreSQL95JsonDialect