Hi there,

I,m trying to list a table content with:

public java.util.List getList(String hql) throws Exception{
Session session = factory.openSession();
List pessoas = session.find(hql);
for(int indice=0; indice<pessoas.size(); indice++)
{
Amigo amigo = (Amigo)pessoas.get(indice);

}
session.flush();
session.close();
return pessoas;
}

and calling by :

dao.getList("from amigos Amigo");
System.out.println(amigo.getTelefone());

inside a main method.

Just tryed to use "SELECT telefone FROM Amigo" in the parameter of getList() but receive the same message:

net.sf.hibernate.QueryException: in expected: Amigo [from amigos Amigo]
at net.sf.hibernate.hql.FromParser.token(FromParser.java:102)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.PreprocessingParser.end(PreprocessingParser.java:142)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:30)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:294)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1562)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1533)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1521)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1513)
at HIBERNA.AmigoDAO.getList(AmigoDAO.java:31)
at HIBERNA.TesteAmigo.main(TesteAmigo.java:19)

I had read about to use HQL sintax and i did.

Thanks for your help.

Try changing your query to:



You need to list the object before the variable...just like in SQL (except you list the table before the variable name)

Since you don't do anything with amigos, you could probably leave it out and just say:



Buena suerte!

Chrisjan