Start Database

In the previous step, we’ve already prepared the scripts for Oracle, MySQL, and Postgres databases and put these script files under light-example-4j/rest/openapi/database. At this moment, you should have two sub-folders under the database directory: generated and dbscript.

To work on our service, we need to start database standalone for now. Depending on which database you are working on, you can choose one of them below. For this demo, we use MySQL, and later on, we can switch to Postgres and Oracle. If your organization is not forced to use Oracle, you don’t need to try Oracle; the image is too big to download.

MySQL Database

docker run -v ~/networknt/light-example-4j/rest/openapi/database/dbscript/mysql:/docker-entrypoint-initdb.d -e MYSQL_ROOT_PASSWORD=my-secret-pw -d -p 3306:3306 mysql:5.6

Postgres Database

docker run -v ~/networknt/light-example-4j/rest/openapi/database/dbscript/postgres:/docker-entrypoint-initdb.d -e POSTGRES_PASSWORD=my-secret-pw -e POSTGRES_DB=hello_world -d -p 5432:5432 postgres

Oracle Database

docker run -v ~/networknt/light-example-4j/rest/openapi/database/dbscript/oracle:/docker-entrypoint-initdb.d -d -p 1522:1521 wnameless/oracle-xe-11g

In this step, let’s first start the MySQL database, and in the next step, we will set up the database connection pool in our project.