Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use withDatabaseName method of org.testcontainers.containers.JdbcDatabaseContainer class

Best Testcontainers-java code snippet using org.testcontainers.containers.JdbcDatabaseContainer.withDatabaseName

Source:DatabaseInvocationContextProvider.java

...15    public static Network network = Network.newNetwork();16    public DatabaseInvocationContextProvider() {17        containers = new HashMap<>();18        containers.put("mysql", (MySQLContainer) new MySQLContainer("mysql:8.0.25")19                .withDatabaseName("app")20                .withUsername("app")21                .withPassword("pass")22                .withNetwork(network)23                .withNetworkAliases("mysql")24                .withExposedPorts(3306));25        containers.put("postgresql", (PostgreSQLContainer) new PostgreSQLContainer("postgres:latest")26                .withDatabaseName("app")27                .withUsername("app")28                .withPassword("pass")29                .withNetwork(network)30                .withNetworkAliases("psql")31                .withExposedPorts(5432));32    }33    @Override34    public boolean supportsTestTemplate(ExtensionContext extensionContext) {35        return true;36    }37    @Override38    public Stream<TestTemplateInvocationContext> provideTestTemplateInvocationContexts(ExtensionContext extensionContext) {39        return containers.keySet().stream().map(this::invocationContext);40    }...

Source:DatabaseConfig.java

...18    @SuppressWarnings({"resource", "java:S2095", "java:S1452"})19    @Bean(initMethod = "start", destroyMethod = "stop")20    public JdbcDatabaseContainer<?> jdbcDatabaseContainer() {21        return new PostgreSQLContainer<>(PG_IMAGE)22                .withDatabaseName("salary_calc_demo")23                .withUsername("salary_calc_demo_user")24                .withPassword("salary_calc_demo_user_pwd")25                .waitingFor(Wait.forListeningPort());26    }27    @Bean28    public DataSource dataSource(@Nonnull final JdbcDatabaseContainer<?> jdbcDatabaseContainer) {29        final HikariConfig hikariConfig = new HikariConfig();30        hikariConfig.setJdbcUrl(jdbcDatabaseContainer.getJdbcUrl());31        hikariConfig.setUsername(jdbcDatabaseContainer.getUsername());32        hikariConfig.setPassword(jdbcDatabaseContainer.getPassword());33        return new HikariDataSource(hikariConfig);34    }35}...

Source:TestConfig.java

...12    // Ð·Ð°Ð¿ÑÑÐº Ð¸ Ð¾ÑÑÐ°Ð½Ð¾Ð²ÐºÐ° ÐºÐ¾Ð½ÑÐµÐ¹Ð½ÐµÑÐ° Ð¿Ð¾ lifecycle-ÑÐ¾Ð±ÑÑÐ¸ÑÐ¼Ð¸ ÐºÐ¾Ð¼Ð¿Ð¾Ð½ÐµÐ½ÑÐ° (1)13    @Bean(initMethod = "start", destroyMethod = "stop")14    public JdbcDatabaseContainer<?> jdbcDatabaseContainer() {15        return new PostgreSQLContainer<>("postgres:14")16                .withDatabaseName("testdb")17                .withUsername("sa")18                .withPassword("sa")19                .waitingFor(Wait.forListeningPort());// Ð¾Ð¶Ð¸Ð´Ð°Ð½Ð¸Ðµ Ð´Ð¾ÑÑÑÐ¿Ð½Ð¾ÑÑÐ¸ Ð¿Ð¾ÑÑÐ° (2)20    }21    @Bean22    public DataSource dataSource(JdbcDatabaseContainer<?> jdbcDatabaseContainer) {23        var hikariConfig = new HikariConfig();24        hikariConfig.setJdbcUrl(jdbcDatabaseContainer.getJdbcUrl());25        hikariConfig.setUsername(jdbcDatabaseContainer.getUsername());26        hikariConfig.setPassword(jdbcDatabaseContainer.getPassword());27        return new HikariDataSource(hikariConfig);28    }29}...

withDatabaseName

Using AI Code Generation

1import java.sql.Connection;2import java.sql.DriverManager;3import java.sql.SQLException;4import java.sql.Statement;5import org.junit.After;6import org.junit.Before;7import org.junit.Test;8import org.testcontainers.containers.JdbcDatabaseContainer;9public class TestContainerDemo {10	private JdbcDatabaseContainer container;11	public void setUp() {12		container = new JdbcDatabaseContainer("mysql:5.7.21") {13		};14		container.start();15	}16	public void test() throws SQLException {17		Connection connection = DriverManager.getConnection(container.getJdbcUrl(), container.getUsername(),18				container.getPassword());19		Statement statement = connection.createStatement();20		statement.execute("CREATE DATABASE IF NOT EXISTS test");21	}22	public void tearDown() {23		container.stop();24	}25}26import java.sql.Connection;27import java.sql.DriverManager;28import java.sql.SQLException;29import java.sql.Statement;30import org.junit.After;31import org.junit.Before;32import org.junit.Test;33import org.testcontainers.containers.JdbcDatabaseContainer;34public class TestContainerDemo {35	private JdbcDatabaseContainer container;36	public void setUp() {37		container = new JdbcDatabaseContainer("mysql:5.7.21") {38		};39		container.withDatabaseName("test");40		container.start();41	}42	public void test() throws SQLException {43		Connection connection = DriverManager.getConnection(container.getJdbcUrl(), container.getUsername(),44				container.getPassword());45		Statement statement = connection.createStatement();46		statement.execute("CREATE DATABASE IF NOT EXISTS test");47	}48	public void tearDown() {49		container.stop();50	}51}52import java.sql.Connection;53import java.sql.DriverManager;54import java.sql.SQLException;55import java.sql.Statement;56import org.junit.After;57import org.junit.Before;58import org.junit.Test;59import org.testcontainers.containers.JdbcDatabaseContainer;60public class TestContainerDemo {61	private JdbcDatabaseContainer container;

withDatabaseName

Using AI Code Generation

1import org.junit.Test;2import org.testcontainers.containers.JdbcDatabaseContainer;3import org.testcontainers.containers.PostgreSQLContainer;4import java.sql.Connection;5import java.sql.DriverManager;6import java.sql.SQLException;7import java.sql.Statement;8public class TestContainerDatabaseName {9    public void testContainerDatabaseName() throws SQLException {10        JdbcDatabaseContainer container = new PostgreSQLContainer()11                .withDatabaseName("my_db");12        container.start();13        Connection connection = DriverManager.getConnection(container.getJdbcUrl(), container.getUsername(), container.getPassword());14        Statement statement = connection.createStatement();15        statement.execute("CREATE TABLE users (id INT)");16    }17}18    at org.testcontainers.containers.GenericContainer.tryStart(GenericContainer.java:491)19    at org.testcontainers.containers.GenericContainer.lambda$doStart$0(GenericContainer.java:318)20    at org.rnorth.ducttape.unreliables.Unreliables.retryUntilSuccess(Unreliables.java:88)21    at org.testcontainers.containers.GenericContainer.doStart(GenericContainer.java:316)22    at org.testcontainers.containers.GenericContainer.start(GenericContainer.java:298)23    at org.testcontainers.containers.PostgreSQLContainer.start(PostgreSQLContainer.java:114)24    at TestContainerDatabaseName.testContainerDatabaseName(TestContainerDatabaseName.java:16)25    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)26    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)27    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)28    at java.lang.reflect.Method.invoke(Method.java:498)29    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)30    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)31    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)32    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)33    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)34    at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)35    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)

withDatabaseName

Using AI Code Generation

1import org.testcontainers.containers.JdbcDatabaseContainer;2import org.testcontainers.containers.MySQLContainer;3public class Main {4    public static void main(String[] args) {5        JdbcDatabaseContainer container = new MySQLContainer("mysql:5.7.22").withDatabaseName("test");6        container.start();7        System.out.println(container.getJdbcUrl());8    }9}10import org.testcontainers.containers.JdbcDatabaseContainer;11import org.testcontainers.containers.MySQLContainer;12public class Main {13    public static void main(String[] args) {14        JdbcDatabaseContainer container = new MySQLContainer("mysql:5.7.22").withUrlParam("useSSL", "false");15        container.start();16        System.out.println(container.getJdbcUrl());17    }18}19import org.testcontainers.containers.JdbcDatabaseContainer;20import org.testcontainers.containers.MySQLContainer;21public class Main {22    public static void main(String[] args) {23        JdbcDatabaseContainer container = new MySQLContainer("mysql:5.7.22").withUrlParam("useSSL", "false").withUrlParam("useUnicode", "true");24        container.start();25        System.out.println(container.getJdbcUrl());26    }27}28import org.testcontainers.containers.JdbcDatabaseContainer;29import org.testcontainers.containers.MySQLContainer;30public class Main {31    public static void main(String[] args) {32        JdbcDatabaseContainer container = new MySQLContainer("mysql:5.7.22").withUrlParam("useSSL", "false").withUrlParam("useUnicode", "true").withUrlParam("useJDBCCompliantTimezoneShift", "true");33        container.start();34        System.out.println(container.getJdbcUrl());35    }36}

withDatabaseName

Using AI Code Generation

1package org.testcontainers.containers;2import org.junit.Test;3import java.sql.Connection;4import java.sql.DriverManager;5import java.sql.ResultSet;6import java.sql.SQLException;7public class JdbcDatabaseContainerTest {8    public void testWithDatabaseName() throws SQLException {9        try (MySQLContainer container = new MySQLContainer().withDatabaseName("test")) {10            container.start();11            Connection connection = DriverManager.getConnection(container.getJdbcUrl(), container.getUsername(), container.getPassword());12            ResultSet resultSet = connection.createStatement().executeQuer

withDatabaseName

Using AI Code Generation

1package org.testcontainers.containers;2import java.sql.Connection;3import java.sql.ResultSet;4import java.sql.SQLException;5import java.sql.Statement;6import java.util.ArrayList;7import java.util.List;8import org.junit.Test;9import com.zaxxer.hikari.HikariConfig;10import com.zaxxer.hikari.HikariDataSource;11public class JdbcDatabaseContainerTest {12    public void test() throws SQLException {13        PostgreSQLContainer postgreSQLContainer = new PostgreSQLContainer();14        postgreSQLContainer.start();15        HikariConfig config = new HikariConfig();16        config.setJdbcUrl(postgreSQLContainer.getJdbcUrl());17        config.setUsername(postgreSQLContainer.getUsername());18        config.setPassword(postgreSQLContainer.getPassword());19        HikariDataSource dataSource = new HikariDataSource(config);20        Connection connection = dataSource.getConnection();21        Statement statement = connection.createStatement();22        statement.execute("CREATE TABLE public.test_table (id integer, name text)");23        statement.execute("INSERT INTO public.test_table (id, name) VALUES (1, 'test')");24        ResultSet resultSet = statement.executeQuery("SELECT * FROM public.test_table");25        List<String> results = new ArrayList<>();26        while (resultSet.next()) {27            results.add(resultSet.getString("name"));28        }29        System.out.println(results);30        connection.close();31        dataSource.close();32        postgreSQLContainer.stop();33    }34}

withDatabaseName

Using AI Code Generation

1import org.testcontainers.containers.JdbcDatabaseContainer;2public class TestContainer {3    public static void main(String[] args) {4        JdbcDatabaseContainer container = null;5        container.withDatabaseName("test");6    }7}8import org.testcontainers.containers.JdbcDatabaseContainer;9public class TestContainer {10    public static void main(String[] args) {11        JdbcDatabaseContainer container = null;12        container.withDatabaseName("test");13    }14}

withDatabaseName

Using AI Code Generation

1package org.testcontainers.containers;2import org.junit.Test;3import org.testcontainers.containers.JdbcDatabaseContainer;4public class TestContainerDB {5    public void testDB() {6        JdbcDatabaseContainer db = new JdbcDatabaseContainer("mysql:5.7.12");7        db.withDatabaseName("test");8    }9}10package org.testcontainers.containers;11import org.junit.Test;12import org.testcontainers.containers.JdbcDatabaseContainer;13public class TestContainerDB {14    public void testDB() {15        JdbcDatabaseContainer db = new JdbcDatabaseContainer("mysql:5.7.12");16        db.withDatabaseName("test");17    }18}19package org.testcontainers.containers;20import org.junit.Test;21import org.testcontainers.containers.JdbcDatabaseContainer;22public class TestContainerDB {23    public void testDB() {24        JdbcDatabaseContainer db = new JdbcDatabaseContainer("mysql:5.7.12");25        db.withDatabaseName("test");26    }27}28package org.testcontainers.containers;29import org.junit.Test;30import org.testcontainers.containers.JdbcDatabaseContainer;31public class TestContainerDB {32    public void testDB() {33        JdbcDatabaseContainer db = new JdbcDatabaseContainer("mysql:5.7.12");34        db.withDatabaseName("test");35    }36}37package org.testcontainers.containers;38import org.junit.Test;39import org.testcontainers.containers.JdbcDatabaseContainer;40public class TestContainerDB {41    public void testDB() {42        JdbcDatabaseContainer db = new JdbcDatabaseContainer("mysql:5.7.12");43        db.withDatabaseName("test");44    }45}

withDatabaseName

Using AI Code Generation

1package org.tutorial.testcontainers;2import org.testcontainers.containers.JdbcDatabaseContainer;3public class One {4    public static void main(String[] args) {5        JdbcDatabaseContainer container = new JdbcDatabaseContainer("mariadb:latest");6        container.withDatabaseName("mydb");7        container.start();8        System.out.println(container.getJdbcUrl());9        container.stop();10    }11}12package org.tutorial.testcontainers;13import org.testcontainers.containers.JdbcDatabaseContainer;14public class Two {15    public static void main(String[] args) {16        JdbcDatabaseContainer container = new JdbcDatabaseContainer("mariadb:latest");17        container.withUrlParam("databaseName", "mydb");18        container.start();19        System.out.println(container.getJdbcUrl());20        container.stop();21    }22}23package org.tutorial.testcontainers;24import org.testcontainers.containers.JdbcDatabaseContainer;25public class Three {26    public static void main(String[] args) {27        JdbcDatabaseContainer container = new JdbcDatabaseContainer("mariadb:latest");28        container.withUrlParam("databaseName", "mydb");29        container.withUrlParam("user", "myuser");30        container.start();31        System.out.println(container.getJdbcUrl());32        container.stop();33    }34}

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.