Using Mysql function in java spring boot

Question

Got a little problem with custom query in my repository:

@Query("select v from Visit v where YEARWEEK('date') = YEARWEEK(curdate())")

Error shows before YEARWEEK('date') opening bracket:

<expression>, <operator>, AND, GROUP, HAVING, IS, OR or ORDER expected, got '('

Also SELECT v FROM Visit v looks ambiguous or a typo. Perhaps SELECT v.* FROM Visit v? And the quotes around 'date' would usually represent strings, do you mean backticks `? — MatBailie
– MatBailie, Commented Jan 31, 2018 at 10:37
Spring Data uses JPQL, not SQL (unless you specify it explicitly) - en.wikipedia.org/wiki/Java_Persistence_Query_Language — Andrei Epure
– Andrei Epure, Commented Jan 31, 2018 at 11:09

BigGinDaHouse · Accepted Answer · 2018-01-31 10:40:27Z

4

you have two options:

For HQL you need following:

@Query("select * from Visit v where YEARWEEK('v.date') = YEARWEEK(curdate())")

You can have native query also, in that case you need following (not the best way for Spring applications, though can be used for some cases)

@Query(value = "select * from Visit where YEARWEEK('date') = YEARWEEK(curdate())", nativeQuery = true)

answered Jan 31, 2018 at 10:40

BigGinDaHouse

1,40411 silver badges20 bronze badges

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

1 Comment

Thanks a lot :) Solved.

andolsi zied · Accepted Answer · 2018-01-31 10:37:19Z

3

The @Query annotation allows to execute native queries by setting the nativeQuery flag to true.

@Query("select v from Visit v where YEARWEEK('date') = YEARWEEK(curdate())", nativeQuery = true)

see spring-data docs Using @Query section.

answered Jan 31, 2018 at 10:37

andolsi zied

3,8613 gold badges35 silver badges44 bronze badges

Thanks a lot :) Solved.