Criteria « JDBC « JPA Q&A

  1. JPA Q&A
  2. JDBC
  3. Criteria




1. Criteria API returns a too small resultset    stackoverflow.com

How is this possible, I have to following criteria 

Criteria criteria = getSession().createCriteria(c);
criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
criteria.add(Restrictions.eq("active",true));
List list = criteria.list();
The size of list is now 20. If I add a max results to the criteria, 
Criteria criteria ...

2. Hibernate Criteria    java-forums.org

Hello every one, can someone could help me? i have a problem while doing a sub query: here is the script : DetachedCriteria subInfo = DetachedCriteria.forClass(ActReg.class) .createAlias("ActType", "t") .createAlias("Incident", "i") .add(Restrictions.eq("t.Id", 158)) .setProjection(Projections.property("i.Id")); Criteria critInfo = session.createCriteria(IncData.class) .add(Restrictions.between("DateLogged",st_date,end _date)) .add(Subqueries.in("Id",subInfo)); the output is : java.lang.String cannot be cast to java.lang.Integer Thank you for any help

3. Using Filters with Criteria: JDBC param index out of range    forum.hibernate.org

Newbie Joined: Fri May 27, 2005 10:45 am Posts: 6 Hi, The problem below occurs with both Hibernate 3.0.5 and Hibernate 3.1 rc2. I tested it with two different databases: Sybase and HSQL DB and the same problem occurs. It seems that there is a problem when you use the Criteria API and when there is a filter enabled. The problem ...

4. Execution Time standard jdbc vs hibernate criteria api    forum.hibernate.org