Suppose I had two entities like this:

I am creating the backend for a boardgame in Spring Boot. This boardgame can have 1 to n players that each get a color. Player is an entity, just as Game. Color is an enum. It seemed to me a good idea to store the players of a game in a Map<Color, Player>. This allows me to dynamically store the players with the color as key and gives me cleaner code.
However, if I use the following code:

According to JPA 2.2 Support for Java 8 Date/Time Types JPA supports LocalDate.

I am trying to make dynamic query builder for my filters. I am using Specification patter to achive that. I created my class which has methods to add next filters. There’s a part of this class:

I’m having quite a bit of trouble with the way a repository query method is fetching results–it is returning an additional duplicated record from one of the OneToMany relationships for each item returned by an unrelated ManyToMany relationship. It appears it’s caused by Hibernate using LEFT JOINs in the generated query but I’m unsure how to fix the issue.

I have an entity named Track associated with my Source Entity. If there is data in my Track Entity and it is associated with Source, I cannot use findById or findAll queries in the Source Repository and I get an error as follows

When I try to get user object from database empty collection is returned only if collection of observed is type of Set.

I am asked to run a spring boot application inside a java web application that doesn’t use a dependency management tool so i am running my spring-boot-app without an embedded tomcat the issue was when i tried to use hibernate 5 it seems that the project is dependant on hibernate 3 such as org/hibernate/jdbc/JDBCContext
I need a way to use both hibernate versions since it is not possible to refactor the old code due to security issues in the company

i have two entites

“C:Program FilesJavajdk-21binjava.exe” -XX:TieredStopAtLevel=1 -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true “-Dmanagement.endpoints.jmx.exposure.include=*” “-javaagent:C:Program FilesJetBrainsIntelliJ IDEA 2024.1libidea_rt.jar=55806:C:Program FilesJetBrainsIntelliJ IDEA 2024.1bin” -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath C:UsersvanshDocumentsapitargetclasses;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-starter-data-jpa3.2.5spring-boot-starter-data-jpa-3.2.5.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-starter-aop3.2.5spring-boot-starter-aop-3.2.5.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-aop6.1.6spring-aop-6.1.6.jar;C:Usersvansh.m2repositoryorgaspectjaspectjweaver1.9.22aspectjweaver-1.9.22.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-starter-jdbc3.2.5spring-boot-starter-jdbc-3.2.5.jar;C:Usersvansh.m2repositorycomzaxxerHikariCP5.0.1HikariCP-5.0.1.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-jdbc6.1.6spring-jdbc-6.1.6.jar;C:Usersvansh.m2repositoryorghibernateormhibernate-core6.4.4.Finalhibernate-core-6.4.4.Final.jar;C:Usersvansh.m2repositoryjakartapersistencejakarta.persistence-api3.1.0jakarta.persistence-api-3.1.0.jar;C:Usersvansh.m2repositoryjakartatransactionjakarta.transaction-api2.0.1jakarta.transaction-api-2.0.1.jar;C:Usersvansh.m2repositoryorgjbossloggingjboss-logging3.5.3.Finaljboss-logging-3.5.3.Final.jar;C:Usersvansh.m2repositoryorghibernatecommonhibernate-commons-annotations6.0.6.Finalhibernate-commons-annotations-6.0.6.Final.jar;C:Usersvansh.m2repositoryiosmallryejandex3.1.2jandex-3.1.2.jar;C:Usersvansh.m2repositorycomfasterxmlclassmate1.6.0classmate-1.6.0.jar;C:Usersvansh.m2repositorynetbytebuddybyte-buddy1.14.13byte-buddy-1.14.13.jar;C:Usersvansh.m2repositoryorgglassfishjaxbjaxb-runtime4.0.5jaxb-runtime-4.0.5.jar;C:Usersvansh.m2repositoryorgglassfishjaxbjaxb-core4.0.5jaxb-core-4.0.5.jar;C:Usersvansh.m2repositoryorgeclipseangusangus-activation2.0.2angus-activation-2.0.2.jar;C:Usersvansh.m2repositoryorgglassfishjaxbtxw24.0.5txw2-4.0.5.jar;C:Usersvansh.m2repositorycomsunistackistack-commons-runtime4.1.2istack-commons-runtime-4.1.2.jar;C:Usersvansh.m2repositoryjakartainjectjakarta.inject-api2.0.1jakarta.inject-api-2.0.1.jar;C:Usersvansh.m2repositoryorgantlrantlr4-runtime4.13.0antlr4-runtime-4.13.0.jar;C:Usersvansh.m2repositoryorgspringframeworkdataspring-data-jpa3.2.5spring-data-jpa-3.2.5.jar;C:Usersvansh.m2repositoryorgspringframeworkdataspring-data-commons3.2.5spring-data-commons-3.2.5.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-orm6.1.6spring-orm-6.1.6.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-context6.1.6spring-context-6.1.6.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-tx6.1.6spring-tx-6.1.6.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-beans6.1.6spring-beans-6.1.6.jar;C:Usersvansh.m2repositoryjakartaannotationjakarta.annotation-api2.1.1jakarta.annotation-api-2.1.1.jar;C:Usersvansh.m2repositoryorgslf4jslf4j-api2.0.13slf4j-api-2.0.13.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-aspects6.1.6spring-aspects-6.1.6.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-starter-web3.2.5spring-boot-starter-web-3.2.5.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-starter3.2.5spring-boot-starter-3.2.5.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot3.2.5spring-boot-3.2.5.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-autoconfigure3.2.5spring-boot-autoconfigure-3.2.5.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-starter-logging3.2.5spring-boot-starter-logging-3.2.5.jar;C:Usersvansh.m2repositorychqoslogbacklogback-classic1.4.14logback-classic-1.4.14.jar;C:Usersvansh.m2repositorychqoslogbacklogback-core1.4.14logback-core-1.4.14.jar;C:Usersvansh.m2repositoryorgapachelogginglog4jlog4j-to-slf4j2.21.1log4j-to-slf4j-2.21.1.jar;C:Usersvansh.m2repositoryorgapachelogginglog4jlog4j-api2.21.1log4j-api-2.21.1.jar;C:Usersvansh.m2repositoryorgslf4jjul-to-slf4j2.0.13jul-to-slf4j-2.0.13.jar;C:Usersvansh.m2repositoryorgyamlsnakeyaml2.2snakeyaml-2.2.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-starter-json3.2.5spring-boot-starter-json-3.2.5.jar;C:Usersvansh.m2repositorycomfasterxmljacksoncorejackson-databind2.15.4jackson-databind-2.15.4.jar;C:Usersvansh.m2repositorycomfasterxmljacksoncorejackson-annotations2.15.4jackson-annotations-2.15.4.jar;C:Usersvansh.m2repositorycomfasterxmljacksoncorejackson-core2.15.4jackson-core-2.15.4.jar;C:Usersvansh.m2repositorycomfasterxmljacksondatatypejackson-datatype-jdk82.15.4jackson-datatype-jdk8-2.15.4.jar;C:Usersvansh.m2repositorycomfasterxmljacksondatatypejackson-datatype-jsr3102.15.4jackson-datatype-jsr310-2.15.4.jar;C:Usersvansh.m2repositorycomfasterxmljacksonmodulejackson-module-parameter-names2.15.4jackson-module-parameter-names-2.15.4.jar;C:Usersvansh.m2repositoryorgspringframeworkbootspring-boot-starter-tomcat3.2.5spring-boot-starter-tomcat-3.2.5.jar;C:Usersvansh.m2repositoryorgapachetomcatembedtomcat-embed-core10.1.20tomcat-embed-core-10.1.20.jar;C:Usersvansh.m2repositoryorgapachetomcatembedtomcat-embed-el10.1.20tomcat-embed-el-10.1.20.jar;C:Usersvansh.m2repositoryorgapachetomcatembedtomcat-embed-websocket10.1.20tomcat-embed-websocket-10.1.20.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-web6.1.6spring-web-6.1.6.jar;C:Usersvansh.m2repositoryiomicrometermicrometer-observation1.12.5micrometer-observation-1.12.5.jar;C:Usersvansh.m2repositoryiomicrometermicrometer-commons1.12.5micrometer-commons-1.12.5.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-webmvc6.1.6spring-webmvc-6.1.6.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-expression6.1.6spring-expression-6.1.6.jar;C:Usersvansh.m2repositoryorgpostgresqlpostgresql42.6.2postgresql-42.6.2.jar;C:Usersvansh.m2repositoryorgcheckerframeworkchecker-qual3.31.0checker-qual-3.31.0.jar;C:Usersvansh.m2repositoryjakartaxmlbindjakarta.xml.bind-api4.0.2jakarta.xml.bind-api-4.0.2.jar;C:Usersvansh.m2repositoryjakartaactivationjakarta.activation-api2.1.3jakarta.activation-api-2.1.3.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-core6.1.6spring-core-6.1.6.jar;C:Usersvansh.m2repositoryorgspringframeworkspring-jcl6.1.6spring-jcl-6.1.6.jar;C:Usersvansh.m2repositoryjavaxpersistencejavax.persistence-api2.2javax.persistence-api-2.2.jar in.alme.api.ApiApplication