Hi guys,


Hibernate version 3.2.2
MySql version 4.1.22

This isn't really a bug but a warning i'm getting:

firstResult/maxResult specified on polymorphic query; applying in memory!


Basically i am using the Spring HibernateTemplate.

The query is:

select count(user) from MailingListUser user


Even though i have the Spring HibernateDao bean set to scope prototype because i have more than 1 query in a single service any filters or maxResults set on the hibernateTemplate are not cleared before the next query call on the template.


The results is that Hibernate loads every element of the class MailingListUser i am querying from the database. Which takes forever.

Has anyone seen the above warning before?

Thanks,
Josh