Exit status 1 while running docker compose of spring boot application with mysql db

There are a couple of potential issues here.

I’d suggest modifying your docker-compose.yml file to something like this:

version: "3.7"
services:
  mysql:
    image: mysql:5.6.33
    ports:
      - "3306:3306"
    environment:
      MYSQL_ROOT_PASSWORD: roots
      MYSQL_DATABASE: oks
    healthcheck:
      test: ["CMD", "mysqladmin", "ping"]
      interval: 10s
      timeout: 5s
      retries: 5
      start_period: 30s

  api_service:
    build: ./oks-api
    ports:
      - 8081:8081
    depends_on:
      mysql:
        condition: service_healthy
    environment:
      SPRING_DATASOURCE_URL: jdbc:mysql://mysql/oks?characterEncoding=UTF-8
      SPRING_DATASOURCE_USERNAME: root
      SPRING_DATASOURCE_PASSWORD: roots

I have renamed the environment variables in the api_service service.

I also added a health check to the mysql service, so that it will only be marked as healthy once it is ready to accept connections. The api_service service will not start until the mysql service is healthy.

This is what the Java connection code might look like, pulling in the details of the database from the environment variables.

package com.example.demo.config;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.CommandLineRunner;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.stereotype.Component;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.ResultSet;

@Configuration
public class DatabaseConfig {
    private static final Logger logger = LoggerFactory.getLogger(DatabaseConfig.class);

    @Value("${SPRING_DATASOURCE_URL}")
    private String dbUrl;

    @Value("${SPRING_DATASOURCE_USERNAME}")
    private String dbUsername;

    @Value("${SPRING_DATASOURCE_PASSWORD}")
    private String dbPassword;

    // DataSource bean configuration
    @Bean
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
        dataSource.setUrl(dbUrl);
        dataSource.setUsername(dbUsername);
        dataSource.setPassword(dbPassword);
        return dataSource;
    }

    @Component
    public static class MySqlConnectionCheck implements CommandLineRunner {

        private final DataSource dataSource;

        public MySqlConnectionCheck(DataSource dataSource) {
            this.dataSource = dataSource;
        }

        @Override
        public void run(String... args) {
            logger.info("Making connection to MySQL database.");
            try (Connection connection = dataSource.getConnection()) {
                String query = "SELECT 1";
                ResultSet rs = connection.createStatement().executeQuery(query);
                if (rs.next()) {
                    int result = rs.getInt(1);
                    logger.info("🟢 Connected to MySQL database. Test query result: {}", result);
                }
            } catch (Exception e) {
                logger.error("❌ Error connecting to MySQL database: ", e);
            }
        }
    }
}

My impression is that it you are giving the database details as environment variables then you should not duplicate them in your application properties file. One location or the other but not both.

The layout of the simple application I used for testing is:

├── docker-compose.yml
└── oks-api
    ├── Dockerfile
    ├── pom.xml
    └── src
        └── main
            └── java
                └── com
                    └── example
                        └── demo
                            ├── config
                            │   └── DatabaseConfig.java
                            └── DemoApplication.java