Here is my setup: spring boot 3 + hibernate 6 + postgres 15 I have an entity with field that is enum: @Slf4j @Getter @Setter @Entity @Table(name = "foo") public class FooEntity { @Column(name = "favorite_fruit_type", nullable = true, columnDefinition…
I have created a spring boot application that can connect to the postgresql14 instance (running in my GCP project) when I run the application on my local machine. Setup I used to make it work: Created a postgresql14 instance with…
I'm using Spring Boot 3.2 version with MySQL database. I have two objects @Getter @Setter @Entity @Table(name = "shops") public class Shop{ @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String address; @OneToMany(mappedBy = "shop", cascade = CascadeType.ALL, fetch =…
This Spring service, EmailsOutgoingService, is responsible for processing outgoing emails and it is scheduled to run every 60 seconds using the @Scheduled(fixedRate = 60000) annotation. Basically it checks the status of the email in the queue and performs operations on…
I'm encountering a problem in a Spring Boot application using Hibernate, where OneToOne relationships involving entities with composite keys are not mapped correctly in a PostgreSQL database. Specifically, Hibernate maps the same entity instance to two properties in a parent…
This is the error: java.sql.SQLException: Field 'userid' doesn't have a default value at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) ~[mysql-connector-j-8.3.0.jar:8.3.0] This is my Entity class: @Entity @Table(name = "users") public class Users { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private int userId; } Table: CREATE TABLE `users`…
I'm trying to insert an entry into my database with a one-to-one relationship to another entity. I'm using spring data jpa and postgres. My code looks as follows: @MappedSuperclass @Getter @Setter @ToString public abstract class Post { @Id @GeneratedValue private…
i am creating a new backend APIs for the online shop, I have created entities class for item, cart, user etc. However, when I am running the app the tables are not getting created in the DB. I am not…
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…
I have enum in java public enum Day { MONDAY("D1", "X"), TUESDAY("D2", "X"), WEDNESDAY("D3", "X"), THURSDAY("D4", "X"), FRIDAY("D5", "X"), SATURDAY("D6", "X"), SUNDAY("D7", "Y"); private final String value; private final String value2; Day(String value, String value2) { this.value = value; this.value2…