Question

I m using H2 with Hibernate to generate in-memory DB on the fly for unit-testing. I managed to create the DB successfully, and everything is working ok. But I have an issue I don t know how to approach. I need to load reference data to the DB for testing prior to the execution of the tests. I have this data sored as a SQL insert s file which I need to run only once in real time envirnemnt, however, because the DB is generated every time from scratch I need to figure out how to insert the data on runtime. The data is quite simple, it s countries lists, states list, etc. Whats the best way to do it ?

b 以前,所有工作都在春季框架下进行。

Answer 1

如经你测试,你可以执行有关建立联系的文稿。

http://www.h2database.com/html/features.html#execute_sql_on_linkion。

Answer 2

从问题所在看,我看到你再次使用Hibernate。您可以把一个名为“进口品......ql”的档案添加到您的班次中(即,如果你重新使用Maven项目布局的话,在北极圈/主要/资源中)。

。

In addition, a file named import.sql in the root of the classpath will be executed on startup if Hibernate creates the schema from scratch (that is if the ddl-auto property is set to create or create-drop). This can be useful for demos and for testing if you are careful, but probably not something you want to be on the classpath in production. It is a Hibernate feature (nothing to do with Spring).

友情链接