How can I test database connections in Spring Boot?

How can I test database connections in Spring Boot?

You can test database connections in Spring Boot using the @SpringBootTest annotation along with an embedded database.

What dependencies do I need for testing with an embedded database?

You need to include dependencies like H2 or HSQLDB in your pom.xml or build.gradle file.

Can you show me a sample test case?

Sure! Here's a simple test case:

@SpringBootTest
public class DatabaseConnectionTest {

    @Autowired
    private DataSource dataSource;

    @Test
    public void testConnection() throws SQLException {
        Connection connection = dataSource.getConnection();
        assertNotNull(connection);
        connection.close();
    }
}