JPQL statement returning boolean value
Yes, it is possible with following:
select case when (count(scen) > 0) then true else false end
from Scenario scen where scen.name = :name
What about just:
select count(scen) > 0
from Scenario scen where scen.name = :name