I have this SQL query: select date_trunc('month',created_at-'6d 18:06:56'::interval) +'6d 18:06:56'::interval as created_at, count(*)filter(where status='ACTIVE') as active, count(*)filter(where status='BLOCKED') as blocked from companies where now()-'12 months'::interval < created_at group by 1 order by 1; I tried to use it into Spring…
Getting this as a console help me out please I am trying to connect my spring boot application with mongondb database but not able to properly connect it i have added dependencies and the connection link in application.properties file but…
I have a Spring data JPA repository which is backed by a postgresql database. As part of the query I want to use an interval in the query. I managed to achieve it by creating an SQLFunction that casts the…
I have a problem with SpringBoot in a personal project that I am doing in Visual Studio Code to be able to learn the language, the error is when implementing the security part, for some reason this error prevents the…
I am trying to parse this sql query using spring data jpa to use in my application. It is a postgresql qurey using some of the geospatial functions using postgis. This query is basically trying to find all the records…
I am new to Spring Boot. I am using a book to practice and I run into this problem. Application run fail. Fial to execute CommandLineRunner. My CarRepository.java package com.example.demo.domain; import org.springframework.data.repository.CrudRepository; public interface CarRepository extends CrudRepository<Car,Long>{ } My car.java…
Maven pom dependency: <dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <scope>runtime</scope> </dependency> <!-- https://mvnrepository.com/artifact/org.json/json --> <dependency> <groupId>org.json</groupId> <artifactId>json</artifactId> <version>20230227</version> </dependency> Configuration Dialect: spring: jpa: properties: hibernate: dialect: org.hibernate.dialect.PostgreSQLDialect show-sql: 'true' hibernate: ddl-auto: update I have the following Entity: @Entity @Data @Getter @AllArgsConstructor @NoArgsConstructor @Builder…
I have a simple enough question. I have some entity (I've deliberately cut it down) that has id, name and another identifier(publicId) in the form of uuid, but which is stored in the database as a string. @Entity @Table(name =…
I have written the code. It goes like - Here is my GitHub Repo - https://github.com/SuvamNaskar/spring-learn.git spring.datasource.url=jdbc:mysql://${MYSQL_HOST:localhost}:2023/student?createDatabaseIfNotExist=true&useSSL=false spring.datasource.username=root spring.datasource.password=system32 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.data.jpa.repositories.enabled=true spring.jpa.show-sql=true spring.jpa.properties.hibernate.format_sql=true spring.thymeleaf.check-template-location=false spring.jpa.generate-ddl=true spring.jpa.hibernate.ddl-auto=create-drop spring.jpa.defer-datasource-initialization= true spring.jpa.open-in-view=false logging.level.org.hibernate.SQL=DEBUG logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl This is my application.properties file. I have tried…
I have this Entity class with nickname String as a key. @Data @Entity @Table(name="players") public class Player { @Id private String nickname; @Column(name="name") private String name; @Column(name="surname") private String surname; ... ... ... } Controller @PostMapping(value="/addPlayer", consumes = {MediaType.APPLICATION_JSON_VALUE}, produces…