I have this table: @Entity @Table(name = "t_tropical", uniqueConstraints = @UniqueConstraint(columnNames = { "name", "sign", "isRetro", "house", "lang"})) @Getter @Setter @AllArgsConstructor @NoArgsConstructor @Builder @ToString public class Tropical { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String name; private String…
I have no idea why I see this error on my code. I was tryed almost everything but there is still error (This is not a part of problem description but i need to add some more text so i…
My spring batch application works fine with postgre version 'PostgreSQL 9.5.19'. I have to run this in a different environment with postgre version 'EnterpriseDB 9.5.0.5'. The following error comes. Is this a version problem? How to resolve this? Even though…
The question may seems stupid but I am stuck on executing that kind of query: UPDATE user SET productArr = ARRAY[ARRAY[2,2],ARRAY[3,2],ARRAY[1,3]] WHERE id = 1; within a @Query Spring Data. I defined my repository method like: @Modifying @Query(value = """…
When I am trying to access data from my MySQL DB codedecode using HTTP Get Method either on browser client or postman client there is empty curly braces in array [{}] is shown. But, I have data into my database.…
I have a dependency Table Sellars which is having the City ID only. But while showing the sellars I need to show the Sellar country, state. I have written the join query it is returning rest of the sellar details…
I'm using Spring Boot 3 to create basic REST APIs, and trying to get content from PostgreSQL and post there too. I looked up every documentation and tutorial but GET gives an Error 500 while POST gives an Error 400.…
I'm seeing something strange after upgrading my app to SpringBoot 3 from SpringBoot 2. The application relies on an existing database (MySQL) which doesn't use good practices. One of them is using Y N for booleans stored in a VARCHAR.…
I'am using jakarta and when I run the app the "Student" and "Teacher" tables didn't created and only the "User" table is created. What could be the problem ? User class import jakarta.persistence.*; import java.io.Serializable; @Entity public class User implements…
I am developing REST application using spring boot and I am trying to optimize the performance of the queries. I am currently using findById from the repositories which is causing performance issues. Code is given below: User Entity @AllArgsConstructor @NoArgsConstructor…