search

starnowski / posjsonhelper

The Posjsonhelper library is an open-source project that adds support for Hibernate queries for Postgresql JSON functions and full-text search.
GNU Lesser General Public License v2.1
13 stars 0 forks source link

Criteria JPA Error on a spring boot project #145

Open sbodese opened 2 months ago

sbodese commented 2 months ago

Hi, thanks for this project to query more code driven complex json data with postgres.

I need a hint please, maybe i forgot to include a further maven dependency, but i got this error if i try a adapted "findAllByAllMatchingTags" function with a spring boot 3.3.3 project

Greetings Steffen

java.lang.NoSuchMethodError: 'org.hibernate.query.criteria.JpaExpression org.hibernate.query.sqm.NodeBuilder.value(java.lang.Object)' at com.github.starnowski.posjsonhelper.hibernate6.AbstractJsonBExtractPath.lambda$mapPathParameters$0(AbstractJsonBExtractPath.java:90) ~[hibernate6-0.4.1.jar:na] at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) ~[na:na] at java.base/java.util.Collections$2.tryAdvance(Collections.java:4853) ~[na:na] at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4861) ~[na:na] at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na] at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[na:na] at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921) ~[na:na] at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:na] at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682) ~[na:na] at com.github.starnowski.posjsonhelper.hibernate6.AbstractJsonBExtractPath.mapPathParameters(AbstractJsonBExtractPath.java:90) ~[hibernate6-0.4.1.jar:na]

starnowski commented 2 months ago

Hi Steffen,

So, I'll have to look at what changes were made in Hibernate 6.5, probably apply the changes, and release a new version.

sbodese commented 2 months ago

Hi Szymon,

thanks. I got this exception even with Spring Boot 3.1.4.

Greetings Steffen

starnowski commented 2 months ago

Yeah,

From what I checked Spring Boot 3.1.4 use hibernate 6.2 and Spring Boot 3.3.0 use hibernate 6.5. Below are the supported hibernate versions for this library (btw, sorry that there is a missing label in README.md file at the beginning)

https://github.com/starnowski/posjsonhelper?tab=readme-ov-file#hibernate-6-version-compatibility

Posjsonhelper Hibernate 6
0.3.0 6.4.0.Final
0.2.0 - 0.2.1 6.1.5.Final

Btw, it is not the solution (the solution is to upgrade posjsonhelper to support 6.5), but you could always try to exclude hibernate for Spring Boot 3.1 and add as a transient dependency 6.4

starnowski commented 2 months ago

QQ, could you check what version of Hibernate you have on the Classpath? Just to make sure that it is 6.5.2

sbodese commented 2 months ago

Hi Szymon,

here my classpath about hibernate:

with Spring Boot 3.3.3 Maven: org.hibernate.orm:hibernate-core:6.5.2.Final Maven: org.hibernate.common:hibernate-commons-annotations:6.0.6.Final

with Spring 3.1.4 Maven: org.hibernate.orm:hibernate-core:6.2.9.Final Maven: org.hibernate.common:hibernate-commons-annotations:6.0.6.Final

Greetings Steffen

starnowski commented 2 months ago

Sorry for digging, but I am still struggling to reproduce this issue. I guess you already did it but Could you check your dependency tree and see if you don't actually have other hibernate libs? To make sure.

mvn dependency:tree -Dverbose

Or

mvn dependency:tree -Dverbose -Dincludes=org.hibernate.orm:hibernate-core

sbodese commented 2 months ago

hi, oh sry.

here is my POM pom.zip

spring boot 3.14

[INFO] +- org.springframework.boot:spring-boot-starter-actuator:jar:3.1.4:compile [INFO] | +- org.springframework.boot:spring-boot-starter:jar:3.1.4:compile (version managed from 3.1.4; scope not updated to compile) [INFO] | | +- (org.springframework.boot:spring-boot:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- (org.springframework.boot:spring-boot-autoconfigure:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- org.springframework.boot:spring-boot-starter-logging:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | | +- ch.qos.logback:logback-classic:jar:1.4.11:compile (version managed from 1.4.11) [INFO] | | | | +- ch.qos.logback:logback-core:jar:1.4.11:compile (version managed from 1.4.11) [INFO] | | | | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.7; omitted for duplicate) [INFO] | | | +- org.apache.logging.log4j:log4j-to-slf4j:jar:2.20.0:compile (version managed from 2.20.0) [INFO] | | | | +- org.apache.logging.log4j:log4j-api:jar:2.20.0:compile (version managed from 2.20.0) [INFO] | | | | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 1.7.36; omitted for duplicate) [INFO] | | | \- org.slf4j:jul-to-slf4j:jar:2.0.9:compile (version managed from 2.0.9) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.9; omitted for duplicate) [INFO] | | +- jakarta.annotation:jakarta.annotation-api:jar:2.1.1:compile (version managed from 2.1.1) [INFO] | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | \- org.yaml:snakeyaml:jar:1.33:compile (version managed from 1.33) [INFO] | +- org.springframework.boot:spring-boot-actuator-autoconfigure:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | +- org.springframework.boot:spring-boot-actuator:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | | \- (org.springframework.boot:spring-boot:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- (org.springframework.boot:spring-boot:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- (org.springframework.boot:spring-boot-autoconfigure:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- com.fasterxml.jackson.core:jackson-databind:jar:2.15.2:compile (version managed from 2.15.2) [INFO] | | | +- (com.fasterxml.jackson.core:jackson-annotations:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | | \- com.fasterxml.jackson.core:jackson-core:jar:2.15.2:compile (version managed from 2.15.2) [INFO] | | \- com.fasterxml.jackson.datatype:jackson-datatype-jsr310:jar:2.15.2:compile (version managed from 2.15.2; scope not updated to compile) [INFO] | | +- (com.fasterxml.jackson.core:jackson-annotations:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.core:jackson-core:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | \- (com.fasterxml.jackson.core:jackson-databind:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | +- io.micrometer:micrometer-observation:jar:1.11.4:compile (version managed from 1.11.4) [INFO] | | \- io.micrometer:micrometer-commons:jar:1.11.4:compile (version managed from 1.11.4) [INFO] | \- io.micrometer:micrometer-core:jar:1.11.4:compile (version managed from 1.11.4) [INFO] | +- (io.micrometer:micrometer-commons:jar:1.11.4:compile - version managed from 1.11.4; omitted for duplicate) [INFO] | +- (io.micrometer:micrometer-observation:jar:1.11.4:compile - version managed from 1.11.4; omitted for duplicate) [INFO] | +- org.hdrhistogram:HdrHistogram:jar:2.1.12:runtime [INFO] | \- org.latencyutils:LatencyUtils:jar:2.0.3:runtime [INFO] +- org.springframework.boot:spring-boot-starter-data-jpa:jar:3.1.4:compile [INFO] | +- org.springframework.boot:spring-boot-starter-aop:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | +- (org.springframework.boot:spring-boot-starter:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- org.springframework:spring-aop:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | \- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | \- org.aspectj:aspectjweaver:jar:1.9.20:compile (version managed from 1.9.20) [INFO] | +- org.springframework.boot:spring-boot-starter-jdbc:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | +- (org.springframework.boot:spring-boot-starter:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- com.zaxxer:HikariCP:jar:5.0.1:compile (version managed from 5.0.1) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.0-alpha1; omitted for duplicate) [INFO] | | \- org.springframework:spring-jdbc:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | \- (org.springframework:spring-tx:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | +- org.hibernate.orm:hibernate-core:jar:6.2.9.Final:compile (version managed from 6.2.9.Final) [INFO] | | +- jakarta.persistence:jakarta.persistence-api:jar:3.1.0:compile (version managed from 3.1.0) [INFO] | | +- jakarta.transaction:jakarta.transaction-api:jar:2.0.1:compile (version managed from 2.0.1) [INFO] | | +- org.jboss.logging:jboss-logging:jar:3.5.3.Final:runtime (version managed from 3.5.0.Final) [INFO] | | +- org.hibernate.common:hibernate-commons-annotations:jar:6.0.6.Final:runtime [INFO] | | +- io.smallrye:jandex:jar:3.0.5:runtime [INFO] | | +- com.fasterxml:classmate:jar:1.5.1:runtime (version managed from 1.5.1) [INFO] | | +- net.bytebuddy:byte-buddy:jar:1.14.8:runtime (version managed from 1.14.7; scope not updated to runtime) [INFO] | | +- (jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.1:runtime - version managed from 4.0.0; omitted for duplicate) [INFO] | | +- org.glassfish.jaxb:jaxb-runtime:jar:4.0.3:runtime (version managed from 4.0.2) [INFO] | | | \- org.glassfish.jaxb:jaxb-core:jar:4.0.3:runtime (version managed from 4.0.3) [INFO] | | | +- (jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.1:runtime - version managed from 4.0.0; omitted for duplicate) [INFO] | | | +- (jakarta.activation:jakarta.activation-api:jar:2.1.2:runtime - version managed from 2.1.2; omitted for duplicate) [INFO] | | | +- org.eclipse.angus:angus-activation:jar:2.0.1:runtime (version managed from 2.0.1) [INFO] | | | | \- (jakarta.activation:jakarta.activation-api:jar:2.1.2:runtime - version managed from 2.1.2; omitted for duplicate) [INFO] | | | +- org.glassfish.jaxb:txw2:jar:4.0.3:runtime (version managed from 4.0.3) [INFO] | | | \- com.sun.istack:istack-commons-runtime:jar:4.1.2:runtime (version managed from 4.1.2) [INFO] | | +- jakarta.inject:jakarta.inject-api:jar:2.0.1:runtime [INFO] | | \- org.antlr:antlr4-runtime:jar:4.10.1:compile [INFO] | +- org.springframework.data:spring-data-jpa:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | +- org.springframework.data:spring-data-commons:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.2; omitted for duplicate) [INFO] | | +- org.springframework:spring-orm:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-jdbc:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | \- (org.springframework:spring-tx:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- org.springframework:spring-context:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | | | +- (org.springframework:spring-aop:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | \- (org.springframework:spring-expression:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- (org.springframework:spring-aop:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- org.springframework:spring-tx:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | | \- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- org.springframework:spring-beans:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | | | \- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- (org.antlr:antlr4-runtime:jar:4.10.1:compile - omitted for duplicate) [INFO] | | +- (jakarta.annotation:jakarta.annotation-api:jar:2.1.1:compile - version managed from 2.0.0; omitted for duplicate) [INFO] | | \- org.slf4j:slf4j-api:jar:2.0.9:compile (version managed from 2.0.2) [INFO] | \- org.springframework:spring-aspects:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | \- (org.aspectj:aspectjweaver:jar:1.9.20:compile - version managed from 1.9.20; omitted for duplicate) [INFO] +- org.springframework.boot:spring-boot-starter-data-rest:jar:3.1.4:compile [INFO] | +- (org.springframework.boot:spring-boot-starter-web:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | \- org.springframework.data:spring-data-rest-webmvc:jar:4.1.4:compile (version managed from 4.1.4) [INFO] | +- org.springframework.data:spring-data-rest-core:jar:4.1.4:compile (version managed from 4.1.4) [INFO] | | +- (org.springframework:spring-tx:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- org.springframework.hateoas:spring-hateoas:jar:2.1.2:compile (version managed from 2.1.2) [INFO] | | | +- (org.springframework:spring-aop:jar:6.0.12:compile - version managed from 6.0.11; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.11; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-context:jar:6.0.12:compile - version managed from 6.0.11; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.11; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-web:jar:6.0.12:compile - version managed from 6.0.11; omitted for duplicate) [INFO] | | | +- (org.springframework.plugin:spring-plugin-core:jar:3.0.0:compile - omitted for duplicate) [INFO] | | | +- (com.jayway.jsonpath:json-path:jar:2.8.0:compile - version managed from 2.7.0; omitted for duplicate) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.7; omitted for duplicate) [INFO] | | +- (org.springframework.data:spring-data-commons:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- org.springframework.plugin:spring-plugin-core:jar:3.0.0:compile [INFO] | | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.0; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-context:jar:6.0.12:compile - version managed from 6.0.0; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-aop:jar:6.0.12:compile - version managed from 6.0.0; omitted for duplicate) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.3; omitted for duplicate) [INFO] | | +- org.atteo:evo-inflector:jar:1.3:compile [INFO] | | +- (com.fasterxml.jackson.core:jackson-annotations:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.datatype:jackson-datatype-jdk8:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.2; omitted for duplicate) [INFO] | +- (org.springframework:spring-webmvc:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | +- (com.fasterxml.jackson.core:jackson-databind:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | +- com.fasterxml.jackson.core:jackson-annotations:jar:2.15.2:compile (version managed from 2.15.2) [INFO] | \- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.2; omitted for duplicate) [INFO] +- org.springframework.boot:spring-boot-starter-web:jar:3.1.4:compile [INFO] | +- (org.springframework.boot:spring-boot-starter:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | +- org.springframework.boot:spring-boot-starter-json:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | +- (org.springframework.boot:spring-boot-starter:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- (org.springframework:spring-web:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.core:jackson-databind:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | +- com.fasterxml.jackson.datatype:jackson-datatype-jdk8:jar:2.15.2:compile (version managed from 2.15.2) [INFO] | | | +- (com.fasterxml.jackson.core:jackson-core:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | | \- (com.fasterxml.jackson.core:jackson-databind:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.datatype:jackson-datatype-jsr310:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | \- com.fasterxml.jackson.module:jackson-module-parameter-names:jar:2.15.2:compile (version managed from 2.15.2) [INFO] | | +- (com.fasterxml.jackson.core:jackson-core:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | \- (com.fasterxml.jackson.core:jackson-databind:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | +- org.springframework.boot:spring-boot-starter-tomcat:jar:3.1.4:compile (version managed from 3.1.4) [INFO] | | +- (jakarta.annotation:jakarta.annotation-api:jar:2.1.1:compile - version managed from 2.1.1; omitted for duplicate) [INFO] | | +- org.apache.tomcat.embed:tomcat-embed-core:jar:10.1.13:compile (version managed from 10.1.13) [INFO] | | +- org.apache.tomcat.embed:tomcat-embed-el:jar:10.1.13:compile (version managed from 10.1.13) [INFO] | | \- org.apache.tomcat.embed:tomcat-embed-websocket:jar:10.1.13:compile (version managed from 10.1.13) [INFO] | | \- (org.apache.tomcat.embed:tomcat-embed-core:jar:10.1.13:compile - version managed from 10.1.13; omitted for duplicate) [INFO] | +- org.springframework:spring-web:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | \- (io.micrometer:micrometer-observation:jar:1.11.4:compile - version managed from 1.10.11; omitted for duplicate) [INFO] | \- org.springframework:spring-webmvc:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | +- (org.springframework:spring-aop:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | +- (org.springframework:spring-beans:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | +- (org.springframework:spring-context:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | +- org.springframework:spring-expression:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | | \- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | \- (org.springframework:spring-web:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] +- org.springframework.boot:spring-boot-devtools:jar:3.1.4:runtime [INFO] | +- org.springframework.boot:spring-boot:jar:3.1.4:compile (version managed from 3.1.4; scope not updated to compile) [INFO] | | +- (org.springframework:spring-core:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | | \- (org.springframework:spring-context:jar:6.0.12:compile - version managed from 6.0.12; omitted for duplicate) [INFO] | \- org.springframework.boot:spring-boot-autoconfigure:jar:3.1.4:compile (version managed from 3.1.4; scope not updated to compile) [INFO] | \- (org.springframework.boot:spring-boot:jar:3.1.4:compile - version managed from 3.1.4; omitted for duplicate) [INFO] +- org.postgresql:postgresql:jar:42.6.0:runtime [INFO] | \- org.checkerframework:checker-qual:jar:3.31.0:runtime [INFO] +- org.springframework.boot:spring-boot-configuration-processor:jar:3.1.4:compile [INFO] +- org.projectlombok:lombok:jar:1.18.30:compile [INFO] +- org.springframework.boot:spring-boot-starter-test:jar:3.1.4:test [INFO] | +- (org.springframework.boot:spring-boot-starter:jar:3.1.4:test - version managed from 3.1.4; omitted for duplicate) [INFO] | +- org.springframework.boot:spring-boot-test:jar:3.1.4:test (version managed from 3.1.4) [INFO] | | \- (org.springframework.boot:spring-boot:jar:3.1.4:test - version managed from 3.1.4; omitted for duplicate) [INFO] | +- org.springframework.boot:spring-boot-test-autoconfigure:jar:3.1.4:test (version managed from 3.1.4) [INFO] | | +- (org.springframework.boot:spring-boot:jar:3.1.4:test - version managed from 3.1.4; omitted for duplicate) [INFO] | | +- (org.springframework.boot:spring-boot-test:jar:3.1.4:test - version managed from 3.1.4; omitted for duplicate) [INFO] | | \- (org.springframework.boot:spring-boot-autoconfigure:jar:3.1.4:test - version managed from 3.1.4; omitted for duplicate) [INFO] | +- com.jayway.jsonpath:json-path:jar:2.8.0:compile (version managed from 2.8.0) [INFO] | | +- (net.minidev:json-smart:jar:2.4.11:runtime - version managed from 2.4.10; omitted for duplicate) [INFO] | | \- (org.slf4j:slf4j-api:jar:2.0.9:runtime - version managed from 1.7.36; omitted for duplicate) [INFO] | +- jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.1:compile (version managed from 4.0.1) [INFO] | | \- jakarta.activation:jakarta.activation-api:jar:2.1.2:compile (version managed from 2.1.2) [INFO] | +- net.minidev:json-smart:jar:2.4.11:runtime (version managed from 2.4.11; scope not updated to runtime) [INFO] | | \- net.minidev:accessors-smart:jar:2.4.11:runtime [INFO] | | \- org.ow2.asm:asm:jar:9.3:runtime [INFO] | +- org.assertj:assertj-core:jar:3.24.2:test (version managed from 3.24.2) [INFO] | | \- (net.bytebuddy:byte-buddy:jar:1.14.8:test - version managed from 1.12.21; omitted for duplicate) [INFO] | +- org.hamcrest:hamcrest:jar:2.2:test (version managed from 2.2) [INFO] | +- org.junit.jupiter:junit-jupiter:jar:5.9.3:test (version managed from 5.9.3) [INFO] | | +- org.junit.jupiter:junit-jupiter-api:jar:5.9.3:test (version managed from 5.9.3) [INFO] | | | +- org.opentest4j:opentest4j:jar:1.2.0:test [INFO] | | | +- org.junit.platform:junit-platform-commons:jar:1.9.3:test (version managed from 1.9.3) [INFO] | | | | \- (org.apiguardian:apiguardian-api:jar:1.1.2:test - omitted for duplicate) [INFO] | | | \- org.apiguardian:apiguardian-api:jar:1.1.2:test [INFO] | | +- org.junit.jupiter:junit-jupiter-params:jar:5.9.3:test (version managed from 5.9.3) [INFO] | | | +- (org.junit.jupiter:junit-jupiter-api:jar:5.9.3:test - version managed from 5.9.3; omitted for duplicate) [INFO] | | | \- (org.apiguardian:apiguardian-api:jar:1.1.2:test - omitted for duplicate) [INFO] | | \- org.junit.jupiter:junit-jupiter-engine:jar:5.9.3:test (version managed from 5.9.3) [INFO] | | +- org.junit.platform:junit-platform-engine:jar:1.9.3:test (version managed from 1.9.3) [INFO] | | | +- (org.opentest4j:opentest4j:jar:1.2.0:test - omitted for duplicate) [INFO] | | | +- (org.junit.platform:junit-platform-commons:jar:1.9.3:test - version managed from 1.9.3; omitted for duplicate) [INFO] | | | \- (org.apiguardian:apiguardian-api:jar:1.1.2:test - omitted for duplicate) [INFO] | | +- (org.junit.jupiter:junit-jupiter-api:jar:5.9.3:test - version managed from 5.9.3; omitted for duplicate) [INFO] | | \- (org.apiguardian:apiguardian-api:jar:1.1.2:test - omitted for duplicate) [INFO] | +- org.mockito:mockito-core:jar:5.3.1:test (version managed from 5.3.1) [INFO] | | +- (net.bytebuddy:byte-buddy:jar:1.14.8:test - version managed from 1.14.4; omitted for duplicate) [INFO] | | +- net.bytebuddy:byte-buddy-agent:jar:1.14.8:test (version managed from 1.14.4) [INFO] | | \- org.objenesis:objenesis:jar:3.3:test [INFO] | +- org.mockito:mockito-junit-jupiter:jar:5.3.1:test (version managed from 5.3.1) [INFO] | | +- (org.mockito:mockito-core:jar:5.3.1:test - version managed from 5.3.1; omitted for duplicate) [INFO] | | \- (org.junit.jupiter:junit-jupiter-api:jar:5.9.3:test - version managed from 5.9.2; omitted for duplicate) [INFO] | +- org.skyscreamer:jsonassert:jar:1.5.1:test (version managed from 1.5.1) [INFO] | | \- com.vaadin.external.google:android-json:jar:0.0.20131108.vaadin1:test [INFO] | +- org.springframework:spring-core:jar:6.0.12:compile (version managed from 6.0.12; scope not updated to compile) [INFO] | | \- org.springframework:spring-jcl:jar:6.0.12:compile (version managed from 6.0.12) [INFO] | +- org.springframework:spring-test:jar:6.0.12:test (version managed from 6.0.12) [INFO] | | \- (org.springframework:spring-core:jar:6.0.12:test - version managed from 6.0.12; omitted for duplicate) [INFO] | \- org.xmlunit:xmlunit-core:jar:2.9.1:test (version managed from 2.9.1) [INFO] | \- (jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.1:test - version managed from 2.3.3; omitted for duplicate) [INFO] +- com.github.starnowski.posjsonhelper:hibernate6:jar:0.4.1:compile [INFO] | +- com.github.starnowski.posjsonhelper:json-core:jar:0.4.1:compile [INFO] | | \- com.github.starnowski.posjsonhelper:core:jar:0.4.1:compile [INFO] | | \- org.reflections:reflections:jar:0.9.12:compile [INFO] | | \- org.javassist:javassist:jar:3.26.0-GA:compile [INFO] | \- com.github.starnowski.posjsonhelper:hibernate6-core:jar:0.4.1:compile [INFO] | \- (com.github.starnowski.posjsonhelper:core:jar:0.4.1:compile - omitted for duplicate) [INFO] \- org.springdoc:springdoc-openapi-starter-webmvc-ui:jar:2.6.0:compile [INFO] +- org.springdoc:springdoc-openapi-starter-webmvc-api:jar:2.6.0:compile [INFO] | +- org.springdoc:springdoc-openapi-starter-common:jar:2.6.0:compile [INFO] | | +- (org.springframework.boot:spring-boot-autoconfigure:jar:3.1.4:compile - version managed from 3.3.0; omitted for duplicate) [INFO] | | \- io.swagger.core.v3:swagger-core-jakarta:jar:2.2.22:compile [INFO] | | +- org.apache.commons:commons-lang3:jar:3.12.0:compile (version managed from 3.14.0) [INFO] | | +- (org.slf4j:slf4j-api:jar:2.0.9:compile - version managed from 2.0.9; omitted for duplicate) [INFO] | | +- io.swagger.core.v3:swagger-annotations-jakarta:jar:2.2.22:compile [INFO] | | +- io.swagger.core.v3:swagger-models-jakarta:jar:2.2.22:compile [INFO] | | | \- (com.fasterxml.jackson.core:jackson-annotations:jar:2.15.2:compile - version managed from 2.16.2; omitted for duplicate) [INFO] | | +- (org.yaml:snakeyaml:jar:1.33:compile - version managed from 2.2; omitted for duplicate) [INFO] | | +- (jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.1:compile - version managed from 3.0.1; omitted for duplicate) [INFO] | | +- jakarta.validation:jakarta.validation-api:jar:3.0.2:compile (version managed from 3.0.2) [INFO] | | +- (com.fasterxml.jackson.core:jackson-annotations:jar:2.15.2:compile - version managed from 2.16.2; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.core:jackson-databind:jar:2.15.2:compile - version managed from 2.16.2; omitted for duplicate) [INFO] | | +- com.fasterxml.jackson.dataformat:jackson-dataformat-yaml:jar:2.15.2:compile (version managed from 2.16.2) [INFO] | | | +- (com.fasterxml.jackson.core:jackson-databind:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | | +- (org.yaml:snakeyaml:jar:1.33:compile - version managed from 2.0; omitted for duplicate) [INFO] | | | \- (com.fasterxml.jackson.core:jackson-core:jar:2.15.2:compile - version managed from 2.15.2; omitted for duplicate) [INFO] | | \- (com.fasterxml.jackson.datatype:jackson-datatype-jsr310:jar:2.15.2:compile - version managed from 2.16.2; omitted for duplicate) [INFO] | \- (org.springframework:spring-webmvc:jar:6.0.12:compile - version managed from 6.1.8; omitted for duplicate) [INFO] \- org.webjars:swagger-ui:jar:5.17.14:compile

spring boot 3.3.3 output, mvn dependency:tree -Dverbose

[INFO] +- org.springframework.boot:spring-boot-starter-actuator:jar:3.3.3:compile [INFO] | +- org.springframework.boot:spring-boot-starter:jar:3.3.3:compile (version managed from 3.3.3; scope not updated to compile) [INFO] | | +- (org.springframework.boot:spring-boot:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- (org.springframework.boot:spring-boot-autoconfigure:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- org.springframework.boot:spring-boot-starter-logging:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | | +- ch.qos.logback:logback-classic:jar:1.5.7:compile (version managed from 1.5.7) [INFO] | | | | +- ch.qos.logback:logback-core:jar:1.5.7:compile (version managed from 1.5.7) [INFO] | | | | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.15; omitted for duplicate) [INFO] | | | +- org.apache.logging.log4j:log4j-to-slf4j:jar:2.23.1:compile (version managed from 2.23.1) [INFO] | | | | +- org.apache.logging.log4j:log4j-api:jar:2.23.1:compile (version managed from 2.23.1) [INFO] | | | | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.9; omitted for duplicate) [INFO] | | | \- org.slf4j:jul-to-slf4j:jar:2.0.16:compile (version managed from 2.0.16) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.16; omitted for duplicate) [INFO] | | +- jakarta.annotation:jakarta.annotation-api:jar:2.1.1:compile (version managed from 2.1.1) [INFO] | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | \- org.yaml:snakeyaml:jar:2.2:compile (version managed from 2.2) [INFO] | +- org.springframework.boot:spring-boot-actuator-autoconfigure:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | +- org.springframework.boot:spring-boot-actuator:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | | \- (org.springframework.boot:spring-boot:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- (org.springframework.boot:spring-boot:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- (org.springframework.boot:spring-boot-autoconfigure:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- com.fasterxml.jackson.core:jackson-databind:jar:2.17.2:compile (version managed from 2.17.2) [INFO] | | | +- (com.fasterxml.jackson.core:jackson-annotations:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | | \- com.fasterxml.jackson.core:jackson-core:jar:2.17.2:compile (version managed from 2.17.2) [INFO] | | \- com.fasterxml.jackson.datatype:jackson-datatype-jsr310:jar:2.17.2:compile (version managed from 2.17.2; scope not updated to compile) [INFO] | | +- (com.fasterxml.jackson.core:jackson-annotations:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.core:jackson-core:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | \- (com.fasterxml.jackson.core:jackson-databind:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | +- io.micrometer:micrometer-observation:jar:1.13.3:compile (version managed from 1.13.3) [INFO] | | \- io.micrometer:micrometer-commons:jar:1.13.3:compile (version managed from 1.13.3) [INFO] | \- io.micrometer:micrometer-jakarta9:jar:1.13.3:compile (version managed from 1.13.3) [INFO] | +- io.micrometer:micrometer-core:jar:1.13.3:compile (version managed from 1.13.3) [INFO] | | +- (io.micrometer:micrometer-commons:jar:1.13.3:compile - version managed from 1.13.3; omitted for duplicate) [INFO] | | +- (io.micrometer:micrometer-observation:jar:1.13.3:compile - version managed from 1.13.3; omitted for duplicate) [INFO] | | +- org.hdrhistogram:HdrHistogram:jar:2.2.2:runtime [INFO] | | \- org.latencyutils:LatencyUtils:jar:2.0.3:runtime [INFO] | +- (io.micrometer:micrometer-commons:jar:1.13.3:compile - version managed from 1.13.3; omitted for duplicate) [INFO] | \- (io.micrometer:micrometer-observation:jar:1.13.3:compile - version managed from 1.13.3; omitted for duplicate) [INFO] +- org.springframework.boot:spring-boot-starter-data-jpa:jar:3.3.3:compile [INFO] | +- org.springframework.boot:spring-boot-starter-aop:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | +- (org.springframework.boot:spring-boot-starter:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- org.springframework:spring-aop:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | \- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | \- org.aspectj:aspectjweaver:jar:1.9.22.1:compile (version managed from 1.9.22.1) [INFO] | +- org.springframework.boot:spring-boot-starter-jdbc:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | +- (org.springframework.boot:spring-boot-starter:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- com.zaxxer:HikariCP:jar:5.1.0:compile (version managed from 5.1.0) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 1.7.36; omitted for duplicate) [INFO] | | \- org.springframework:spring-jdbc:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | \- (org.springframework:spring-tx:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | +- org.hibernate.orm:hibernate-core:jar:6.5.2.Final:compile (version managed from 6.5.2.Final) [INFO] | | +- jakarta.persistence:jakarta.persistence-api:jar:3.1.0:compile (version managed from 3.1.0) [INFO] | | +- jakarta.transaction:jakarta.transaction-api:jar:2.0.1:compile (version managed from 2.0.1) [INFO] | | +- org.jboss.logging:jboss-logging:jar:3.5.3.Final:runtime (version managed from 3.5.0.Final) [INFO] | | +- org.hibernate.common:hibernate-commons-annotations:jar:6.0.6.Final:runtime [INFO] | | +- io.smallrye:jandex:jar:3.1.2:runtime [INFO] | | +- com.fasterxml:classmate:jar:1.7.0:runtime (version managed from 1.5.1) [INFO] | | +- net.bytebuddy:byte-buddy:jar:1.14.19:runtime (version managed from 1.14.15; scope not updated to runtime) [INFO] | | +- (jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.2:runtime - version managed from 4.0.0; omitted for duplicate) [INFO] | | +- org.glassfish.jaxb:jaxb-runtime:jar:4.0.5:runtime (version managed from 4.0.2) [INFO] | | | \- org.glassfish.jaxb:jaxb-core:jar:4.0.5:runtime (version managed from 4.0.5) [INFO] | | | +- (jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.2:runtime - version managed from 4.0.2; omitted for duplicate) [INFO] | | | +- (jakarta.activation:jakarta.activation-api:jar:2.1.3:runtime - version managed from 2.1.3; omitted for duplicate) [INFO] | | | +- org.eclipse.angus:angus-activation:jar:2.0.2:runtime (version managed from 2.0.2) [INFO] | | | | \- (jakarta.activation:jakarta.activation-api:jar:2.1.3:runtime - version managed from 2.1.3; omitted for duplicate) [INFO] | | | +- org.glassfish.jaxb:txw2:jar:4.0.5:runtime (version managed from 4.0.5) [INFO] | | | \- com.sun.istack:istack-commons-runtime:jar:4.1.2:runtime (version managed from 4.1.2) [INFO] | | +- jakarta.inject:jakarta.inject-api:jar:2.0.1:runtime (version managed from 2.0.1) [INFO] | | \- org.antlr:antlr4-runtime:jar:4.13.0:compile [INFO] | +- org.springframework.data:spring-data-jpa:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | +- org.springframework.data:spring-data-commons:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.2; omitted for duplicate) [INFO] | | +- org.springframework:spring-orm:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-jdbc:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | \- (org.springframework:spring-tx:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- org.springframework:spring-context:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | | | +- (org.springframework:spring-aop:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-expression:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | \- (io.micrometer:micrometer-observation:jar:1.13.3:compile - version managed from 1.12.9; omitted for duplicate) [INFO] | | +- (org.springframework:spring-aop:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- org.springframework:spring-tx:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | \- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- org.springframework:spring-beans:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | | | \- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- (org.antlr:antlr4-runtime:jar:4.13.0:compile - omitted for duplicate) [INFO] | | +- (jakarta.annotation:jakarta.annotation-api:jar:2.1.1:compile - version managed from 2.0.0; omitted for duplicate) [INFO] | | \- org.slf4j:slf4j-api:jar:2.0.16:compile (version managed from 2.0.2) [INFO] | \- org.springframework:spring-aspects:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | \- (org.aspectj:aspectjweaver:jar:1.9.22.1:compile - version managed from 1.9.22.1; omitted for duplicate) [INFO] +- org.springframework.boot:spring-boot-starter-data-rest:jar:3.3.3:compile [INFO] | +- (org.springframework.boot:spring-boot-starter-web:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | \- org.springframework.data:spring-data-rest-webmvc:jar:4.3.3:compile (version managed from 4.3.3) [INFO] | +- org.springframework.data:spring-data-rest-core:jar:4.3.3:compile (version managed from 4.3.3) [INFO] | | +- (org.springframework:spring-tx:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- org.springframework.hateoas:spring-hateoas:jar:2.3.2:compile (version managed from 2.3.2) [INFO] | | | +- (org.springframework:spring-aop:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-context:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-web:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | | +- (org.springframework.plugin:spring-plugin-core:jar:3.0.0:compile - omitted for duplicate) [INFO] | | | +- (com.jayway.jsonpath:json-path:jar:2.9.0:compile - version managed from 2.9.0; omitted for duplicate) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.16; omitted for duplicate) [INFO] | | +- (org.springframework.data:spring-data-commons:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- org.springframework.plugin:spring-plugin-core:jar:3.0.0:compile [INFO] | | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.0.0; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-context:jar:6.1.12:compile - version managed from 6.0.0; omitted for duplicate) [INFO] | | | +- (org.springframework:spring-aop:jar:6.1.12:compile - version managed from 6.0.0; omitted for duplicate) [INFO] | | | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.3; omitted for duplicate) [INFO] | | +- org.atteo:evo-inflector:jar:1.3:compile [INFO] | | +- (com.fasterxml.jackson.core:jackson-annotations:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.datatype:jackson-datatype-jdk8:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.2; omitted for duplicate) [INFO] | +- (org.springframework:spring-webmvc:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | +- (com.fasterxml.jackson.core:jackson-databind:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | +- com.fasterxml.jackson.core:jackson-annotations:jar:2.17.2:compile (version managed from 2.17.2) [INFO] | \- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.2; omitted for duplicate) [INFO] +- org.springframework.boot:spring-boot-starter-web:jar:3.3.3:compile [INFO] | +- (org.springframework.boot:spring-boot-starter:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | +- org.springframework.boot:spring-boot-starter-json:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | +- (org.springframework.boot:spring-boot-starter:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- (org.springframework:spring-web:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.core:jackson-databind:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | +- com.fasterxml.jackson.datatype:jackson-datatype-jdk8:jar:2.17.2:compile (version managed from 2.17.2) [INFO] | | | +- (com.fasterxml.jackson.core:jackson-core:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | | \- (com.fasterxml.jackson.core:jackson-databind:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.datatype:jackson-datatype-jsr310:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | \- com.fasterxml.jackson.module:jackson-module-parameter-names:jar:2.17.2:compile (version managed from 2.17.2) [INFO] | | +- (com.fasterxml.jackson.core:jackson-core:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | \- (com.fasterxml.jackson.core:jackson-databind:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | +- org.springframework.boot:spring-boot-starter-tomcat:jar:3.3.3:compile (version managed from 3.3.3) [INFO] | | +- (jakarta.annotation:jakarta.annotation-api:jar:2.1.1:compile - version managed from 2.1.1; omitted for duplicate) [INFO] | | +- org.apache.tomcat.embed:tomcat-embed-core:jar:10.1.28:compile (version managed from 10.1.28) [INFO] | | +- org.apache.tomcat.embed:tomcat-embed-el:jar:10.1.28:compile (version managed from 10.1.28) [INFO] | | \- org.apache.tomcat.embed:tomcat-embed-websocket:jar:10.1.28:compile (version managed from 10.1.28) [INFO] | | \- (org.apache.tomcat.embed:tomcat-embed-core:jar:10.1.28:compile - version managed from 10.1.28; omitted for duplicate) [INFO] | +- org.springframework:spring-web:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | \- (io.micrometer:micrometer-observation:jar:1.13.3:compile - version managed from 1.12.9; omitted for duplicate) [INFO] | \- org.springframework:spring-webmvc:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | +- (org.springframework:spring-aop:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | +- (org.springframework:spring-beans:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | +- (org.springframework:spring-context:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | +- org.springframework:spring-expression:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | | \- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | \- (org.springframework:spring-web:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] +- org.springframework.boot:spring-boot-devtools:jar:3.3.3:runtime [INFO] | +- org.springframework.boot:spring-boot:jar:3.3.3:compile (version managed from 3.3.3; scope not updated to compile) [INFO] | | +- (org.springframework:spring-core:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | | \- (org.springframework:spring-context:jar:6.1.12:compile - version managed from 6.1.12; omitted for duplicate) [INFO] | \- org.springframework.boot:spring-boot-autoconfigure:jar:3.3.3:compile (version managed from 3.3.3; scope not updated to compile) [INFO] | \- (org.springframework.boot:spring-boot:jar:3.3.3:compile - version managed from 3.3.3; omitted for duplicate) [INFO] +- org.postgresql:postgresql:jar:42.7.3:runtime [INFO] | \- org.checkerframework:checker-qual:jar:3.42.0:runtime [INFO] +- org.springframework.boot:spring-boot-configuration-processor:jar:3.3.3:compile [INFO] +- org.projectlombok:lombok:jar:1.18.34:compile [INFO] +- org.springframework.boot:spring-boot-starter-test:jar:3.3.3:test [INFO] | +- (org.springframework.boot:spring-boot-starter:jar:3.3.3:test - version managed from 3.3.3; omitted for duplicate) [INFO] | +- org.springframework.boot:spring-boot-test:jar:3.3.3:test (version managed from 3.3.3) [INFO] | | +- (org.springframework.boot:spring-boot:jar:3.3.3:test - version managed from 3.3.3; omitted for duplicate) [INFO] | | \- (org.springframework:spring-test:jar:6.1.12:test - version managed from 6.1.12; omitted for duplicate) [INFO] | +- org.springframework.boot:spring-boot-test-autoconfigure:jar:3.3.3:test (version managed from 3.3.3) [INFO] | | +- (org.springframework.boot:spring-boot:jar:3.3.3:test - version managed from 3.3.3; omitted for duplicate) [INFO] | | +- (org.springframework.boot:spring-boot-test:jar:3.3.3:test - version managed from 3.3.3; omitted for duplicate) [INFO] | | \- (org.springframework.boot:spring-boot-autoconfigure:jar:3.3.3:test - version managed from 3.3.3; omitted for duplicate) [INFO] | +- com.jayway.jsonpath:json-path:jar:2.9.0:compile (version managed from 2.9.0) [INFO] | | +- (net.minidev:json-smart:jar:2.5.1:runtime - version managed from 2.5.0; omitted for duplicate) [INFO] | | \- (org.slf4j:slf4j-api:jar:2.0.16:runtime - version managed from 2.0.11; omitted for duplicate) [INFO] | +- jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.2:compile (version managed from 4.0.2) [INFO] | | \- jakarta.activation:jakarta.activation-api:jar:2.1.3:compile (version managed from 2.1.3) [INFO] | +- net.minidev:json-smart:jar:2.5.1:runtime (version managed from 2.5.1; scope not updated to runtime) [INFO] | | \- net.minidev:accessors-smart:jar:2.5.1:runtime [INFO] | | \- org.ow2.asm:asm:jar:9.6:runtime [INFO] | +- org.assertj:assertj-core:jar:3.25.3:test (version managed from 3.25.3) [INFO] | | \- (net.bytebuddy:byte-buddy:jar:1.14.19:test - version managed from 1.14.11; omitted for duplicate) [INFO] | +- org.awaitility:awaitility:jar:4.2.2:test (version managed from 4.2.2) [INFO] | | \- (org.hamcrest:hamcrest:jar:2.2:test - version managed from 2.1; omitted for duplicate) [INFO] | +- org.hamcrest:hamcrest:jar:2.2:test (version managed from 2.2) [INFO] | +- org.junit.jupiter:junit-jupiter:jar:5.10.3:test (version managed from 5.10.3) [INFO] | | +- org.junit.jupiter:junit-jupiter-api:jar:5.10.3:test (version managed from 5.10.3) [INFO] | | | +- org.opentest4j:opentest4j:jar:1.3.0:test [INFO] | | | +- org.junit.platform:junit-platform-commons:jar:1.10.3:test (version managed from 1.10.3) [INFO] | | | | \- (org.apiguardian:apiguardian-api:jar:1.1.2:test - omitted for duplicate) [INFO] | | | \- org.apiguardian:apiguardian-api:jar:1.1.2:test [INFO] | | +- org.junit.jupiter:junit-jupiter-params:jar:5.10.3:test (version managed from 5.10.3) [INFO] | | | +- (org.junit.jupiter:junit-jupiter-api:jar:5.10.3:test - version managed from 5.10.3; omitted for duplicate) [INFO] | | | \- (org.apiguardian:apiguardian-api:jar:1.1.2:test - omitted for duplicate) [INFO] | | \- org.junit.jupiter:junit-jupiter-engine:jar:5.10.3:test (version managed from 5.10.3) [INFO] | | +- org.junit.platform:junit-platform-engine:jar:1.10.3:test (version managed from 1.10.3) [INFO] | | | +- (org.opentest4j:opentest4j:jar:1.3.0:test - omitted for duplicate) [INFO] | | | +- (org.junit.platform:junit-platform-commons:jar:1.10.3:test - version managed from 1.10.3; omitted for duplicate) [INFO] | | | \- (org.apiguardian:apiguardian-api:jar:1.1.2:test - omitted for duplicate) [INFO] | | +- (org.junit.jupiter:junit-jupiter-api:jar:5.10.3:test - version managed from 5.10.3; omitted for duplicate) [INFO] | | \- (org.apiguardian:apiguardian-api:jar:1.1.2:test - omitted for duplicate) [INFO] | +- org.mockito:mockito-core:jar:5.11.0:test (version managed from 5.11.0) [INFO] | | +- (net.bytebuddy:byte-buddy:jar:1.14.19:test - version managed from 1.14.12; omitted for duplicate) [INFO] | | +- net.bytebuddy:byte-buddy-agent:jar:1.14.19:test (version managed from 1.14.12) [INFO] | | \- org.objenesis:objenesis:jar:3.3:test [INFO] | +- org.mockito:mockito-junit-jupiter:jar:5.11.0:test (version managed from 5.11.0) [INFO] | | +- (org.mockito:mockito-core:jar:5.11.0:test - version managed from 5.11.0; omitted for duplicate) [INFO] | | \- (org.junit.jupiter:junit-jupiter-api:jar:5.10.3:test - version managed from 5.10.2; omitted for duplicate) [INFO] | +- org.skyscreamer:jsonassert:jar:1.5.3:test (version managed from 1.5.3) [INFO] | | \- com.vaadin.external.google:android-json:jar:0.0.20131108.vaadin1:test [INFO] | +- org.springframework:spring-core:jar:6.1.12:compile (version managed from 6.1.12; scope not updated to compile) [INFO] | | \- org.springframework:spring-jcl:jar:6.1.12:compile (version managed from 6.1.12) [INFO] | +- org.springframework:spring-test:jar:6.1.12:test (version managed from 6.1.12) [INFO] | | \- (org.springframework:spring-core:jar:6.1.12:test - version managed from 6.1.12; omitted for duplicate) [INFO] | \- org.xmlunit:xmlunit-core:jar:2.9.1:test (version managed from 2.9.1) [INFO] | \- (jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.2:test - version managed from 2.3.3; omitted for duplicate) [INFO] +- com.github.starnowski.posjsonhelper:hibernate6:jar:0.4.1:compile [INFO] | +- com.github.starnowski.posjsonhelper:json-core:jar:0.4.1:compile [INFO] | | \- com.github.starnowski.posjsonhelper:core:jar:0.4.1:compile [INFO] | | \- org.reflections:reflections:jar:0.9.12:compile [INFO] | | \- org.javassist:javassist:jar:3.26.0-GA:compile [INFO] | \- com.github.starnowski.posjsonhelper:hibernate6-core:jar:0.4.1:compile [INFO] | \- (com.github.starnowski.posjsonhelper:core:jar:0.4.1:compile - omitted for duplicate) [INFO] \- org.springdoc:springdoc-openapi-starter-webmvc-ui:jar:2.6.0:compile [INFO] +- org.springdoc:springdoc-openapi-starter-webmvc-api:jar:2.6.0:compile [INFO] | +- org.springdoc:springdoc-openapi-starter-common:jar:2.6.0:compile [INFO] | | +- (org.springframework.boot:spring-boot-autoconfigure:jar:3.3.3:compile - version managed from 3.3.0; omitted for duplicate) [INFO] | | \- io.swagger.core.v3:swagger-core-jakarta:jar:2.2.22:compile [INFO] | | +- org.apache.commons:commons-lang3:jar:3.14.0:compile (version managed from 3.14.0) [INFO] | | +- (org.slf4j:slf4j-api:jar:2.0.16:compile - version managed from 2.0.9; omitted for duplicate) [INFO] | | +- io.swagger.core.v3:swagger-annotations-jakarta:jar:2.2.22:compile [INFO] | | +- io.swagger.core.v3:swagger-models-jakarta:jar:2.2.22:compile [INFO] | | | \- (com.fasterxml.jackson.core:jackson-annotations:jar:2.17.2:compile - version managed from 2.16.2; omitted for duplicate) [INFO] | | +- (org.yaml:snakeyaml:jar:2.2:compile - version managed from 2.2; omitted for duplicate) [INFO] | | +- (jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.2:compile - version managed from 3.0.1; omitted for duplicate) [INFO] | | +- jakarta.validation:jakarta.validation-api:jar:3.0.2:compile (version managed from 3.0.2) [INFO] | | +- (com.fasterxml.jackson.core:jackson-annotations:jar:2.17.2:compile - version managed from 2.16.2; omitted for duplicate) [INFO] | | +- (com.fasterxml.jackson.core:jackson-databind:jar:2.17.2:compile - version managed from 2.16.2; omitted for duplicate) [INFO] | | +- com.fasterxml.jackson.dataformat:jackson-dataformat-yaml:jar:2.17.2:compile (version managed from 2.16.2) [INFO] | | | +- (com.fasterxml.jackson.core:jackson-databind:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | | +- (org.yaml:snakeyaml:jar:2.2:compile - version managed from 2.2; omitted for duplicate) [INFO] | | | \- (com.fasterxml.jackson.core:jackson-core:jar:2.17.2:compile - version managed from 2.17.2; omitted for duplicate) [INFO] | | \- (com.fasterxml.jackson.datatype:jackson-datatype-jsr310:jar:2.17.2:compile - version managed from 2.16.2; omitted for duplicate) [INFO] | \- (org.springframework:spring-webmvc:jar:6.1.12:compile - version managed from 6.1.8; omitted for duplicate) [INFO] \- org.webjars:swagger-ui:jar:5.17.14:compile

sbodese commented 2 months ago

here some code snippets:

`@Embeddable public class JsonbContent implements Serializable{

private Integer integer_value;
private Double double_value;
@Enumerated(EnumType.STRING)
private UserTypeEnum enum_value;
private String string_value;

public Integer getInteger_value() {
    return integer_value;
}

public JsonbContent setInteger_value(Integer integer_value) {
    this.integer_value = integer_value;
    return this;
}`

` @Repository public class JSONDao implements IJSONDao {

@Autowired
private EntityManager entityManager;
@Autowired
private HibernateContext hibernateContext;
@Override
public List<Item> findAllByStringValueAndLikeOperator(String expression) {

    expression = "%"+expression +"%";
    CriteriaBuilder cb = entityManager.getCriteriaBuilder();
    CriteriaQuery<Item> query = cb.createQuery(Item.class);
    Root<Item> root = query.from(Item.class);
    query.select(root);
    query.where(cb.like(new JsonBExtractPathText(root.get("jsonbContent"), singletonList("string_value"), (NodeBuilder) cb), expression));
    return entityManager.createQuery(query).getResultList();
}

/**
 * "?|" Wrapper
 */
@Override
public List<Item> findAllByAllMatchingTags(String[] tags) {
    CriteriaBuilder cb = entityManager.getCriteriaBuilder();
    CriteriaQuery<Item> query = cb.createQuery(Item.class);
    Root<Item> root = query.from(Item.class);
    query.select(root);
    query.where(new JsonbAnyArrayStringsExistPredicate(hibernateContext, (NodeBuilder) cb,
            new JsonBExtractPath(root.get("jsonbContent"), (NodeBuilder) cb, singletonList("top_element_with_set_of_values")),
            tags));
    return entityManager.createQuery(query).getResultList();
}

}`

sbodese commented 2 months ago

Hi Szymon, well, could you reproduce this issue? Greetings Steffen

starnowski commented 2 months ago

Hi Szymon, well, could you reproduce this issue? Greetings Steffen

No yet, I used your pom.xml and didn't get same error. Btw. could you try to add the dependency below to your pom.xml and check if this will solve your problem? 

<dependency>
    <groupId>org.hibernate.orm</groupId>
            <artifactId>hibernate-core</artifactId>
    <version>6.5.2.Final</version>
</dependency>
starnowski commented 2 months ago

Hi Steffen,

Have you tried to add this transitive dependency to your project with Spring Boot 3.3.3?

Regards, Szymon

sbodese commented 1 month ago

Hi Szymon,

it seems "better", but i got no data. But if i use a exact "TAG22" with "findAllByAllMatchingTags" i got this exception. Currently i got no data, no functionality.

i attach the source code of this showcase project

image

java.lang.IllegalArgumentException: Could not find selectable [top_element_with_set_of_values] in embeddable type [....jsonbshowcase.entities.JsonbContent] for JSON processing. at org.hibernate.dialect.JsonHelper.getSelectableMapping(JsonHelper.java:734) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.dialect.JsonHelper.fromString(JsonHelper.java:290) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.dialect.JsonHelper.fromString(JsonHelper.java:238) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.type.descriptor.jdbc.JsonJdbcType.fromString(JsonJdbcType.java:79) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.dialect.AbstractPostgreSQLJsonPGObjectType.access$200(AbstractPostgreSQLJsonPGObjectType.java:29) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.dialect.AbstractPostgreSQLJsonPGObjectType$2.getObject(AbstractPostgreSQLJsonPGObjectType.java:98) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.dialect.AbstractPostgreSQLJsonPGObjectType$2.doExtract(AbstractPostgreSQLJsonPGObjectType.java:80) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.type.descriptor.jdbc.BasicExtractor.extract(BasicExtractor.java:44) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.getCurrentRowValue(JdbcValuesResultSetImpl.java:379) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.getJdbcValue(RowProcessingStateStandardImpl.java:120) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.graph.embeddable.internal.AggregateEmbeddableInitializer.getJdbcValues(AggregateEmbeddableInitializer.java:21) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.graph.embeddable.internal.NestedRowProcessingState.getJdbcValue(NestedRowProcessingState.java:52) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.graph.basic.BasicResultAssembler.extractRawValue(BasicResultAssembler.java:52) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.graph.basic.BasicResultAssembler.assemble(BasicResultAssembler.java:59) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.graph.embeddable.AbstractEmbeddableInitializer.extractRowState(AbstractEmbeddableInitializer.java:304) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.graph.embeddable.AbstractEmbeddableInitializer.initializeInstance(AbstractEmbeddableInitializer.java:198) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.internal.InitializersList.initializeInstance(InitializersList.java:73) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.internal.StandardRowReader.coordinateInitializers(StandardRowReader.java:113) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.internal.StandardRowReader.readRow(StandardRowReader.java:87) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:205) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:211) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:83) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:76) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:65) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$2(ConcreteSqmSelectQueryPlan.java:139) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:382) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:302) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:526) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:423) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at org.hibernate.query.Query.getResultList(Query.java:120) ~[hibernate-core-6.5.2.Final.jar:6.5.2.Final] at ....jsonbshowcase.service.JSONDao.findAllByAllMatchingTags(JSONDao.java:52) ~[classes/:na]

jsonbshowcase.zip

starnowski commented 1 month ago

Hi @sbodese ,

I don't have much time this week right now so I might not have time to check your complete code, but Umm, I don't need to check your project to know what might be the issue (I mean, you already posted the code part that caused this error).

So, the annotation Embeddable added to the JsonbContent type causes you to have a Postgres type (or record, I don't remember what it is called right now) with all the properties that you specified in your Java. Now, the logic could suggest just adding a collection of the set property with the name top_element_with_set_of_values.

You can try, but for early versions of Hibernate 6 you will get the following error:

The type that is supposed to be serialized as JSON can not have complex types as its properties: "Aggregate components currently may only contain simple basic values and components of simple basic values."

Maybe Hibernate 6 has already support for complex properties and I'll check it later but I don'k know right now.

But just like in this case: https://github.com/starnowski/posjsonhelper/blob/master/hibernate6-tests/hibernate6-tests-native-support-1/src/main/java/com/github/starnowski/posjsonhelper/hibernate6/demo/model/JsonbContent.java

I don't have complex properties.

You can try other approach like here:

https://github.com/starnowski/posjsonhelper/blob/ea8331eff6926548242428f529af4e4d84ae477f/hibernate6-tests/hibernate6-tests-native-support/src/main/java/com/github/starnowski/posjsonhelper/hibernate6/demo/model/Item.java#L24

You would have to add this dependency to your project:

        <dependency>
            <groupId>io.hypersistence</groupId>
            <artifactId>hypersistence-utils-hibernate-63</artifactId>
            <version>3.7.0</version>
        </dependency>

However, if I remember correctly, without Embeddable, you might not have Hibernate native support for JSON, which was added in version 6. But remember that in the context of query and JSON modification, posjsonhelper gives you more features. So this will be your choice.

starnowski commented 1 month ago

Hi @sbodese ,

Any thoughts about what I wrote?

starnowski commented 1 month ago

Hi @sbodese ,

Any update on this issue from your site?

I'll try to add a test for the latest Hibernate6 version to monitor if any non-backward-compatible changes are added in the newest version. The Github Action will be scheduled per month. I'll also add more descriptions in README.md about maven dependencies (the Hibernate6 maven dependency will stay as an optional dependency). But besides that, I don't think that there are any code changes required with this issue.

https://docs.github.com/en/actions/writing-workflows/choosing-when-your-workflow-runs/events-that-trigger-workflows#schedule https://github.com/marketplace/actions/schedule-job-action