Creating temporary database that works across maven test phases?

by

For this case I have created the derby-maven-plugin. It’s available from Maven Central, so you don’t need to add any extra repositories or anything.

You could use it like this:

    <project ...>
        <build>
            <plugins>
                <plugin>
                    <groupId>org.carlspring.maven</groupId>
                    <artifactId>derby-maven-plugin</artifactId>
                    <version>1.8</version>
                    <configuration>
                        <basedir>${project.build.directory}/derby</basedir>
                        <port>1527</port>
                    </configuration>
                    <executions>
                        <execution>
                            <id>start-derby</id>
                            <phase>pre-integration-test</phase>
                            <goals>
                                <goal>start</goal>
                            </goals>
                        </execution>
                        <execution>
                            <id>stop-derby</id>
                            <phase>post-integration-test</phase>
                            <goals>
                                <goal>stop</goal>
                            </goals>
                        </execution>
                    </executions>
                </plugin>
            </plugins>
        </build>
    </project>

For more info you can also check the USAGE.

More Related Contents:

  1. I want to find out how much zero come after 1 in SQL
  2. Query to get username from child table with specific condition
  3. Count work days between two dates
  4. Only inserting a row if it’s not already there
  5. Unpivot with column name
  6. Transpose latest rows per user to columns
  7. Foreign key referring to primary keys across multiple tables?
  8. SQL standard to escape column names?
  9. Stored Procedure with optional “WHERE” parameters
  10. subquery in FROM must have an alias
  11. SCOPE_IDENTITY() for GUIDs?
  12. Compute percents from SUM() in the same SELECT sql query
  13. SQL Between clause with strings columns
  14. Paging SQL Server 2005 Results
  15. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  16. Is there a good reason to use upper case for SQL keywords? [closed]
  17. Return multiple columns and rows from a function PostgreSQL instead of record
  18. Multiple Ranks in one table
  19. Comma separated values in a database field
  20. Postgres error updating column data
  21. SQL not displaying null values on a not equals query?
  22. Can SQL Server Express LocalDB be connected to remotely?
  23. SQL LIKE condition to check for integer?
  24. Why don’t DBMS’s support ASSERTION
  25. move cells left in sql if left contains null and right contains value
  26. SQL Server SELECT INTO @variable?
  27. Select a column if other column is null
  28. How to subtract 30 days from the current date using SQL Server
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment