spring-data-jpa | Simplifies the development of creating a JPA-based data | Object-Relational Mapping library

I have configured Spring JPA to work with multiple data sources following this example. Spring JPA – Multiple Databases

It works as expected but since I want to use different data sources but with the same repositories there is an issue. When I try to use "Declarative Transaction Management" on my services and specify which transaction I am going to use the primary transaction or secondary one the transaction annotation is ignoring it. So in this case it is using the second one. However, both of the beans "PlatformTransactionManager" are created but when it comes to using in "@Transactional" I am not able to make the transaction work with the bean I have specified. So it seems that @Transactional is ignoring the bean name since they have the same repositories. Is there any way how can I use declarative transactions as I am trying to do it? As I have seen it can be done with Programmatic Transaction Management but it will cost me to change the whole code on my services since I have been using only declarative transactions.

I have seen various post describing that JPA EntityGraph allows to choose the graph at run time. And I am not entirely clear what this refers to.

Out of good faith and respect I would like to take this helpful article for reference: https://www.baeldung.com/jpa-entity-graph. (Most of JPA users might have gone through it already.)

The article quotes -

EntityGraph allows grouping the related persistence fields which we want to retrieve and lets us choose the graph type at runtime.

and again solidifies above statement in conclusion section.

In this article, we've explored using the JPA Entity Graph to dynamically fetch an Entity and its associations.

The decision is made at runtime in which we choose to load or not the related association.

As we see in the article (5.1) - EntityGraphs are defined as below using Annotations-
5.1. Defining an Entity Graph with Annotations

In my application config i have defined the following properties:

Calling mvn clean compile -X

shows the following (few dependencies omitted to stay in question max char size):

Problem when mapping an entity with a geometric field Geometry Point. When accessing the table repository, using the standard function findAll() getting "null" , although there are records in the database.When configuring, I used the official manual Hybernate Spatial. I get an error when requesting a controller: " exception is org.geolatte.geom.codec.WkbDecodeException: Expected geometryKeyword starting at position: 0] with root cause" Help me please , I do not know how to act and what is the reason

My config:

1. Hibernate (5.4.32.Final)
2. Hibernate Spatial (5.4.32.Final)
3. Posgis (version 2.5)
4. PostgreSQL 10.17

Entity:

I am trying to create a simple Spring project where restaurants can add menu items to shared database and users can use a html form to search the dishes based on a range of criteria- especially dietary requirements

Form example:

I'm doing a house rental application with Spring, React and MySQL. I have a class which is like a transaction. What I'm trying to do is to get all entries for the class sweetholiday_user_house, but I only want the fields start_rent_date and end_rent_date. The table is called sweet_holiday_user_house. For that I have created a SQL query in my repository:

When upgrading my app from Spring Boot 2.2 with JDK 11 to Spring Boot 2.5.5 with JDK 17, Mockito gives this error:

I am trying to use the RestResponse object from org.jboss.resteasy.reactive on the return of my application resources since the javax.ws.rs.core.Response doesn't provide the generic type.

I am getting the error when I call this endpoint: