I've have started building a banking project using Java, a Spring Boot application, and a PostgreSQL database. I want to generate a random 8 or 10-digit account number each time I create a new account. What's the best way to…
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 $$…
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…
I've looked at a solution1, solution2, and tried the spring tutorial here. I haven't been able to resolve the problem. As you can see hibernate tries to create the table Hibernate: create table users (id bigserial not null, email varchar(255),…
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…
I have a problem to map PostgreSQL expression below, that extracts hours/minutes/dow, to a CriteriaBuilder expression: select extract(hour from start_time) from meetings where id = 5; meetings have start_time field in a database that maps into ZonedDateTime start Java entity…
I cannot create any table or column in PostgreSQL with springboot and there's no exception observed. It's driving me crazy. I really need your help. here is my code. This is the model class @Entity @Data @AllArgsConstructor @Table(name = "doctor_info")…
I have come across a very strange situation while deploying a Java jar using Azure DevOps Pipelines I am using task: Bash@3 to execute a shell command 'java -jar my-app.jar' I have 1 secret called db-password from Azure KeyVault as…
I am trying to expose an api which downloads files can be of different types, I am showing excel for an example. The file is successfully getting downloaded with GET method endpoint but when i do the same with POST…