How can we get the count of OneToMany field of JPA entity as querying count for each parent entity while fetching as a list is costly and there is no way in JPA
I ran into an error with custom delete method in spring data jpa. Basically there's a bag which contains items, and when deleting the bag, all the items in it s
Grails GORM is able to autogenerate ORM findBy[fieldName] and related methods for each of the fields in the entity, I'm not sure what magic it uses to do this I
I have two entity classes: Taco @Data @Entity @Table(name="Taco") public class Taco { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE) @
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