Hibernate Integration Unit Testing Issues

[Jason Ferguson]

I am attempting to use Spring's AbstractTransactionalDataSourceSpringContextTests to Unit Test my Spring/Hibernate DAO layer. Unfortunately, the DAO methods use the load() method of the HibernateTemplate class, which does not return the actual object, but a Proxy to the object.

My "loadById()" methods work correctly, but when I use them to get data which I then pass to the actual method under test, the test terminates at the assertXXX() statement (i.e. assertEquals("Bad User, no cookie", report1, report2)).

Here is some actual code to show what I am talking about (edited to remove identifying information):

ReportDao:

public Report searchCompletedByOrganizationAndDate(Organization organization, Date time) {
 
        DetachedCriteria crit = DetachedCriteria.forClass(Report.class);
        crit.add(Restrictions.eq("complete", Boolean.valueOf(true)));
        crit.add(Restrictions.eq("dateSubmitted", time));
        DetachedCriteria organizationCrit = crit.createCriteria("organization");
        organizationCrit.add(Restrictions.eq("organizationID", new Integer(organization.getOrganizationID())));
 
        List results = getHibernateTemplate().findByCriteria(crit);
        if (results.size()==0) {
            return null;
        }
 
        return (Report) results.get(0);
 
    }

And here is the relevant unit test code:

public class ReportDaoTest extends AbstractTransactionalDataSourceSpringContextTests {
 
    private ReportDao reportDao;
    private OrganizationDao organizationDao;
    private HibernateTemplate hibernateTemplate;
 

    SessionFactory sessionFactory;
 
    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }
 
    protected String[] getConfigLocations() {
        return new String[]{
                "applicationContext.xml",
                "applicationContext-hibernate.xml",
                "applicationContext-dev-dataSource.xml"
        };
    }
 
    public onSetUp() {
        reportDao = (ReportDao) applicationContext.getBean("reportDao");
        organizationDao = (OrganizationDao) applicationContext.getBean("organizationDao");
        hibernateTemplate = new HibernateTemplate(sessionFactory);
    }
 
    public void testSearchCompletedByOrganizationAndDate() {
 
        String sql = "SELECT REPORTID, ORGANIZATIONID, DATESUBMITTED FROM APP.T_REPORT WHERE COMPLETE=1 AND ROWNUM=1";
        Map results = jdbcTemplate.queryForMap(sql);
 
        int reportId = ((BigDecimal) results.get("REPORTID")).intValue();
 
        Report report1 = reportDao.loadById(reportId);
 
        hibernateTemplate.flush();
        
        assertNotNull("First report loaded is null (this should not happen!)", report1);
 
        int organizationId = ((BigDecimal) results.get("ORGANIZATIONID")).intValue();
        Organization org = organizationDao.loadById(organizationId);
        hibernateTemplate.flush();
        assertNotNull("Unable to retrieve organization to test searchCompletedByOrganizationAndDate", org);
 
        Timestamp ts = (Timestamp) results.get("DATESUBMITTED");
        Date dateSubmitted = new Date(ts.getTime());
        Report report2 = reportDao.searchCompletedByOrganizationAndDate(org, dateSubmitted);
        assertNotNull("Unable to retrieve report by given organization and date");
 
        assertEquals("Both report objects should be equal!", report1, report2);
        assertTrue("Retrieved report should be complete!", report2.isComplete());
 
    }
}

Any help would be appreciated.