[java] [maven] [dropwizard] [mysql] Dropwizard on host with MySQL on docker

[0] Preparation.

• git
• java jdk 11(set JAVA_HOME path e.g. C:\Program Files\Java\jdk-11)
• maven
• curl
• IntelliJ IDE(optional)
• DBeaver(optional)

[1] Clone project

git clone https://github.com/joebew42/dropwizard-sample-app.git

[2] Change directory to the project root

cd dropwizard-sample-app

[3] Compile Maven project

mvn package

If you get error invalid target release 11, it could be that your java sdk is not 11. Install JDK 11 first and then set JAVA_HOME path for the JDK 11.

[4] Setup MySQL to run in Docker

docker-compose up -d docker exec -it dropwizard-sample-app-db-1 mysql -u root -proot -e "create database db_notes;"

Note:you may need to check the name of the container by running docker console command first.

docker ps
  

[5] Run migration

mvn package java -jar target/sample-app-1.0-SNAPSHOT.jar db migrate configuration.yml

[6] Run application

mvn package java -jar target/sample-app-1.0-SNAPSHOT.jar server configuration.yml

[7] Test

curl -X POST http://localhost:8080/notes --data "Hello world" curl -X POST http://localhost:8080/notes --data "This is a sample application" curl http://127.0.0.1:8080/notes/ curl http://127.0.0.1:8080/notes/1 curl http://127.0.0.1:8080/notes/2

[8] Check MySQL Database using container terminal

mysql -u root -p db_notes mysql> show tables; mysql> select * from notes;

[9] Check MySQL Database using DBeaver on host

host=localhost port=3306 username=root password=root

REF:

https://github.com/joebew42/dropwizard-sample-app