Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

OracleV$TIMEZONE_NAMES thorough Hibernate/JPA?

 
Julio Fernandez
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi everyone!,

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...


Thanks & Best Regards!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic