We have applications written in Spring Boot and using jpa to access existing databases. We are in need to upgrade our Aurora (MySQL) database to the latest version which is compatible with MySQL 8. The problem we are having is…
I am using the latest hibernate version (6.5) and hypersistence utils in this version is not supporting custom array types as it's natively supported by hibernate > 6.4. I've tested and this works natively for float[] arrays, so e.g. this…
I have a simple database table (PostgreSql) with the following data In the spring boot JPA application, the corresponding Entity class for this table is defined as follows import java.time.LocalDateTime; import org.hibernate.annotations.UpdateTimestamp; import jakarta.persistence.Entity; import jakarta.persistence.Id; import jakarta.persistence.Table; import lombok.AllArgsConstructor;…
Encountering this exception while updating Spring Boot and Java versions on multi module project . Here are the details Previously: JAVA: 1.8 gradle : 5.6.2-all springboot : 2.1.1 Current JAVA: 21 gradle : 8.9 springboot : 3.3.2 Here is the…
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`…