Note: If you would like to build and run Waltz on MacOS with PostgreSQL, use this guide.
Waltz is built using Maven.
- Git
- Maven 3
- JDK 17 (see note below)
- Node
- NPM v6+
- Sass
- Database - either
- Liquibase (recommended but not essential)
- jOOQ Pro (if using Microsoft SQL Server)
- Tomcat 10
Note:
When developing on JDK 17 please ensure all class imports are explicit.
This is to prevent collisions between java.lang.Record and org.jooq.Record which can cause compilation errors (see issue: #6678)
It is recommended that you clone the repository on GitHub to maintain your own fork and pull in changes as required.
For Postgres create a new database
create database waltz;
For SQL Server create a new database
CREATE DATABASE waltz ;
When you run the first build (using mvn package) the schema will be generated using the liquibase maven task (ref: waltz-schema/pom.xml).
Starting with release 1.14 (alpha) we will make sample data sets available via the release pages.
See Dump and restore for details on how to import these changes.
Waltz uses maven profiles to target the build against the correct database. Generic db vendor settings are located in
the profiles section of <REPO>/pom.xml and should not need to be changed.
Specific database connection details should be configured in the
~/.m2/settings.xml file. An example (for both PostreSQL and Microsoft
SQL Server) would look like:
<settings>
<profiles>
<!--
these profile are used to provide db connection details
so that the jOOQ code generator can run.
-->
<profile>
<id>dev-postgres</id>
<properties>
<database.url>jdbc:postgresql://localhost:5432/waltz</database.url>
<database.user>dbuser</database.user>
<database.password>dbpassword</database.password>
<database.schema>public</database.schema>
</properties>
</profile>
<profile>
<id>dev-mssql</id>
<properties>
<database.url>jdbc:sqlserver://dbhost:1433;databaseName=waltzdb</database.url>
<database.user>dbuser</database.user>
<database.password>dbpassword</database.password>
<database.schema>dbschema</database.schema>
<database.catalog>waltzdb</database.catalog> <!-- only req'd for code gen w/ mssql -->
</properties>
</profile>
</profiles>
</settings>Typically one of two maven targets is executed. For the first run (and whenever schema updates are required) then a full package build should be executed. For code only change then the quicker compile target can be used.
When running either variant you must provide the names of two profiles, firstly the generic database profile (either waltz-postgres or waltz-mssql) and the specific profile created in your ~/.m2/settings.xml file (in the example above either dev-postgres or dev-mssql).
Note: waltz-mssql-alt uses the newer Microsoft SQL Server driver and is intended to
be the default going forward. The waltz-mssql profile remains for legacy users but
is expected to change in a future release.
Below are some example maven command lines. We typically register the command as an alias to save time.
alias compile-postgres='mvn clean compile -P waltz-postgres,dev-postgres'
alias compile-mssql='mvn clean compile -P waltz-mssql-alt,dev-mssql'
alias pkg-postgres='mvn clean package -P waltz-postgres,dev-postgres'
alias pkg-mssql='mvn clean package -P waltz-mssql-alt,dev-mssql'
Integration tests run in the waltz-integration-test module and are enabled via the
integration-tests Maven profile. The tests support Postgres and MSSQL targets and
can run using Docker (TestContainers) or embedded/fallback modes.
Two system properties control the target database and provider:
-Dtarget.db=postgres|mssql-Ddb.provider=docker|embedded|auto
Defaults (when properties are not supplied):
target.dbdefaults tomssqldb.providerdefaults toembedded
When target.db=mssql and db.provider=embedded, the integration tests use H2 in
MSSQL compatibility mode (they do not start a real SQL Server instance).
Example commands (from repo root):
mvn clean package -P waltz-postgres,dev-postgres,integration-tests -Dtarget.db=postgres -Ddb.provider=docker
mvn clean package -P waltz-mssql-alt,dev-mssql,integration-tests -Dtarget.db=mssql -Ddb.provider=docker
mvn clean package -P waltz-postgres,dev-postgres,integration-tests -Dtarget.db=postgres -Ddb.provider=embedded
mvn versions:set -DnewVersion=1.1.10
mvn versions:commit
- Waltz has been upgraded to run on Java 17, moving from Java 8.
- Developer Actions
- Please ensure your local development environment is configured to use JDK 17.
- Update your IDE settings (e.g., IntelliJ, Eclipse) to point to the JDK 17 installation.
- The web framework, Spark Java, has been upgraded from version 2.7.1 to 2.9.4.
- Developer Impact
- There are no immediate code changes required for developers. The upgrade is backward compatible with our existing usage.
- This change helps keep Waltz current and secure by using a more recent version of its core web framework.
- See pom.xml for a full list of Java dependencies against Java & Sparx upgrade.