@Query(value = "SELECT o.restaurant_id as restaurantId, YEAR(o.date_created) as year, MONTH(o.date_created) as month, " + " count(1) as tpn, sum(o.total) as tpv " + " FROM ordersDB.orders o " + " WHERE o.provider_id = :providerId " + " AND o.status !=…
I already have a table (group_relation) with auto incremented integer as Primary Key and want to add a new table (relation_app) map to it. spring-boot = 2.7.14 MySQL = 8 MYSQL DDL CREATE TABLE group_relation ( relation_id int NOT NULL…
I'm trying to transform this JSON in a Java object. But I'm struggling with this conversion. { "id": "c01cede4-cd45-11eb-b8bc-0242ac130003", "publisherId": "nintendo", "name": "Mario", "timePlayed": { "2023-05-01": 10, "2023-05-02": 2, "2023-05-03": 3, "2023-05-04": 4 } } First, I created a class…
I have a problem with my request. I have a table where the id is UUID and I have a query like SELECT * FROM table WHERE fk = ? ORDER BY id ASC LIMIT 5 and this query runs…
If I use @ManyToOne with fetch type LAZY or any other jpa mapping annotations, will jpa run a query on the mapped entity to fetch the id? For example. Department @Entity public class Department { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private…
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 have an entity with specific fields, each of which is mapped to columns in a postgres database. I am using a JpaRepository to persist my entity. I have one column, called info, that can be arbitrary json, and is…
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,…