problem with hibernate criteria

[Petr Vosahlo]

Hello, i have problem with using hibernate criteria laguage. I have two classes:

@Entity
public class T01Clen implements Serializable {

	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue
	private Integer UID;
	
	private String adresaPoznamka;
	private Date casRegistrace;
	private Integer foto;
	private String jmeno;
	private String mesto;
	private String nick;
	private String heslo;
	private String poznamka;
	private String prijmeni;
	private String psc;
	private String telefon;
	private String ulice;
	
	@ManyToOne
	C01TypClenstvi typClenstvi;
	
	@OneToMany(mappedBy="clen")
	@OrderBy 
	Collection<T04Email> emails = new ArrayList<T04Email>();
	
	@OneToMany(mappedBy="clen")
	@OrderBy 
	Collection<T02Ucet> ucets = new ArrayList<T02Ucet>();
	
	@OneToMany(mappedBy="clen")
	@OrderBy  
	Collection<T15Role> roles = new ArrayList<T15Role>();

    

and

   

@Entity
public class T15Role {
	
	@Id
	@GeneratedValue
	private Integer idRole;
	private Integer idTypRole;
	private Date pocatekPlatnosti;
	private Date konecPlatnosti;

	public T15Role(){
	}
	
	@ManyToOne
	C02TypRole typRole;
	
	@ManyToOne
	T01Clen clen;
	
	@ManyToOne
	T08Domena domena;

 

i think that i have mapped it well. everything works fine, until i have tried DetachedCriteria for class T15Role. Here is dao:

 
	@Override
	public List<OverviewClenDTO> getClensDTO(OverviewClenDTOFiltr filtr) {
		em = emf.createEntityManager();
		Session session = (Session) em.getDelegate();
		Criteria criteria = session.createCriteria(T01Clen.class, "clen");
		criteria.setResultTransformer(Criteria.ROOT_ENTITY);
		criteria.createAlias("clen.typClenstvi", "typClenstvi" , Criteria.LEFT_JOIN);
		criteria.createAlias("clen.ucets", "ucty", Criteria.LEFT_JOIN);
		criteria.createAlias("clen.emails", "emaily");
		criteria.createAlias("clen.podclens", "podclenove", Criteria.LEFT_JOIN);
		
		criteria.setProjection(Projections.projectionList().add(

				Projections.sum("ucty.zustatek"),"zustatek").add(
				Projections.groupProperty("UID"), "UID").add(
				Projections.groupProperty("prijmeni"), "prijmeni").add(
				Projections.groupProperty("jmeno"), "jmeno").add(
				Projections.groupProperty("nick"), "nick").add(
				Projections.groupProperty("casRegistrace"), "casRegistrace").add(
				Projections.groupProperty("mesto"), "mesto").add(
				Projections.groupProperty("ulice"), "ulice").add(
				Projections.groupProperty("telefon"), "telefon").add(
				Projections.groupProperty("typClenstvi.typClenstvi"), "typClenstvi").add(
				Projections.groupProperty("typClenstvi.idTypClenstvi"), "idTypClenstvi").add(
				Projections.groupProperty("poznamka"),"poznamka").add(
				Projections.groupProperty("ucty.idUcet")).add(
				Projections.min("emaily.email"), "email").add(
				Projections.min("emaily.idEmail")).add(
				Projections.countDistinct("podclenove.UID"), "pocetPodclens").add(
				Projections.groupProperty("podclenove.idPodclen"))
		);

		if(filtr.getRole() != null && filtr.getRole().getIdTypRole() != null) {
			System.out.println("DAO IMPL "+ filtr.getRole().getIdTypRole()); // this returns good values
			
			DetachedCriteria sbq = DetachedCriteria.forClass(T15Role.class);
			sbq.setProjection(Projections.property("UID"));
			sbq.add(Restrictions.eq("roles.idTypRole", filtr.getRole().getIdTypRole()));

			criteria.add(Subqueries.ge("UID", sbq));
		}				


			return (List<OverviewClenDTO>) criteria.setResultTransformer(Transformers.aliasToBean(OverviewClenDTO.class)).list();

   

than i get error log like this:

  
23.1.2010 23:22:06 com.sun.facelets.FaceletViewHandler handleRenderException
SEVERE: Error Rendering View[/s_uzivatele.jspx]
javax.faces.FacesException: javax.el.ELException: /s_uzivatele.jspx @160,56 value="#{spravaClenaBean.clensDTO}": Error reading 'clensDTO' on type cz.uhk.hkFreeNet.beans.SpravaClenaBean
	at javax.faces.component.UIData.getValue(UIData.java:612)
	at org.ajax4jsf.component.UIDataAdaptor.getValue(UIDataAdaptor.java:1644)
	at org.ajax4jsf.component.SequenceDataAdaptor.getDataModel(SequenceDataAdaptor.java:65)
	at org.ajax4jsf.component.SequenceDataAdaptor.createDataModel(SequenceDataAdaptor.java:59)
	at org.richfaces.component.UIDataTable.createDataModel(UIDataTable.java:125)
	at org.ajax4jsf.component.UIDataAdaptor.getExtendedDataModel(UIDataAdaptor.java:621)
....
Caused by: org.hibernate.MappingException: Unknown entity: null
	at org.hibernate.impl.SessionFactoryImpl.getEntityPersister(SessionFactoryImpl.java:550)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getPropertyMapping(CriteriaQueryTranslator.java:518)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getType(CriteriaQueryTranslator.java:477)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getTypeUsingProjection(CriteriaQueryTranslator.java:459)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getTypedValue(CriteriaQueryTranslator.java:509)
	at org.hibernate.criterion.SimpleExpression.getTypedValues(SimpleExpression.java:71)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getQueryParameters(CriteriaQueryTranslator.java:251)
	at org.hibernate.criterion.SubqueryExpression.toSqlString(SubqueryExpression.java:55)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getWhereCondition(CriteriaQueryTranslator.java:334)
	at org.hibernate.loader.criteria.CriteriaJoinWalker.<init>(CriteriaJoinWalker.java:71)
	at org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:67)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1550)
	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
	at cz.uhk.hkFreeNet.dao.impl.DaoImpl.getClensDTO(DaoImpl.java:427)
...
  

i tried rewrite the subquery like this:

 
		if(filtr.getRole() != null && filtr.getRole().getIdTypRole() != null) {
			System.out.println("DAO IMPL "+ filtr.getRole().getIdTypRole());

			DetachedCriteria sbq = DetachedCriteria.forClass(T15Role.class, "roles");
			sbq.setResultTransformer(Criteria.ROOT_ENTITY);
			sbq.createAlias("roles.clen", "clen");
			sbq.setProjection(Projections.groupProperty("clen.UID"));
			sbq.add(Restrictions.eq("roles.idTypRole", filtr.getRole().getIdTypRole()));

			criteria.add(Subqueries.ge("UID", sbq));
		}
   

error message:

   
2010-01-23 23:28:00,234 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 30000, SQLState: 42X04
2010-01-23 23:28:00,234 ERROR [org.hibernate.util.JDBCExceptionReporter] - Column 'CLEN1_.UID' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'CLEN1_.UID' is not a column in the target table.
 

a bit confusing messages for me