I have an entity called packet, I want to update an attribute in all instances of that entity. The attribute I want to update is the price of the packet by a gi
I encountered handful of guides to creating spring data jpa projects and people configured persistence layer using properties file and javaconfig both. If we on
I encountered handful of guides to creating spring data jpa projects and people configured persistence layer using properties file and javaconfig both. If we on
I'm trying to get a list of transactions from database and this is the error I'm facing. "trace": "org.springframework.core.convert.ConversionFailedException:
When I passing parameters a1 as "a1", a2 as ["a21","a22"] @Query(value = "select * from a where if(:a1 !='', a1=:a1,1=1)" + "and if(:a2 !='',a2 in (
I want to delete all the product logs of a specific product depending on its product_id(FK). I created product logs to monitor when the product it's created and
I am trying to learn Hibernate to create on startup the Db from entities, but I have only found articles suggesting how to implement many to many relationship w
I need to get all the information about the ticket in one request, also the name, author, and year of the book. I have implemented this : I create interface Tic
I have two classes, a file and an attachment. There is a version attribute on the file and it has a onetomany relationship. I have written code to upload/add at
I'm trying to build a select query with Spring Data Specification. The query in question is the following: SELECT * FROM product WHERE id IN (SELECT product_id
I have a base entity not intended to be audited: @Data @MappedSuperclass @EqualsAndHashCode(of = {"id"}) public abstract class BaseEntity implements Serializabl
I have a problem, I have a question entity and an option entity, the relationship is one to many. but when I want to add the options in the question, it shows m
My objective is to make sure that a client can't access (retrieve) directly an entity through the Spring Data REST auto-exposed APIs, but rather only to the vie
I currently have multi tennancy database working by implmenting AbstractDataSourceBasedMultiTenantConnectionProviderImpl. This is working great thankfully. Now
In a spring boot application, I have this entity @Data @NoArgsConstructor @AllArgsConstructor @Entity public class User { @Id @GeneratedValue(generator="user_id
I have a spring boot application with mariaDB, after updating the connector ("org.mariadb.jdbc:mariadb-java-client") from version 2.7.5 to 3.0.3 the datetimes (
I am having trouble getting an H2 In Memory database to populate. The idea here to have the BuildingCode which is unique as a primary key and id. I get the foll
I am aware that JPA works with the default isolation level set for the database , if no isolation level is explicitly specified using the @Transactional annotat
I search to know if a user have an active subscription @Query("select case when count(u) > 0 then true else false end from User u where u.id=:userId and cur
I am trying to execute a couple of queries on different threads. There are 2 top level queries each executing on different tables at runtime. For executing the