Liquibase liquibase-maven-plugin does not run Integration Tests in Apache Maven

General Discussion
1
Hi
 
I am using Liquibase. I want the database tables to be created before the Integration Tests. What I can see is that the Integration Tests are not being run and the liquibase-maven-plugin version 3.2.2 runs last in the build process of Apache Maven.
 
The code is located on GitHib: https://github.com/rajivj2/example2/
 
The EmployeeJpaDAOIT.java is the class that contains the test. All I want to do is have the tables created before the test actually starts.
 
Can you please help?

 
2

What Maven goal do you run to cause this problem? This sounds like a configuration problem. You have the Liquibase plugin set to run in the pre-integration-test phase which means you will need to specifically need to target the integration-test goal for it to fire.

This didn’t fire the Liquibase plugin: mvn test

This did fire the Liquibase plugin: mvn integration-test

Try using the integration-test goal.

3

I have run the mvn integration-test phase on the Command Prompt but still there are problems. It throws the following Exception:

 

Caused by: org.hibernate.HibernateException: Missing table: employee

 

I am specificing the following in the pom.xml:

 

  1. < plugins >

  2.   < plugin >

  3.   < groupId > org.apache.maven.plugins </ groupId >
  4.   

    < artifactId > maven -failsafe-plugin </ artifactId>

  1.    < version > 2.12.4 </ version >

  1. < configuration >

  3. < encoding > utf-8 </ encoding >

  5. </ configuration >

  7. < executions >

  9. < execution >

  11. < goals >

  13. < goal > integration-test </ goal >

  15. < goal > verify </ goal >

  17. </ goals >

  19. </ execution >

  21. </ executions >

  23. </ plugin >

  25. < plugin >

  27. < groupId > org.liquibase </ groupId >

  29. < artifactId > liquibase -maven-plugin </ artifactId >

  31. < version > 3.2.2 </ version >

  33. < configuration >

  35. < propertyFile > src/main/resources/server-internal2.properties </ propertyFile >

  37. < changeLogFile > src/main/resources/db-changelog-employee.xml </ changeLogFile >

  39. < promptOnNonLocalDatabase > false </ promptOnNonLocalDatabase >

  41. < logging > debug </ logging >

  43. </ configuration >

  45. < executions >

  47. < execution >

  49. < phase > pre -integration-test </ phase >

  51. < goals >

  53. < goal > update </ goal >

  55. </ goals >

  57. </ execution >

  59. </ executions >

  61. </ plugin >

The liquibase plugin is creating the tables but they can’t be found. What is wrong? Could you please look at the example project: https://github.com/rajivj2/example2/ on GitHub.

4

Since the Liquibase plugin is creating the tables, it sounds like you got the Liquibase part working. Not sure I can help you with your general project issues.

It doesn’t sound like a Hibernate issue to me. I have a hunch it is your HSQLDB settings. I bet the failsafe plugin forks the process and the HSQLDB in-memory database is shutting down as it is only available to the creating JVM process. I would try not forking the failsafe plugin if you can or switching to file or server mode on the HSQLDB database so the data is persisted between processes.

That being said, this is probably not the best place for general Java project setup questions.