This week's book giveaway is in the Performance forum. We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line! See this thread for details.
So, I have this query:
SELECT TZNAME FROM V$TIMEZONE_NAMES GROUP BY TZNAME
This is basically to get all time zones from Oracle database, however, if I need to retrieve this information somehow using JPA or Hibernate (I would use this infomation as a String List), is there any way I can avoid a Native Query and use some HQL, Criteria query for this?, I mean, I would really like that approach instead...