How to use jsonb functions in hibernate 6?

Question

We use Postgres jsonb_agg function in criteria query API like this:

cb.function(
                JSONB_AGG_FUNCTION_NAME,
                JsonNode.class,
                someJoin.get(someField)
            )

and map a result into projection with constructor:

Projection (<some args>, com.fasterxml.jackson.databind.JsonNode node)

In Hibernate 5 we registered jsonb_agg function using this approach:

public class ExtendedPgDialect extends PostgreSQLDialect {

public static final String JSONB_AGG_FUNCTION_NAME = "jsonb_agg";

public ExtendedPgDialect() {
    registerFunction(JSONB_AGG_FUNCTION_NAME,
            new StandardSQLFunction(JSONB_AGG_FUNCTION_NAME, JsonNodeBinaryType.INSTANCE));
     }
}

But in Hibernate 6.6.33.Final we can't register that function and can't use it for querying data. Also we used (JsonNodeBinaryType) type from io.hypersistence:hypersistence-utils-hibernate-53 library. How to register jsonb_agg function in Hibernate 6 for mapping to JsonNode java type?

Роман Григорьев · Accepted Answer · 2025-10-30 10:04:42Z

0

Found a solution, may be it can be useful for someone.

public class ExtendedPgDialect extends PostgreSQLDialect {

    @Override
    protected void registerColumnTypes(TypeContributions typeContributions,
                                       ServiceRegistry serviceRegistry) {
        super.registerColumnTypes(typeContributions, serviceRegistry);
        typeContributions.contributeType(JsonNodeBinaryType.INSTANCE);
    }
}

So I have to register io.hypersistence.utils.hibernate.type.json.JsonNodeBinaryType for Hibernate without registering any function like that and now Hibernate can map jsonb column to JsonNode java field. My result generated query :

select
        <some columns>,
        jsonb_agg(<some column>)
    from <some table> ...

edited Oct 30 at 10:04

answered Oct 30 at 9:40

Роман Григорьев

1431 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use jsonb functions in hibernate 6?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related