Persisting Data Between Restarts


This tutorial page relies on completing the previous tutorials:


Cromwell remembers everything it knows!

Let's get started!

  • Start the MySQL docker container with the following line:
docker run -p 3306:3306 --name NameOfTheContainer -e MYSQL_ROOT_PASSWORD=YourPassword -e MYSQL_DATABASE=DatabaseName -e MYSQL_USER=ChooseAName -e MYSQL_PASSWORD=YourOtherPassword -d mysql/mysql-server:5.5
  • Update your application.conf file.
database {
  profile = "slick.jdbc.MySQLProfile$"
  db {
    driver = "com.mysql.cj.jdbc.Driver"
    url = "jdbc:mysql://localhost/DatabaseName?rewriteBatchedStatements=true&useSSL=false"
    user = "ChooseAName"
    password = "YourOtherPassword"
    connectionTimeout = 5000

Add the line above, below the all other lines in your application.conf. Replace "DatabaseName", "ChooseAName" and "YourOtherPassword" with the values you choose in step 2, preserving the double quotes.

Test it by running your server with the updated application.conf:

java -Dconfig.file=/path/to/application.conf/ -jar cromwell-[version].jar ...

Next steps

You might find the following tutorials interesting to tackle next: