how can i write testcase using junit for fallowing code:

private RetentionPeriod getDataRetentionPeriod(Long partnerId) throws Exception {
RetentionPeriod period = null;

Session s = null;
Transaction tx = null;

try {
s = HibernateUtil.currentSession();
// start a new transaction
tx = s.beginTransaction();

Query query = s.createQuery("from RetentionPeriod r where r.partnerId = :partnerId");
query.setLong("partnerId", partnerId.longValue());

List periodList = query.list();
period = (periodList.isEmpty()) ? null : (RetentionPeriod) periodList.get(0);

// commit the transaction
tx.commit();
} catch (Exception e) {
// rollback the transaction
if (tx != null)
tx.rollback();
s.clear();
// an exception has occurred
throw e;
}
return period;
}

[/code]

Hello

I'm using TestNG, HypersonicSQL, Embedded EJB3 by JBoss (as lightweight JTA and JNDI) for this purpose. Main scenario is bootstrap HSQL datasource, and SessionFactory (for create db schema), then I'am using TestNG for persist domain objects (with tx-demarcation), then it is able to query and modify domain. also I can look to db afer test routine

thats all