I am attempting to develop a simple Spring Boot application for managing coupons, to create and read coupons.The application runs without issues when started. However, upon sending a POST request via Postman, I encounter the following error in application :…
I am a simple beginner that want to learn programming and I am a little confused I have three entities: administrator (the only seller), customer and products. Beetween these entities has to be the next relation? Administrator and Product (@OneToMany),…
i'm using postgresql with spring boot and I have a json column defined like this ALTER TABLE core."foo" ADD COLUMN if not exists config json; the Foo entity is mapped like this import com.vladmihalcea.hibernate.type.json.JsonType; import org.hibernate.annotations.Type; ... @Type(JsonType.class) private Config…
Java: 20.0 Springboot: 3.0.1 Table structure posts | CREATE TABLE `posts` ( `id` binary(16) NOT NULL, `posts` varchar(5000) DEFAULT NULL, `created_at` datetime(6) DEFAULT NULL, `updated_at` datetime(6) DEFAULT NULL, `user_id` binary(16) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK8omq0tc18jd43bu5tjh6jvra7taq` (`user_id`), CONSTRAINT `FK8omq0tc18jd43bu5tjh6jvra7taq`…
I have the following Oracle SQL query: SELECT user FROM global_users user WHERE user.status = 'ACTIVE' AND user.description IS NOT NULL AND user.updatedGoodsDate BETWEEN '2024-03-10 20:09:53' AND '2024-03-10 20:09:53' AND ROWNUM <= 13 I tried to edit the query into…
I used springboot+JPA+Hibernate to insert data. But the insertion speed of the first data is too slow, and it becomes faster later. I want to eliminate this situation and make all data insertions fast, including the first one. Is there…
I have a table say t_records which has a JSON type column say col_json which can have value like below { "1": { "value": null, "comment": null, "timestamp": null, "guidelineId": null, "pushedToSnowflakePipeline": "yes" }, "2": { "value": null, "comment": null,…
I have been doing side spring-boot demo project about heroes and villains. Below is the Character class which is extended by Superhero and Villain classes: @Data @NoArgsConstructor @Entity @Table(name = "characters") @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) @JsonTypeInfo(use = JsonTypeInfo.Id.NAME, property = "type")…
I have a preexisting Postgres database with a bunch of tables. Each table has an ID column with a sequence. In my entity class I have something like this: @Entity @Table(name = "plan_block") @Getter @Setter @NoArgsConstructor @AllArgsConstructor @Audited public class…
These are my Entities:- This is my rider Rider entity package com.app.enities; import lombok.*; import org.springframework.data.annotation.Id; import org.springframework.data.mongodb.core.mapping.Document; import java.util.List; @Document(collection = "Rider") @Getter @Setter @AllArgsConstructor @NoArgsConstructor @ToString(callSuper = true) public class Rider { @Id private String id; private String…