Currently, while a project using Spring is in progress, DB search using JDBC template is being modified to use JPA. In this situation, it is burdensome to use the JAP repository, so I want to use the entity manager. I…
I meet some JPA behavior I cannot understand. I'm saving specific dateTime ex. 2023-01-01T12:00:00Z (this is Instant) to Postgresql Timestamp without timezone. I'm reading this value and receive the same date: 2023-01-01T12:00:00Z which is expected. I change server timezone from…
Consider the scenario where I have to fetch records based on 2 Ids (LID and KID). I am allowed to have multiple LID matching records but if KID is duplicate in matching records, then pick the latest one according to…
My spring batch application works fine with postgre version 'PostgreSQL 9.5.19'. I have to run this in a different environment with postgre version 'EnterpriseDB 9.5.0.5'. The following error comes. Is this a version problem? How to resolve this? Even though…
What JPA + Hibernate data type should I use to support vector extension in postgres database, so that it allows me to create embeddings using a JPA Entity CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3)); https://github.com/pgvector/pgvector
I'm using JSON_REMOVE method for removing one field from my JSON array column. Below is the query I wrote in JPA - @Modifying @Transactional @Query("UPDATE Data d SET d.month = JSON_REMOVE(d.month, '$[0].revenue') " + " WHERE d.year = :year ")…
@Query(value = " with cte as (n" + " select id, 1 as quantityn" + " from productn" + " where id = :productIdn" + " union alln" + " select distinct combo_id as id,n" + " quantityn" + "…
I have two JPA entities with a @ManyToMany relationship, for example Student and Course, something like that: Student Entity: @ManyToMany List<Course> courses; Course Entity: @ManyToMany List<Student> students; What is the best way/pattern to implement a Spring REST controller which returns…
I have a RESTful app. Here's a test method from it. It is intended to retrieve a page of QuestionCommentResponseDto objects in descending order @Test @Sql(executionPhase = BEFORE_TEST_METHOD, value = BASE_SCRIPT_PATH + "GetPageTest/before.sql") @Sql(executionPhase = AFTER_TEST_METHOD, value = BASE_SCRIPT_PATH +…
What do I need to do for the fk of the child table to be automatically filled? I'm using JPA, Spring Boot, MySql The JSON in Postman is sent successfully, but the Request attribute is not filled in and neither…