We saw how to clone a postgresql database for testing cleanly in an earlier blog post. The next step is to do so from Java so it can be part of an integration test. How to run each of 4 DDLs: Running a DDL file is easy which is good since we have four of [...]

Problem How do I run setup/teardown for my whole suite, not just one class/test? Impact of Problem JUnit offers @Before to run a method before each test and @BeforeClass to run a method once before a class.  For a small suite, @BeforeClass may be enough.  For a large integration test suite, setting up the database [...]

I’m looking at writing integration tests for the back end of JavaRanch‘s JForum install. A few “pesky” requirements/constraints Multiple developers all over the word have their own local test databases filled with data in different states.  The tests must work for everyone.  Ideally they won’t leave data floating around either. The tests must use PostgreSQL.  [...]