posted 9 years ago
The best way to make clear, your sql is correct - is to run it in SQL console (PL SQL Developer or native oracle console). The SQL query you provided look correct. Here can be another trick - you might point to inexistent table, column. The other trick can be in hibernate result mapping. Refer Hibernate SQL Queries manual to see how is correct.