Can someone tell me how to Uniting Testing Hibernate?
Please give me an simple example.Thanks

Can you tell whether you want to unit test in JUnit or something other? And also tell exact problem that you are facing. B'coz unit testing with hibernate is not a substantially different thing at all.

I want to test hbm.xml and the code that mapulate the DB.
There is a StrutsTestCase that can test struts. But is there a HibernateTestCase or something like that to test Hibernate?

I've been writing basic unit tests for beans that call hibernate APIs to query the database using Junit as normal. The basic hibernate mapping types are of course just beans, so it's more interesting to test whether a given query returns objects populated as you'd expect than to test whether their bean getter/setters work.

The hard part is setting up a test fixture. I've been lazy and just assumed certain data is in the database on my test machine. A better way would be to use setUp() and tearDown() to pre-populate the database with test data.

Martin

Thanks!
But can you give me a simple example?I'm still confused about how to pre-populate data and remove them after test.

Here's our setup() - creates the db from scratch using schemaExport:

public void setUp() throws Exception {
super.setUp();
Properties properties = new Properties();
properties.load(new FileInputStream(getPropertiesFile()));
configuration = new Configuration();
configuration.addDirectory(getConfigurationDirectory());
configuration.setProperties(properties);
m_bInitDb = Boolean.valueOf(properties.getProperty(
"db.initialize", "true")).booleanValue();
if (m_bInitDb) {
final SchemaExport schemaExport = new SchemaExport(configuration,
properties);
schemaExport.setDelimiter(";");
schemaExport.create(true, true);
}
sessionFactory = configuration.buildSessionFactory();
}

Of course, this just creates empty tables; if you want data you'll need to add it!

We often use hypersonic sql db for junit testing, which supports an in-memory db, great for this purpose.