I have two JPA entities with a @ManyToMany relationship, for example Student and Course, something like that: Student Entity: @ManyToMany List<Course> courses; Course Entity: @ManyToMany List<Student> students; What is the best way/pattern to implement a Spring REST controller which returns…
I have a RESTful app. Here's a test method from it. It is intended to retrieve a page of QuestionCommentResponseDto objects in descending order @Test @Sql(executionPhase = BEFORE_TEST_METHOD, value = BASE_SCRIPT_PATH + "GetPageTest/before.sql") @Sql(executionPhase = AFTER_TEST_METHOD, value = BASE_SCRIPT_PATH +…
What do I need to do for the fk of the child table to be automatically filled? I'm using JPA, Spring Boot, MySql The JSON in Postman is sent successfully, but the Request attribute is not filled in and neither…
I would very much appreciate your advice on the JPA. We have a database (PostgreSQL engine), and for tables it happens that a column has its DEFAULT. The database is connected to a Java backend (with JPA and Hibernate). What…
I am working on a Spring Boot app using Jpa and postgresql. It is a booking app that will notify the parties for coming bookings. I will have 3 user types: Admin, Customer and Employee. enter image description here I…
I have three entity employee , info, and address , i want mapped employee entity with info and address entity by using onetoone mapping by using hibernate and jpa annotation. @Entity public class Employee { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private…
I need to create an index for a 'TEXT' column in a MySQL database. I can't do it using this annotation @Table(name = "table1", indexes = @Index(name = "ix_table1_column1", columnList = "column1")) as MySQL can only index the first N…
I have a database in mysql called newdb, inside that database there are 2 tables, Track and User. When I run my springboot application, it creates 2 new tables called track and user and the application uses those tables instead…
I'm using hibernate to interact with a Postgres database. The query I'm trying to make selects Products that have not been assigned to a Branch yet. There is a many-to-many relationship between Products and Branches via the branch_product table. I…
I'm trying to delete the records where jsonb have one or more keys. My Data- id jsonb_col 1 [{"unit": "sale", "group": ["spares"]}] 2 [{"unit": "sale"}] 3 [{"member": "j1"}] after deleting for key in (unit, group), my data should be like…