Session s = Persistance.getSession();
StringBuffer sql = new StringBuffer("select count(*) from ");
sql.append(criteria.getCriteriaClass().getName());

// here we should append the 'where'-clause to sql
// but: How can we get it from a given Criteria instance?

int recordCount = ((Integer) s.iterate(sql.toString()).next()).intValue();

try {
    Session s = Persistance.getSession();
   
    StringBuffer sql = new StringBuffer("select count(*) from ");
    sql.append(criteria.getCriteriaClass().getName());

    CriteriaImpl criteriaImpl = (CriteriaImpl) criteria;
    Iterator iter = criteriaImpl.iterateExpressionEntries();
    if (iter.hasNext()) {
        StringBuffer condition = new StringBuffer(30);
       
        while ( iter.hasNext() ) {
            CriteriaImpl.CriterionEntry ee = (CriteriaImpl.CriterionEntry) iter.next();
            String sqlString = ee.getCriterion().toSqlString(
                (SessionFactoryImplementor)s.getSessionFactory(),
                criteriaImpl.getPersistentClass( ee.getAlias() ),
                ee.getAlias(),
                criteriaImpl.getAliasClasses()
            );
            condition.append(sqlString);
            if ( iter.hasNext() ) condition.append(" and ");
        }
       
        sql.append(" where ").append(condition);
    }
    _log.debug("Record count query: " + sql.toString());
    recordCount = ((Integer) s.iterate(sql.toString()).next())
            .intValue();
    pageCount = (recordCount / PAGE_SIZE) - 1;
} catch (HibernateException e) {
    _log.error("Couldn't calculate record count", e);
    recordCount = -1;
    pageCount = 1;
}

31000 [http-80-Processor24] DEBUG com.pi.portal.data.BasicWrapper  - Record count query: select count(*) from com.pi.tcomadm.entities.Stadt where lower(this.name) like ?
Hibernate: select count(*) as x0_0_ from stadt stadt0_ where (lower(this.name)like ? )
31000 [http-80-Processor24] WARN  net.sf.hibernate.util.JDBCExceptionReporter  - SQL Error: 0, SQLState: 07001
31000 [http-80-Processor24] ERROR net.sf.hibernate.util.JDBCExceptionReporter  - No value specified for parameter 1
31000 [http-80-Processor24] ERROR net.sf.hibernate.util.JDBCExceptionReporter  - Could not execute query
java.sql.SQLException: No value specified for parameter 1
   at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2264)
   at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2217)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1511)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
   at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
   at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
   at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:868)
   at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1610)
   at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1583)
   at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1575)
   at com.pi.portal.data.BasicWrapper.<init>(BasicWrapper.java:86)

...