Hi!

I have the following query to execute:
select sum(price) from spot where job_id=? and id in (select id from status where job_id=? group by spot_event_id)

i have the following objects:
spot
status

Should i create the query with Query query = session.createQuery?

as well, what does it mean setCacheable on the query?when can i flush this cacheable?

A join-query might be more performant.
Something like:




For Querying scalar values I personally prefer session.createSQLQuery


It puts the result into Second Level cache if you properly configure the Second Level cache.
Second Level cache is optional and may increase the performance of your application.



What do you mean with 'flushing the cacheable' ?
Do you mean evict?

Thanks
I mean by flush - that if this query was saved using cacheable true, how can i not cache it - let's say when i know that new data was inserted to the database and may influence this query?

You need no worry about, it's hibernate itself checking if a cached query-result-set is still valid.
For this purpose (if hibernate.cache.use_query_cache is enabled) hibernate maintains the UpdateTimeStampsRegion
where it keeps track whenever data was inserted -update -deleted on the database.