how to set parameter into native query between single quotation in java hibernate?

Question

Below is the simple example which explain my problem

Query(name = "select p.* , pr.actual_date_time , count(*) " +
"from player p  " +
"inner join app.player_reports pr ON pr.player_id = p.id " +
"where pr.actual_date_time between  now() - interval '?1 day' 
   and now() - interval '0 day' " ,nativeQuery = true)
List<PlayerEntity> findCheaters(@param("NumberDays") int number )

this is my query, I want to put "NumberDays" between single quotation and substitute with "?1".

I would be glad to help me, and thank you

You would need to use a date function which accepts a pure numeric parameter. Then, we could make it work. — Tim Biegeleisen
– Tim Biegeleisen, Commented Aug 21, 2018 at 6:12

score 2 · Accepted Answer · 2018-08-21 06:26:30Z

2

You can't parametrize the value for the interval constant, but you can simply multiply the base unit with a parameter:

pr.actual_date_time between  now() - (interval '1 day' * ?) and now()

Then pass the number of days you want as an integer to the PreparedStatement.

Note that the - interval '0 day' is useless

edited Aug 21, 2018 at 6:26

answered Aug 21, 2018 at 6:19

user330315

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

2 Comments

Morteza Malekabadi Over a year ago

so I should pass the query a String ?

user330315 Over a year ago

No, an integer: the number of days.

Collectives™ on Stack Overflow

how to set parameter into native query between single quotation in java hibernate?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related