Dockerize java mysql example project

This simple example combines 2 docker files and docker-compose file, one to spin up a mysql container and the other a java container.

These docker files are located in the corresponding folders (mysql, java). Also contains a docker-compose file in the root folder.

Also you can find a network folder, which contains an sh file to create a network in order to allow the communication between the containers throughout containers names.

---

Docker Compose

At the root file run the following command

docker-compose up

After visit the following url

http://localhost/RESTfulExample/rest/hello/Test

Start the mysql container

You can find the mysql dockerfile in the mysql folder. There you can run the build.sh file in order to build the docker image or you can run the following command.

docker build -t my-mysql .

If you want to change the database name you can change the ENV in dockerfile or you can remove it from docker file and pass the value at the run stage.

After the build of the image, you can run the image. You can use the run.sh file. At the run stage you can specify the root pass, and the ports. Or you can run the below command

docker run -d -p 3311:3306 --name mysqlapp -e MYSQL_ROOT_PASSWORD=supersecret my-mysql

If you want to validate the creation of the database you can connect to the container with the below commands.

Connect in the running container

docker exec -t my-mysql bash 

log in as a root

mysql -uroot -p

Root credentials

supersecret

Display all the databases

showdatabases;

Use the company database

use company;

Display all the tables of company database

show tables;

Show all the rows of a employees

select * from employees;

If the results are the following.

The process is correct.

---

Start the java container

You can find the java dockerfile in the java folder. There you can run the build.sh file in order to build the docker image or you can run the following command.

docker build -t java-connect-with-mysql .

After the build of the image, you can run the image. You can use the run.sh file. At the run stage you can specify the ports and the volumes. Or you can run the below commands.

docker run  -d --name javaapp -p 80:8080 -v /$(pwd):/usr/local/tomcat/webapps java-connect-with-mysql

You can reach this service through docker machine http://docker-machine-ip/RESTfulExample/rest/hello/test

To find docker machine ip, execute the following command.

docker-machine ls

---

Create network

Create a bridge network in order to allow communication between the containers, through container name instead of container IP.

docker network create --driver bridge isolated 

Add db container into the network

docker network connect isolated db

Add java-connect-with-mysql container into the network

docker network connect isolated java-connect-with-mysql

---

💻 Deploy instructions

Use the maven plug-in (tomcat7-maven-plugin) for tomcat server in order to automatically deploy this project in your local server. You can find this plug-in in pom.xml file in order to modify with yours configurations, also don't forget to add in settings.xml your credentials for tomcat server.

<servers>
    <server>
        <id>TomcatServer</id>
        <username>admin</username>
        <password>password</password>
    </server>
</servers>

You can run the below command in order to deploy the artifact in your local tomcat server

mvn clean tomcat7:deploy