CODEWITHSUNDEEP
unit-testinghibernateimportsql-scripts
Vladimir
Vladimir

Reputation: 13153

How to execute sql-script file using hibernate?

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?

Upvotes: 4

Views: 9976

Answers (4)

Kartoch
Kartoch

Reputation: 7779

  • 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.

Upvotes: 3

Rots
Rots

Reputation: 787

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

Upvotes: 2

user241178
user241178

Reputation: 271

Have you heard of Hypersonic SQL? It's an in-memory database where all your tables reside in the memory, then do your test (with Read, update, insert, delete), finally when you close, all data is gone. Read more at: http://www.hsqldb.org/

Upvotes: 0

simonlord
simonlord

Reputation: 4367

You can get hold of the underlying JDBC connection via the hibernate session instance:

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

So you could write your executeScript() method to take the filename and a hibernate session and read the file and execute the sql on the jdbc connection.

HTH

Upvotes: 0

Related Questions