I'm working on a Spring Boot application that interfaces with AWS S3, and I need to use LocalStack. I want to configure the endpoint in application.properties rather than in the Java code with .withEndpointConfiguration(). This is because I can't modify…
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 problem to run docker-compose up -d to run Spring Boot on Docker. I have a MySQL database connection issue when the app tries to run integration test with test container. As I cannot connect to MySQL provided…
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 =…
Spring boot MySql program that is able to connect (I believe) but isn't able to create the entity table. Pom.xml- <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>3.2.0-M2</version> <relativePath/> <!-- lookup parent from repository -->…
I need help with understanding and fixing the following issue. I have created a postgresql function for retrieving all events in a specific regions based on regions like this: CREATE OR REPLACE FUNCTION get_all_events_in_regions(regionIds int[]) RETURNS SETOF events AS $$…
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…
To learn Docker I created a small spring boot app that can create/list/update users. I run a postgresql database on port 5432 and I run my app on port 8081. The problem that when I try to start the container…
update 20M records in table and set col1 = col2 + col3 for each record using spring boot. try (Connection connection = dataSource.getConnection()) { String updateQuery = "UPDATE table SET col1 = ? WHERE id = ?"; PreparedStatement preparedStatement =…