Hi,
I'm doing an API for a database using spring+hibernate.
The arhitecture is: my testcase call a service, the service calls many methods from many DAO's,
the DAO's use hibernate to get the data from DB.
My goal is to keep the data of database unchanged after I'm runing the testcase.
I would like to make rollback before to end the testcase (to the service level).
I don't want for this transaction to use an EJB container.
How can I solv this problem?

Thanks in advance!

Coulding you just use a temporary, separate database table?

You could load it up, test against it, and then delete everything, and recreate the database again. That's fairly easy to do with scripts and the Hibernate SchemaExport class.

What's wrong with doing it that way?