Spring data rest, java.util.Date in url param?

Question

I have a simple POJO named as Check. And I have a simple rest repository:

@RepositoryRestResource(collectionResourceRel = "check",path = "check")
public interface RestCheckRepo
        extends JpaRepository<Check,Integer> {

    public List<Check> findByShopName(@Param("shop") String shop);

    public List<Check> findByDateTime(@Param("dt")Date dt);

    public List<Check> findByShopNameAndDateTime(@Param("shop")String shop, @Param("dt")Date dt);

    public List<Check> findByShopNameAndDateTimeBetween(@Param("shopName") String shop,
                                                        @Param("start")Date t1,
                                                        @Param("end") Date t2);


}

All works fine!! But I don't know how to implement a request handler using java.util.Date as a @RequestParam. Example: http://localhost:8080/check/search/findByDateTime?dt={value}

UPDATE Request http://localhost:8080/check/search/findByDateTime?dt=2015-08-10T13:47:30 ---> Response:

{
    "cause": {
        "cause":null,
        "message":null
    },
    "message":"Failed to convert from type java.lang.String to type @org.springframework.data.repository.query.Param java.util.Date for value '2015-10-07T15:04:46Z'; nested exception is java.lang.IllegalArgumentException"
}

My guess is you need to parse it as java.sql.Date not as java.util.Date — NightsWatch
– NightsWatch, Commented Oct 8, 2015 at 10:40

Jaiwo99 · Accepted Answer · 2015-10-08 11:32:55Z

18

Solution of @kucing_terbang will work, otherwise there is a simpler solution, you need do this:

public List<Check> findByShopNameAndDateTime(
    @Param("shop")String shop, 
    @DateTimeFormat(your-format-comes-here)@Param("dt")Date dt);

answered Oct 8, 2015 at 11:32

Jaiwo99

10.1k5 gold badges38 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kucing_terbang · Accepted Answer · 2015-10-08 10:55:29Z

2

You can register a custom editor so that spring able to pass the parameter to the argument. example

@InitBinder
public void dataBinding(WebDataBinder binder) {
    SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
    dateFormat.setLenient(false);
    binder.registerCustomEditor(Date.class, "dob", new CustomDateEditor(dateFormat, true));
}

answered Oct 8, 2015 at 10:55

kucing_terbang

5,1592 gold badges24 silver badges28 bronze badges

2 Comments

Roger Glover Over a year ago

Ummm, where did you add this method? Surely not to the RestCheckRepo interface, right? And there's no controller, since the point of @RepositoryRestResource is to avoid the need for a controller. Maybe inside some @Configuration annotated class? BTW, is this thread-safe? I know that SimpleDateFormat by itself is not.

kucing_terbang Over a year ago

I would choose to use @ControllerAdvice annotated class. I am not so sure whether it is gonna work if you use @Configuration annotated class. As for the thread safety, looking at the java doc of DataBinder class, I would say it is thread-safe. I mean, if it is not safe, then the doc would state it. But you probably want to test this to make sure of it.

Collectives™ on Stack Overflow

Spring data rest, java.util.Date in url param?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related