JUnit and Hibernate

[Somak Dalui]

I am using this code in JUnit to setup Hibernate with HSQLDB. This is without any hibernate.cfg.xml / hibernate.properties.

protected void setUp() throws Exception {
  Configuration configuration = new Configuration();
        configuration.setProperty(Environment.DRIVER,"org.hsqldb.jdbcDriver");
        configuration.setProperty(Environment.URL,"jdbc:hsqldb:hsql://127.0.0.1/forum");
        configuration.setProperty(Environment.USER, "sa");
        configuration.setProperty(Environment.DIALECT,HSQLDialect.class.getName());
        configuration.setProperty(Environment.SHOW_SQL, "true");
        configuration.setProperty("hibernate.format_sql", "true");
        
        configuration.addResource("forum.hbm.xml");
        
        sessionFactory = configuration.buildSessionFactory();
        
        HibernateTemplate hibernateTemplate = new HibernateTemplate(sessionFactory);
        dao.setHibernateTemplate(hibernateTemplate);
        System.out.println(">>>>>>>>> configuration done ");
        
  super.setUp();
 }

But I once I run some insert/load I am getting unnecessary errors like
DataIntegrityViolationException: Hibernate operation: could not insert:
org.hibernate.TransientObjectException
which otherwise works fine in a Spring+Hibernate environment.

Even simple load operations is not working. Can anyone please tell me what is wrong with this approach ?

Thanks,
Somak