I have a jpql as: @Query("SELECT b FROM Booking b WHERE " + "(:officeId is null OR b.officeId = :officeId) AND " + "(:status is null OR b.status = :status) AND " + "(:type is null OR b.officeType = :type)…
I am trying To make Addresses where Country has many states and And in States there are many districts and in districts there are many Municipality. My CountryDTO: package com.part.firstProject.dto; import com.fasterxml.jackson.annotation.JsonInclude; import lombok.*; import org.springframework.stereotype.Component; import java.util.List; @Data @Builder…
There are two tables: User table `user` +----+----------------------------+-------------+ | id | date_created_user | email | +----+----------------------------+-------------+ | 7 | 2023-02-23 13:23:09.085897 | [email protected] | | 16 | 2023-02-25 14:23:31.691560 | [email protected] | | 17 | 2023-02-25 14:24:02.089010 | [email protected] |…
Can you please help me? I have two entities: @Entity public class Site { @Id @GeneratedValue(strategy = GenerationType.AUTO) private Integer id; // getters, setters, etc.. } @Entity @Table(indexes = @Index(name = "path_index", columnList = "path")) public class Page { @Id…
I have created a stored procedure in Postgres CREATE OR REPLACE PROCEDURE reset_disabled() LANGUAGE plpgsql AS $$ DECLARE BEGIN UPDATE regional_price_info SET disabled = NULL; END; $$; I tried to call procedure from the repository class in two ways however…
I have a Model called CommunityProfile. This model contains two child relationships; player (type User), and rank (type Rank). The default spring boot JPA-generated query is taking approximately 9s to fetch 200 records, which is rather slow. By using the…
For some reasons my query is running perfectly in MySQL WorkBench but when added to the repository I am getting syntax error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version…
After upgrade to Spring Boot 3 I`ve got next problem; My entity @Data @Table(name = "campaign_status") @Entity public class CampaignStatus { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "campaign_status_id") private Long campaignStatusId; @Column(name = "name") private String name; } My jpa…
Using Spring Boot and JPA in Java, I am creating a vending machine simulator whereby there are 2 roles: "BUYER" and "SELLER". I have a table called users in a MySQL database that stores users along with their usernames, passwords…
So, I have 3 @Entity classes class Campaign { @Id private long campaignId; //Other fields @OneToMany(mappedBy = "campaign",cascade=CascadeType.ALL) private Set<Question> questions; } class Question { @Id private long questionId; //Other fields @OneToMany(mappedBy = "question",cascade=CascadeType.ALL) private Set<Choices> choices; @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name="CAMPAIGN_ID") private…