the class is here:
public class CmrcCategory implements Serializable {

/** identifier field */
private Integer categoryId;

/** nullable persistent field */
private String categoryName;

/** persistent field */
private Set cmrcProducts;
...

the HQL is here
List l=session.CreateQuery("select c.cmrcProducts from CmrcCategory c where c.categoryId='14'").list();

the Exception is here
expecting 'elements' or 'indices' after: id [select c.cmrcProducts from code.model.CmrcCategory c where c.categoryId='14']

thanks

Well... RTFM really...


but the answer is in the error message:

try using the elements function as documented in the manual. That is:

List l=session.CreateQuery("select elements(c.cmrcProducts) from CmrcCategory c where c.categoryId='14'").list();