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

Hibernate ORM
1

Hello hibernate community,

I’m having an issue with hibernate mapping postres citext type to string, which causes mapping exception - No Dialect mapping for JDBC type: 1111

Basically, in postgresql. I’ve a column (SEC_ID) of type citext, and when I try to retrieve it by creating an sql query as:
createSQLQuery(“SELECT sec_mast.SEC_ID FROM URSV sec_mast”)

hibernate throws org.hibernate.mappingexception - No Dialect mapping for JDBC type: 1111

I’m unable to find a solution to this problem, so I would be really helpful if someone could provide me the solution or guide me where I should look for to find the solution to this problem.

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