I have defined liquibase migrations that don't pass because I have to release schema.sql first, which is to be enforced as part of integration tests. Unfortunately as embedded postgres starts (https://github.com/zonkyio/embedded-postgres) liquibase migrations start immediately after that and schema.sql is…
i am new in spring boot and such things, this is the first project i was trying to explore and was following a lecture for project creation, i made an entity class with @entity and @table annotations, when i executed…
I am writing a small program in Java with Spring boot. It is connecting to a MySQL Database that is dockerized. upon running the program, I get the following Error message org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in…
I am working on a spring boot app with postgresql. I have three classes: User, Medcin that inherits from User, and Cabinet. In relationships, the Medcin can be in one Cabinet, and Cabinet can have one or more Medcin @Entity…
I have two entities Users and Addresses with OneToMany mapping from Users. @Entity @Table(name = "users") public class User { @Id @GeneratedValue private Long id; @Email @Column(unique = true) private String email; @OneToMany(mappedBy = "user", orphanRemoval = true, fetch =…
I'm trying to execute a SpringBoot project, however I'm having this problem running: *************************** APPLICATION FAILED TO START *************************** Description: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. Reason: Failed to…
This question has been asked several times, i looked at the answers, but none of them helped me. So i am asking what is wrong in my case and i hope that someone will figure it out. The java version,…
I have a jpql as: @Query("SELECT b FROM Booking b WHERE " + "(:officeId is null OR b.officeId = :officeId) AND " + "(:status is null OR b.status = :status) AND " + "(:type is null OR b.officeType = :type)…
I am writing Restful API in Spring boot 3 with java 17 and i am unable to create table .Can anyone please help POM File <?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.0.3</version> <relativePath/> <!--…
Given the following dataset: category date amount fruit 2023-01-01 1 fruit 2023-01-02 2 meat 2023-01-03 3 nuts 2023-01-04 4 nuts 2023-01-05 5 nuts 2023-01-06 6 Is it possible to do a multi-group aggregation in Mongo JPA that yields: One row…