Test containers for database testing in Spring Boot - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What is the output when running a Spring Boot test with a PostgreSQL Testcontainer?

Given this Spring Boot test setup using Testcontainers for PostgreSQL, what will be the database URL printed during the test?

Spring Boot

import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import org.testcontainers.containers.PostgreSQLContainer;

@SpringBootTest
public class DatabaseTest {

    static PostgreSQLContainer<?> postgres = new PostgreSQLContainer<>("postgres:15-alpine")
        .withDatabaseName("testdb")
        .withUsername("user")
        .withPassword("pass");

    static {
        postgres.start();
    }

    @Test
    void printJdbcUrl() {
        System.out.println(postgres.getJdbcUrl());
    }
}

A jdbc:postgresql://localhost:5432/testdb

B jdbc:mysql://<container-ip>:<random-port>/testdb

C jdbc:postgresql://localhost:<random-port>/testdb

D jdbc:postgresql://localhost:5432/postgres

💡 Hint

Testcontainers dynamically assigns a random port mapped to localhost.

Testcontainers starts a PostgreSQL container with a random free port mapped to container's 5432. The JDBC URL includes localhost and this random port, not fixed ports.

📝 Syntax

intermediate

Which option correctly defines a MySQL Testcontainer in Spring Boot?

Choose the correct Java code snippet to create a MySQL Testcontainer with database name 'mydb', username 'root', and password 'rootpass'.

A

MySQLContainer<?> mysql = new MySQLContainer<>("mysql:8.0")
    .withDatabaseName("mydb")
    .withUsername("root")
    .withPassword("rootpass");

B

MySQLContainer mysql = new MySQLContainer<>("mysql:8.0")
    .databaseName("mydb")
    .username("root")
    .password("rootpass");

C

;)"ssaptoor"(drowssaPhtiw.    
)"toor"(emanresUhtiw.    
)"bdym"(emaNesabataDhtiw.    
)"0.8:lqsym"(><reniatnoCLQSyM wen = lqsym >?<reniatnoCLQSyM

D

MySQLContainer mysql = new MySQLContainer<>("mysql:8.0")
    .withDatabaseName("mydb")
    .withUsername("root")
    .withPassword("rootpass");

💡 Hint

Check the generic type and method names carefully.

Option A uses the correct generic type MySQLContainer and the proper builder methods with 'with' prefix. Other options miss generics or use incorrect method names.

🔧 Debug

advanced

Why does this Testcontainer-based test fail to connect to the database?

Consider this Spring Boot test code snippet: @PostConstruct public void init() { postgres.start(); } @Test void testConnection() { DataSource ds = DataSourceBuilder.create() .url(postgres.getJdbcUrl()) .username(postgres.getUsername()) .password(postgres.getPassword()) .build(); try (Connection conn = ds.getConnection()) { assertFalse(conn.isClosed()); } } Why might this test fail with a connection error?

A The test method does not have @Transactional annotation.

B The DataSourceBuilder does not support PostgreSQL connections.

C The username and password are incorrect because they are hardcoded elsewhere.

D The container is started too late; it should start before @PostConstruct or statically.

💡 Hint

Think about when the container starts relative to when the test runs.

Starting the container in @PostConstruct is too late for Spring Boot to configure the DataSource properly. The container should start statically or before the Spring context loads.

❓ state_output

advanced

What is the value of 'container.isRunning()' after calling 'container.stop()'?

Given a running PostgreSQL Testcontainer instance named 'container', what will be the value of 'container.isRunning()' immediately after calling 'container.stop()'?

A false

B true

C null

D Throws IllegalStateException

💡 Hint

Stopping a container should update its running state.

Calling stop() stops the container and updates its internal state. Therefore, isRunning() returns false after stop().

🧠 Conceptual

expert

Why use Testcontainers for database testing instead of an embedded database?

Which of the following is the best reason to prefer Testcontainers for database testing in Spring Boot over embedded databases like H2?

A Testcontainers require no Docker installation, making them easier to use.

B Testcontainers provide a real database environment matching production, avoiding differences in SQL dialect and behavior.

C Embedded databases cannot be used with Spring Boot tests.

D Testcontainers are faster to start and run than embedded databases.

💡 Hint

Think about how close the test environment is to production.

Testcontainers run real database instances in Docker containers, ensuring tests run against the same database engine as production. Embedded databases often differ in SQL support and behavior.