[Code Pipeline x Elastic Beanstalk] CI / CD Java application to Elastic Beanstalk with Code Pipeline Part 2

[2] Creating a table

(1) Next, let's create a table from the client PC, which also serves as a connection check. Start a command prompt and execute the following command to connect to the database instance.

Execution command

> mysql -h host name-P port number-u username-p

Here, the host name is the "endpoint" (1) in the capture below, the port number is the "port" (2: default is 3306), and the user name is the "user name" set in 3. Creating the Elastic Beanstalk environment. (This time admin).

After executing the command, you will be asked for the password, so enter the "password" set in Creating the Elastic Beanstalk environment and press Enter.

After logging in, execute the following DDL and SQL to create the database and tables, and insert the data.

Creating databases and tables

CREATE DATABASE `sample-db` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin;

USE `sample-db`;

CREATE TABLE `shop_informations` (
  `shop_id` mediumint(9) NOT NULL AUTO_INCREMENT COMMENT 'Store ID',
  `shop_name` varchar(100) DEFAULT NULL COMMENT 'Store name',
  `tel` varchar(15) DEFAULT NULL COMMENT 'phone number',
  `zip_code` varchar(10) DEFAULT NULL COMMENT 'Postal code',
  `address` varchar(100) DEFAULT NULL COMMENT 'Street address',
  `access` varchar(100) DEFAULT NULL COMMENT 'access',
  `business_hour` varchar(100) DEFAULT NULL COMMENT 'business hours',
  `regular_holiday` varchar(100) DEFAULT NULL COMMENT 'Regular holiday',
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='store information';

begin;

INSERT INTO shop_informations VALUES(1, 'Spring breeze cafe', '03-XXXX-XXXX', '100-0005', 'Marunouchi, Chiyoda-ku, Tokyo ...', '5 minutes walk from Tokyo Station', 'Weekdays 7:00～21:00 / Saturdays, Sundays, and holidays 10:00～21:00', 'Irregular holidays');
INSERT INTO shop_informations VALUES(2, 'Natsumi Shokudo', '050-XXXX-XXXX', '254-0034', 'Takaracho, Kanagawa Prefecture ...', '10 minutes walk from Hiratsuka station', 'Weekdays 11:00～22:00 / Saturdays, Sundays, and holidays 11:00～20:00', 'Tuesday');
INSERT INTO shop_informations VALUES(3, 'Ceded Akiyama', '049-XXXX-XXXX', '350-0041', 'Rokkenmachi, Kawagoe City, Saitama Prefecture ...', '7 minutes walk from Kawagoeshi station/5 minutes walk from Honkawagoe Station', 'Noon 11:00～14:00 / night 18:00～23:30', 'Sundays and public holidays');
INSERT INTO shop_informations VALUES(4, 'Winter sky kitchen', '04-XXXX-XXXX', '350-0041', 'Honcho, Abiko City, Chiba Prefecture ...', '8 minutes walk from Abiko Station', 'Noon 11:30～14:00 / night 17:00～23:00', 'Thursday');

commit;

• The above data is fictitious. It is not a real store.

[3] Settings in Elastic Beanstalk

(2) Next, add environment variables for database connection in Elastic Beanstalk. In the management console, find and click Elastic Beanstalk.

(3) Click "Edit" at the right end of "Software".

(4) In the "Environment Properties" field, set as follows (①) and click "Apply" (②).

(5) Rewrite the contents of application.yml created in "1. Creating a Java (Spring Boot) application" as follows.

application.yml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://${DB_HOST:(10)Host name entered in}:${DB_PORT:(10)Port number entered in}/${DB_NAME:(10)Database name created in}?serverTimezone=JST
    username: ${DB_USERNAME:(10)Username entered in}
    password: ${DB_PASSWORD:(10)Password entered in}
  jpa:
    database: MYSQL
    hibernate.ddl-auto: none
server:
  port: ${SERVER_PORT:5000}

By doing this, you will be able to connect to the database created this time from the client PC.

(6) In Eclipse, right-click on the created project (①) and click "Run" (②)> "Spring Boot Application" (③) to start the local server.

(7) Launch the browser and hit the following URL to confirm that the result can be obtained.

Execution URL

http://localhost:5000/shop-information/1

(8) Reflect the changes in application.yml to Git's remote repository (CodeCommit). Start the command prompt, move to the root directory of the project, and execute the commands in the following order.

> git add application.yml
> git commit -m "fix application.yml"

About the sequel

The continuation

-[Code Pipeline x Elastic Beanstalk] CI / CD Java application to Elastic Beanstalk with Code Pipeline Part 3

At. 5. Set up the connection for creating the pipeline and 6. Clean up.

Change log

--2020/08/13: [1] Environment, new application creation, [2] Partial change of additional settings in "3. Creating Elastic Beanstalk environment"

reference

procedure

3. Creating an Elastic Beanstalk environment

-Create an Elastic Beanstalk environment | aws -Status color and status | aws --How do I resolve the yellow or red health status warning in an Elastic Beanstalk environment? | aws -[AWS, VPC] I learned how the default security group works while fighting communication errors | Qiita

4. Database connection settings

--[How do I resolve a connection issue to an Amazon RDS instance that uses a VPC public or private subnet? | Aws](https://aws.amazon.com/jp/premiumsupport/knowledge- center / rds-connectivity-instance-subnet-vpc /)