How to execute sql script file using hibernate?

Question

I am going to write some integration tests that will test interatcion with db. For each test, I need to have some db snapshot. Each db snapshot is saved in a .sql file. I want to execute a specific script file in a specific testing method, for example:

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

   ... testing logic ...

   clean_database();
}

Does sleep mode have any means to do this?

Answer 1

• You can automatically execute the SQL script when you run hibernate: write your SQL commands in a file named import.sql and put it in the root of CLASSPATH.

• , . , , . , Spring:

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

Spring, .

Answer 2

Session.connection()

Answer 3

JDBC :

https://www.hibernate.org/hib_docs/v3/api/org/hibernate/Session.html#connection()

, executeScript(), hibernate, sql jdbc.

Answer 4

Hypersonic SQL? , , ( Read, update, insert, delete), , , . : http://www.hsqldb.org/