I'm trying to change which database is used at runtime (like from H2 to MySQL and back). Is it also possible to make both of them be used simultaneously (meanin
When streaming result from JpaRepository to Rest API, I have an exception "java.sql.SQLException: Closed Resultset: next" I am Using Spring boot, Spring Data JP
Please let me know if this has been asked before. I have a requirement to do some advanced filtering on data that is stored in Redis cache. Imagine there are 2
See I dont want any mapping but what I want is just a simple thing that is.... I have two Entity Tasks(taskid,taskname.....,userId) User_Credentials(userId,pass
I'm practicing TDD, So now I'm trying to make a test that will fail for now. About to test a @Entity that don't have a field relationship mapped so far. So I'm
I am writing to-do list web app with spring boot. I Have 2 entities: User (fields: userid (ID), username, password Item (fields: serialnumber (ID), task, userid
I use mysql and spring 5, spring-data-jpa and spring-boot and JUnit5. This must be a common problem but I don't see te sollution. I have to test a repository wi
normal sql query which work correctly in db in sql developer passing values for bID and period. SELECT * FROM A WHERE abcID IN (SELECT abcID FROM B WHERE bID=1)
I want to store the last read time in a Date column when ever someone tries to load or fetch(select query, findBy methods) a entity I had a look at @PostLoad as
Can someone please guide me, how I can refresh the datasource whenever the password is rotated for the database. Basically I don't want any manual step to refre
CarMake.java @Getter @Setter @EqualsAndHashCode @NoArgsConstructor @Entity public class CarMake { @SequenceGenerator( name = "car_make_sequence"
Trying connect IBMi machine by using Spring Data & JPA, but it's generating the error: org.springframework.beans.factory.BeanCreationException: Error creati
I am using JPA with hibernate for mysql. I want to know whether jpa query methods will execute with or without transaction by default. I am not using transactio
We have a large code base using Hibernate and JPA with hand-made DAO Layer. Entites are mapped with JPA annotations (javax.persistence) and if needed, hibernate
I'm working with 2 tables: Person and City. I have a @ManyToOne relationship which worked fine. (many persons can belong to one city). Then I needed to create a
Two Spring boot (spring data jpa) Application A1 and Aplication A2 both read/write to a table named T1. T1 -> ID, data1, isDeleted columns My requirement is
I am using a spring boot application. I have multiple tables and using inner joins, I want to populate a temp table. Before populating, I have to truncate the t
I'm currently building server software in Java. I already have a running backend, which is build with Spring Boot. It has an REST interface to read and write da
UPDATE: I have tried implementing the SQLData interface for my Financial.class and PersonalInfo.class Java POJOs defined on my @NamedStoredProcedureQuery for th
someone could help me to solve this bug? i have update spring boot from 2.5.x to 2.6.3 and now the query like: @Query("select count(s.subjectId) from PreChe