Hibernate version:2.1.6

I'm building a method where called the method session.find(String query) and the query string is:"select distinct year(report.date) from ReportFile as report". This method runs correctly in HSQL but when I run it in MySQL with the same hibernate mapping file, just change in the hibernate configuration file using MySQLAlect etc but it works incorrectly(the list returned is zero-size list although there are data in the database).
Do you have any idea?

Thanks

try see database sql. (put show sql in hibernate configuration)
this can help.