I am using Java, Spring and JPA and cannot get cascade deletion to work. I have a class Tenant that looks like this @Entity @Validated @Data @Builder @NoArgsConstructor @AllArgsConstructor @TenantConstraints public class Tenant { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator =…
I have a table named deposit, below dep_id deposit_amount comp_id 1 100 1 2 100 1 3 100 1 When I run the query below I get the next updated table which is not what I want : query =…
In Service When I use print the keys that output null but print the ids that is correct please tell me why I'm sure the database has data orderBean @EntityListeners(AuditingEntityListener.class) @Entity @Table(name = "`Order`") public class OrderBean { @Id @GeneratedValue(strategy…
Mysql giving bad performance while passing column value as bigint and column created with data type is varchar. Below is my create table query and index created on 3 columns(user_id,category,status). I am using spring jpa to interact with mysql and…
I have two table and I try to join use column idsubscriber but show some error. Class Subscriber: @Entity @Table(name = "subscriber") @XmlRootElement @NamedQueries({ @NamedQuery(name = "Subscriber.findAll", query = "SELECT s FROM Subscriber s") , @NamedQuery(name = "Subscriber.findById", query =…
I have a requirement where in, the controller class receives a list as a request param. This list can contain a range of values, which is salary column in the table. ex: {500-10000 , 10000-12000, 12000-14000..} using this range of…
I have the following table in my database: firstName lastName Kalinda Hemms Karolyn Greenwood Aaron Walework Michel Jurka Now I want to create a query with multiple strings that should return only the records with that string. For example, searching…
I read this stackoverflow post which says that we don't need to use @EnableJpaRepository or @EntityScan Spring data repository works without annotations I'm not sure what's wrong. But my Spring Boot application is only able to start with @EnableJpaRepository and…
I have an issue where only the first row from my database is being returned multiple times within a list even though the SQL query shows different rows being returning. my jpa query is: @Query(value = "SELECT BK.ISBN," + "BK.AUTHOR,…
I found similar questions about this error but I can't make it work I'm working on a java 8, spring 2.6.4 and a MySQL database I'm trying to do a DELETE native query using JPA and I'm getting this error:…