in Education by
Closed. This question needs debugging details. It is not currently accepting answers. Want to improve this question? Update the question so it's on-topic for Stack Overflow. Closed 3 years ago. Improve this question something weird happens here ... And I want to gel all fields using this query using JPQL or Spring JPA, but both methods return 0 fields. SELECT * FROM puntuacion WHERE id_tienda = 1 AND fecha BETWEEN and ; I have this entity, look at "fecha" property This is the code ... (I'm using Spring Boot, Spring MVC, and Spring JPA) Controller ... Service ... Repository ... Also, I tried something like this, but I got the same result. @Query("SELECT p FROM Puntuacion p WHERE p.isActive = 1 AND p.idTienda = ?1 AND p.fecha BETWEEN '?2' AND '?3'") public List searchTiendaByDate(long idTienda, Date fechaInicio, Date fechaFin); Obviously, when I query the DB it returns values. What happens here ? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
I just pass the Date value as a parameter to the DB and it works. It's not necessary to parse twice the date, trying to match different Date formats. If you are using Spring JPA, just pass the Date value.

Related questions

0 votes
    I have a problem with Spring and JPA. Basically I try to use JPA with Spring with a pure approach ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 4, 2022 in Education by JackTerrance
0 votes
    I am new to spring, as part of my project implementation, I am supposed to add a spring retry on ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jun 2, 2022 in Education by JackTerrance
0 votes
    I am new to spring, as part of my project implementation, I am supposed to add a spring retry on ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 19, 2022 in Education by JackTerrance
0 votes
    I am wanting to understand this Karaf JPA example. When I follow the instructions to add features and run ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 8, 2022 in Education by JackTerrance
0 votes
    I would love to know in iOS email client, How apple manages to create an appointment or set a destination in map ... to do this task? Select the correct answer from above options...
asked Jan 24, 2022 in Education by JackTerrance
0 votes
    How does Apple find dates, times and addresses in emails? I would love to know in iOS email client, How apple ... Which machine learning algorithm they are using to do this task?...
asked Nov 20, 2020 in Education by Editorial Staff
0 votes
    Trying to search trough extrnal api Weather servis. Api is tested and works fine. Problem: Enter value in ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 26, 2022 in Education by JackTerrance
0 votes
    Trying to search trough extrnal api Weather servis. Api is tested and works fine. Problem: Enter value in ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 24, 2022 in Education by JackTerrance
0 votes
    I have a @Stateless-Bean which performs some Database operations in a single method public void doOperation() ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 3, 2022 in Education by JackTerrance
0 votes
    I have a @Stateless-Bean which performs some Database operations in a single method public void doOperation() ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 24, 2022 in Education by JackTerrance
0 votes
    I am new to Spring AOP. Using annotation based Spring configuration: @Configuration @EnableAspectJAutoProxy( ... Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jun 8, 2022 in Education by JackTerrance
0 votes
    Given the widely-shared type Omit, with the definition: type Omit = Pick; which is used to subtract ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 29, 2022 in Education by JackTerrance
0 votes
    httr package does not work well with facebook and twitter API. (a) True (b) False The question was ... questions and answers pdf, Data Science interview questions for beginners...
asked Oct 28, 2021 in Education by JackTerrance
0 votes
    new to play and just trying to follow the video on: http://www.playframework.org/ I'm coming so ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 2, 2022 in Education by JackTerrance
0 votes
    I've a datepicker, using jQuery. But I want to substract 5 days from the date that is selected ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 16, 2022 in Education by JackTerrance
...