Binding to a Pg JSON-B column using Hibernate Types

[kittylyst]

I have a constructor with a Map<String, Object> field that should bind to a JSON-B field, but Hibernate can't find it and fails with "org.hibernate.hql.internal.ast.QuerySyntaxException: Unable to locate appropriate constructor on class".

The column is defined like this:

  @NotNull
  @Type(type = "jsonb")
  @Column(columnDefinition = "jsonb")
  private Map<String, Object> details;

and I have this dependency:

    <dependency>
      <groupId>io.quarkiverse.hibernatetypes</groupId>
      <artifactId>quarkus-hibernate-types</artifactId>
      <version>${quarkus-hibernate-types.version}</version>
    </dependency>

EDIT: Data is persisted fine with these definitions, but attempting to retrieve it causes the exception.

[quarkus-bot[bot]]

/cc @Sanne (hibernate-orm), @gsmet (hibernate-orm), @yrodiere (hibernate-orm)

[maxandersen]

can you provide the query you do and a full stacktrace? and possibly a reproducer?

p.s. persisting json natively in a database wasn't really done before hibernate 6 - quarkus 2.x uses hibernate 5.

[kittylyst]

        entityManager.createQuery(
            """
    select new com.redhat.runtimes.inventory.models.RuntimesInstance(
      i.id, i.accountId, i.orgId, i.hostname, i.launchTime, i.vendor, i.versionString,
      i.version, i.majorVersion, i.osArch, i.processors, i.heapMax, i.details, i.created
    ) from com.redhat.runtimes.inventory.models.RuntimesInstance i
    where i.orgId = :orgId and i.hostname = :hostname
    order by i.created desc
    """,
            RuntimesInstance.class);

produces this error:

[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: com.redhat.runtimes.inventory.models.RuntimesInstance]
	at org.hibernate.hql.internal.ast.tree.ConstructorNode.resolveConstructor(ConstructorNode.java:182)
	at org.hibernate.hql.internal.ast.tree.ConstructorNode.prepare(ConstructorNode.java:144)
	at org.hibernate.hql.internal.ast.HqlSqlWalker.processConstructor(HqlSqlWalker.java:1271)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectExpr(HqlSqlBaseWalker.java:2409)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:2275)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1534)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:611)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:339)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:287)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:276)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:192)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144)
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:113)
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73)
	at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162)
	at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:636)
	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:748)
	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:848)
	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:114)
	at io.quarkus.hibernate.orm.runtime.session.TransactionScopedSession.createQuery(TransactionScopedSession.java:389)
	at org.hibernate.engine.spi.SessionLazyDelegator.createQuery(SessionLazyDelegator.java:487)
	at org.hibernate.engine.spi.SessionLazyDelegator.createQuery(SessionLazyDelegator.java:65)
	at org.hibernate.Session_5b93bee577ae2f8d76647de04cfab36afbf52958_Synthetic_ClientProxy.createQuery(Unknown Source)
	at com.redhat.runtimes.inventory.web.DisplayInventory.getRuntimeRecord(DisplayInventory.java:42)
	at com.redhat.runtimes.inventory.web.DisplayInventory$quarkusrestinvoker$getRuntimeRecord_75ba74869924008cc54d9a74e22a67d9d3ef3f00.invoke(Unknown Source)
	at org.jboss.resteasy.reactive.server.handlers.InvocationHandler.handle(InvocationHandler.java:29)
	at io.quarkus.resteasy.reactive.server.runtime.QuarkusResteasyReactiveRequestContext.invokeHandler(QuarkusResteasyReactiveRequestContext.java:114)
	at org.jboss.resteasy.reactive.common.core.AbstractResteasyReactiveContext.run(AbstractResteasyReactiveContext.java:145)
	at io.quarkus.vertx.core.runtime.VertxCoreRecorder$14.runWith(VertxCoreRecorder.java:576)
	at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2449)
	at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1478)
	at org.jboss.threads.DelegatingRunnable.run(DelegatingRunnable.java:29)
	at org.jboss.threads.ThreadLocalResettingRunnable.run(ThreadLocalResettingRunnable.java:29)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.base/java.lang.Thread.run(Thread.java:833)

[kittylyst]

OK, I have found a workaround. The Hibernate mapping is expecting a constructor parameter of type Object for the JSON-B column.

So, if you give it one, and then perform an unchecked cast in the constructor it works "fine".

  public RuntimesInstance(
      // ....
      Object details,
      // ....
      ) {
      // ....
    this.details = (Map<String, Object>)details;
      // ....
  }

[maxandersen]

hmm - somehow the typeinfo get lost; sound like a bug/missing feature in the custom hibernatetypes or limitation of the select new syntax.

[beikov]

A reproducer would be nice for this to check what is going on, but I think that the type might not be properly initialized (maybe only in Quarkus?). This method should be called to properly set the type: https://github.com/vladmihalcea/hypersistence-utils/blob/master/hypersistence-utils-hibernate-55/src/main/java/io/hypersistence/utils/hibernate/type/json/internal/JsonTypeDescriptor.java#L66

[dan1els]

I ended up using import io.vertx.core.json.JsonObject;