What is the main advantage of using the hibernate than using the SQL.
In case you using Hibernate the you neednot require the SQL beacause the Hibernate Query Language (HQL) is much like SQL and are case-insensitive, except for the names of the Java Classes and properties. Hibernate automatically generates the sql query and execute it against underlying database if HQL is used in the application. HQL is based on the relational object models and makes the SQL object oriented. Hibernate Query Language uses Classes and properties instead of tables and columns. In SQL we need join statement to merge the table where as the HQL neednot require because in hibernate we utilizing hbm.xml file.
For more details the main advantage of using the hibernate than using the SQL. Visit this link : http://www.roseindia.net/hibernate/hibernatequerylanguagehql.shtml