HQL problem

[Samanthi perera]

package roseindia.tutorial.hibernate;
import org.hibernate.Session;
import org.hibernate.*;
import org.hibernate.cfg.*;
import java.util.*;
/**
* @author Deepak Kumar
*
* http://www.roseindia.net
* Select HQL Example
*/
public class SelectHQLExample {
public static void main(String[] args) {
Session session = null;
try{
// This step will read hibernate.cfg.xml
and prepare hibernate for use
SessionFactory sessionFactory = new
Configuration().configure().buildSessionFactory();
session =sessionFactory.openSession();
//Using from Clause
String SQL_QUERY ="from Insurance insurance";
Query query = session.createQuery(SQL_QUERY);
for(Iterator it=query.iterate();it.hasNext();){
Insurance insurance=(Insurance)it.next();
System.out.println("ID: " +
insurance.getLngInsuranceId());
System.out.println("First
Name: " + insurance.getInsuranceName());
}
session.close();
}catch(Exception e){
System.out.println(e.getMessage());
}finally{
}
}
}

is this example HQL is rom Insurance insurance.
my problem is it is leagel or not?
there is no select part?

[Charan kumar sarvepalli]

It is legal HQL query "from Insurance insurance"

if you configure show_sql to true in hibernate.cfg.xml, you can see a SQL query on console fired by Hibernate with all the properties in the Insurance class.

if you want only specific properties (columns) you need to use the "select.." clause.

[Paul Sturrock]

Just so you don't experience too much confusion, I would strongly recommend not using the roseindia tutorials. We see numerous questions here arising from buggy examples coming from that source. The best place to find out about HQL is the Hibernate documentation. If you have not already done this I would take some time to read it.