How to execute sql-script file using hibernate?

Question

I gonna write several intergration tests which will test interatcion with db. For each test I need to have a certain snapshot of db. Each db snapshot saved in .sql file. What I want is to execute certain script file in certain test method, like this:

@Test
public void test_stuff(){
   executeScript(finame.sql);

   ... testing logic ...

   clean_database();
}

Does hibernate has some means to do this?

Answer 1

• You can automatically execute SQL script at startup of hibernate: write your SQL commands in a file called import.sql and put it in the root of the CLASSPATH.

• You don't need to clean your database for your test, just make your test as transactional with rollback at the end of each test. Hence, you are sure your database is not contaminated by your tests. For instance, using Spring:

  @Transactional
  @TransactionConfiguration
  public class MyTest {
  ...
  }
  

If you don't use Spring, try a test framework with default-rollback transaction support.

Answer 2

The topic of deprecated Session.connection() method is dicussed here