I opened an old project I'm supposed to finish for a deadline very soon and my app can't run. I'm not sure why but I think it comes from two entities, my AccountInfo (which implements UserDetails) and the Roles entity.…
I have a springboot project and I use postgresql and hibernate. I have several entities, 2 of them are below: Company Entity: @Entity @Table @AllArgsConstructor @NoArgsConstructor @SuperBuilder @Getter @Setter public class Company extends BaseDatedEntity { ....... fields @ManyToMany( fetch =…
I am using Spring Boot with JPA and PostgreSQL for my application. I have noticed that every time I restart the server, it seems to "skip" 50 IDs for records in a table. For example, if the last record in…
I've looked at a solution1, solution2, and tried the spring tutorial here. I haven't been able to resolve the problem. As you can see hibernate tries to create the table Hibernate: create table users (id bigserial not null, email varchar(255),…
My entity has a java.sql.Timestamp field: @Column(name = "expires_at") private Timestamp expiresAt; The table also has a default column updated_at, which is dynamically set on insertions/updates (i.e it is not set through JPA): updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,…
On hight loaded service periodically I see a deadlock in DB ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2023-03-06 22:48:18 0x7fa6a24af700 *** (1) TRANSACTION: TRANSACTION 209985062, ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2…
i created my entity in springboot import jakarta.persistence.Entity; import jakarta.persistence.GeneratedValue; import jakarta.persistence.GenerationType; import jakarta.persistence.Table; @Table(name="users") @Entity public class User { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String username; private String email; } i setted the database configuration in…
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.…