[jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-1950) ClassCastException when using Hibernates DetachedCriteria

[ http://jira.jboss.com/jira/browse/JBSEAM-1950?page=comments#action_12378227 ] Christian Pietsch commented on JBSEAM-1950: ------------------------------------------- Maybe I'm doing something crazy. I have a huge resultset (>50.000 objects) and I only want to get 50 objects per page (using criterias maxrows and firstrow). But I also want to display the correct number of total records (e.g. 145.000). The overall idea behind my source is the following: Create a DetachedCriteria with all restrictions and put it in Class ActiveSearchFilter and also set the requested page number there. Then execute: 1. create a copy of my detachedCriteria (suing above copy method) 2. add a projection to my copied detachedcriteria: setProjection(Projections.rowCount()) - to get the total row count 3. execute the original detachedcriteria in ActiveSearchFilter So maybe this is not a seam bug but a bug in my code (but this worked fine in 1.3.0Alpha). Here is the relevant code: public abstract class AbstractSearch implements PageableSearch { @In org.hibernate.Session hibernateSession; ... public List<Object> retrieveItems(ActiveSearchFilter filter) { if (!filter.isRowCountAvailable()) { Criteria c = filter.getCopiedCriteria().getExecutableCriteria( hibernateSession); c.setProjection(Projections.rowCount()); List<Object> l = (List<Object>) c.list(); filter.setTotalSearchResults((Integer) l.get(0)); } Criteria c = filter.getOriginalCriteria().getExecutableCriteria( hibernateSession); if (filter.getMaxRows() != null && filter.getMaxRows() > 0) c.setMaxResults(filter.getMaxRows()); c.setFirstResult(filter.getFirstRow() - 1); return c.list(); } } public class ActiveSearchFilter implements Serializable { private DetachedCriteria originalCriteria; private Integer totalSearchResults; private Integer firstRow; private Integer maxRows; ... protected DetachedCriteria copy(DetachedCriteria criteria) { try { ByteArrayOutputStream baostream = new ByteArrayOutputStream(); ObjectOutputStream oostream = new ObjectOutputStream(baostream); oostream.writeObject(criteria); oostream.flush(); oostream.close(); ByteArrayInputStream baistream = new ByteArrayInputStream(baostream .toByteArray()); ObjectInputStream oistream = new ObjectInputStream(baistream); DetachedCriteria copy = (DetachedCriteria) oistream.readObject(); oistream.close(); return copy; } catch (Throwable t) { throw new HibernateException(t); } } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira