Hi,

Can someone please take a look at the error statement below which doesn't work in my program but works in any sql editor and maybe will be able to identify the cause of it.

Thanks for help


Hibernate version: 2


[b]net.sf.hibernate.QueryException: unexpected token: , [select * from service,servicedesc where (service.eqDesc_id = servicedesc.desc_id) and (service.SERVICE_TYPE='EQUIPMENT') and (servicedesc.SD_TYPE='EQUIPMENTDESC') and (eqDesc_model = 'model26') and (eqDesc_type = 'Digital Box') order by eqDesc_type,eqDesc_model]

at net.sf.hibernate.hql.FromParser.token(FromParser.java:47)

at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)

at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)

at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)

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:293)

at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1561)

at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1532)

at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
b]