> For the complete documentation index, see [llms.txt](https://testcontainers.gitbook.io/workshop/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://testcontainers.gitbook.io/workshop/step-3-adding-some-tests.md).

# Step 3: Adding some tests

The app doesn't have any tests yet. But before we write our first test, let's create an abstract test class for the things which are common between the tests.

## Abstract class

Add `com.example.demo.support.AbstractIntegrationTest` class to `src/test/java` sourceset. It should be an abstract class with standard Spring Boot's testing framework annotations on it:

```java
@SpringBootTest(webEnvironment = WebEnvironment.RANDOM_PORT)
```

## Our very first test

Now we need to test that the context starts.\
Add `com.example.demo.DemoApplicationTest`, extend it from your base class you just created and add a dummy test:

```java
@Test
public void contextLoads() {
}
```

Run it and verify that the application starts and the test passes. Spring will detect H2 on the classpath and use it as an embedded DB.

This is already a useful smoke test since it ensures, that Spring Boot is able to initialize the application context successfully.

## Populate the database

The context starts. However, we need to populate the database with some data before we can write the tests.

Let's add a `src/test/resources/schema.sql` file with the following content:

```sql
CREATE TABLE IF NOT EXISTS talks(
  id    VARCHAR(64)  NOT NULL,
  title VARCHAR(255) NOT NULL,
  PRIMARY KEY (id)
);

INSERT
  INTO talks (id, title)
  VALUES ('testcontainers-integration-testing', 'Modern Integration Testing with Testcontainers')
  ON CONFLICT do nothing;

INSERT
  INTO talks (id, title)
  VALUES ('flight-of-the-flux', 'A look at Reactor execution model')
  ON CONFLICT do nothing;
```

Now run the test again. Oh no, it fails!

```
...
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "INSERT INTO TALKS (ID, TITLE) VALUES ('testcontainers-integration-testing', 'Modern Integration Testing with Testcontainers') ON[*] CONFLICT DO NOTHING";
...
```

It seems that H2 does not support the PostgreSQL SQL syntax, at least not by default.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://testcontainers.gitbook.io/workshop/step-3-adding-some-tests.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.