Unlock 30% off on Manual Testing Annual Plans this Holiday Season. 
Use Code: LCMYEARENDEXCL30
Use Code: LCMYEARENDEXCL30Check icon
Copied to Clipboard!
How to use createConnection method of org.testcontainers.containers.JdbcDatabaseContainer class
Best Testcontainers-java code snippet using org.testcontainers.containers.JdbcDatabaseContainer.createConnection
Source:JooqIntegrationTests.java 
...65 mySqlContainer.start();66 }67 JdbcDatabaseContainer container = (JdbcDatabaseContainer) mySqlContainer;68 container.getJdbcUrl();69 Connection connection =container.createConnection("");70 DSLContext context = DSL.using(connection, SQLDialect.MYSQL);71 List<CompleteVehicleRecord> allVehicles = context.select(field(name("brand")), field("model"), field("price")).from(table("complete_car_listing")).orderBy(field("year").asc(), two()).fetchInto(CompleteVehicleRecord.class);72 assertTrue(allVehicles.size() >= 1);73 }7475 @Test76 @Order(1)77 public void test_mocked_out_connection() throws SQLException {78 JdbcDatabaseContainer container = (JdbcDatabaseContainer) mySqlContainer;79 Connection connection =container.createConnection("");80 mockedDriver.when(()-> DriverManager.getConnection(anyString())).thenReturn(connection);81 insertVehicle();82 }838485}
...
Source:PreflightOperations.java
...46 .withEnv("TESTCONTAINERS_CHECKS_DISABLE","true")47 .withEnv("TESTCONTAINERS_RYUK_DISABLED ","false")48 .withExposedPorts(3306);49 mySql.start();50 return ((JdbcDatabaseContainer)mySql).createConnection("");51 }5253 public static void generateJooqCode(GenericContainer container) throws Exception {54 JdbcDatabaseContainer mySql = (JdbcDatabaseContainer) PreflightOperations.mySql;55 generateCodeWithCode(mySql.getJdbcUrl(),mySql.getUsername(),mySql.getPassword());56 logger.info("Migration complete");57 }5859}
...
Source:Hooks.java
...20 ScenarioDataStore.put(JDBC_CONTAINER, container);21 Cast cast = new Cast();22 cast.actorNamed("John",23 ManageTables.with(),24 ExecuteSQLQueries.sql(container.createConnection("?")));25 Director.setStage(cast);26 }27 @AfterScenario28 public void afterScenario() {29 JdbcDatabaseContainer container = (JdbcDatabaseContainer) ScenarioDataStore.get(JDBC_CONTAINER);30 container.stop();31 }32}...
createConnection
Using AI Code Generation
1import org.testcontainers.containers.JdbcDatabaseContainer;2import org.testcontainers.containers.JdbcDatabaseContainerProvider;3import org.testcontainers.containers.MSSQLServerContainerProvider;4import org.testcontainers.containers.OracleContainerProvider;5import org.testcontainers.containers.PostgreSQLContainerProvider;6import org.testcontainers.containers.MSSQLServerContainer;7import org.testcontainers.containers.OracleContainer;8import org.testcontainers.containers.PostgreSQLContainer;9import org.testcontainers.containers.JdbcDatabaseContainer.*;10import java.sql.Connection;11import java.sql.DriverManager;12import java.sql.SQLException;13public class 1 {14 public static void main(String[] args) throws SQLException {15 JdbcDatabaseContainerProvider provider = new PostgreSQLContainerProvider();16 JdbcDatabaseContainer container = provider.newInstance("postgres:9.6.8");17 container.start();18 System.out.println(container.getJdbcUrl());19 System.out.println(container.getUsername());20 System.out.println(container.getPassword());21 Connection connection = container.createConnection("");22 System.out.println(connection);23 }24}25Connection: PostgreSQL JDBC Driver (version 42.2.5)
createConnection
Using AI Code Generation
1import org.testcontainers.containers.JdbcDatabaseContainer;2import org.testcontainers.containers.MySQLContainer;3import java.sql.Connection;4import java.sql.DriverManager;5import java.sql.SQLException;6import java.sql.Statement;7public class 1 {8 public static void main(String[] args) throws SQLException {9 JdbcDatabaseContainer container = new MySQLContainer("mysql:5.7.22");10 container.start();11 Connection connection = container.createConnection("");12 Statement statement = connection.createStatement();13 statement.execute("CREATE TABLE IF NOT EXISTS test (id int)");14 statement.close();
createConnection
Using AI Code Generation
1package org.testcontainers.containers;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.SQLException;5import java.sql.Statement;6import java.util.Properties;7public class JdbcDatabaseContainerTest {8 public static void main(String[] args) throws SQLException {9 try (MySQLContainer container = new MySQLContainer()) {10 container.start();11 Connection connection = container.createConnection("");12 Statement statement = connection.createStatement();13 statement.executeUpdate("CREATE TABLE test (id int)");14 statement.close();15 connection.close();16 }17 }18}19package org.testcontainers.containers;20import java.sql.Connection;21import java.sql.DriverManager;22import java.sql.SQLException;23import java.sql.Statement;24import java.util.Properties;25public class JdbcDatabaseContainerTest {26 public static void main(String[] args) throws SQLException {27 try (MySQLContainer container = new MySQLContainer()) {28 container.start();29 Connection connection = container.createConnection("");30 Statement statement = connection.createStatement();31 statement.executeUpdate("CREATE TABLE test (id int)");32 statement.close();33 connection.close();34 }35 }36}37package org.testcontainers.containers;38import java.sql.Connection;39import java.sql.DriverManager;40import java.sql.SQLException;41import java.sql.Statement;42import java.util.Properties;43public class JdbcDatabaseContainerTest {44 public static void main(String[] args) throws SQLException {45 try (MySQLContainer container = new MySQLContainer()) {46 container.start();47 Connection connection = container.createConnection("");48 Statement statement = connection.createStatement();49 statement.executeUpdate("CREATE TABLE test (id int)");50 statement.close();51 connection.close();52 }53 }54}55package org.testcontainers.containers;56import java.sql.Connection;57import java.sql.DriverManager;58import java.sql.SQLException;59import java.sql.Statement;60import java.util.Properties;61public class JdbcDatabaseContainerTest {62 public static void main(String[] args) throws SQLException {63 try (MySQLContainer container = new MySQLContainer()) {64 container.start();65 Connection connection = container.createConnection("");66 Statement statement = connection.createStatement();67 statement.executeUpdate("CREATE TABLE test (id int)");68 statement.close();
createConnection
Using AI Code Generation
1package org.testcontainers.containers;2import java.sql.Connection;3import java.sql.SQLException;4public interface JdbcDatabaseContainer<SELF extends JdbcDatabaseContainer<SELF>> extends DatabaseContainer<SELF> {5 String getDriverClassName();6 String getJdbcUrl();7 String getUsername();8 String getPassword();9 default Connection createConnection(String query) throws SQLException {10 return DriverManager.getConnection(getJdbcUrl(), getUsername(), getPassword());11 }12}13package org.testcontainers.containers;14import java.sql.Connection;15import java.sql.SQLException;16public interface JdbcDatabaseContainer<SELF extends JdbcDatabaseContainer<SELF>> extends DatabaseContainer<SELF> {17 String getDriverClassName();18 String getJdbcUrl();19 String getUsername();20 String getPassword();21 default Connection createConnection(String query) throws SQLException {22 return DriverManager.getConnection(getJdbcUrl(), getUsername(), getPassword());23 }24}25package org.testcontainers.containers;26import java.sql.Connection;27import java.sql.SQLException;28public interface JdbcDatabaseContainer<SELF extends JdbcDatabaseContainer<SELF>> extends DatabaseContainer<SELF> {29 String getDriverClassName();30 String getJdbcUrl();31 String getUsername();32 String getPassword();33 default Connection createConnection(String query) throws SQLException {34 return DriverManager.getConnection(getJdbcUrl(), getUsername(), getPassword());35 }36}37package org.testcontainers.containers;38import java.sql.Connection;39import java.sql.SQLException;40public interface JdbcDatabaseContainer<SELF extends JdbcDatabaseContainer<SELF>> extends DatabaseContainer<SELF> {41 String getDriverClassName();42 String getJdbcUrl();43 String getUsername();44 String getPassword();45 default Connection createConnection(String query) throws SQLException {46 return DriverManager.getConnection(getJdbcUrl(), getUsername(), getPassword());47 }48}
createConnection
Using AI Code Generation
1import org.testcontainers.containers.JdbcDatabaseContainer;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.SQLException;5public class Main {6 public static void main(String[] args) {7 JdbcDatabaseContainer container = new JdbcDatabaseContainer("mysql:5.7.22");8 container.start();9 Connection connection = container.createConnection("");10 }11}12import org.testcontainers.containers.JdbcDatabaseContainer;13import java.sql.Connection;14import java.sql.DriverManager;15import java.sql.SQLException;16public class Main {17 public static void main(String[] args) {18 JdbcDatabaseContainer container = new JdbcDatabaseContainer("mysql:5.7.22");19 container.start();20 Connection connection = container.createConnection("");21 }22}23import org.testcontainers.containers.JdbcDatabaseContainer;24import java.sql.Connection;25import java.sql.DriverManager;26import java.sql.SQLException;27public class Main {28 public static void main(String[] args) {29 JdbcDatabaseContainer container = new JdbcDatabaseContainer("mysql:5.7.22");30 container.start();31 Connection connection = container.createConnection("");32 }33}34import org.testcontainers.containers.JdbcDatabaseContainer;35import java.sql.Connection;36import java.sql.DriverManager;37import java.sql.SQLException;38public class Main {39 public static void main(String[] args) {40 JdbcDatabaseContainer container = new JdbcDatabaseContainer("mysql:5.7.22");41 container.start();42 Connection connection = container.createConnection("");43 }44}45import org.testcontainers.containers.JdbcDatabaseContainer;46import java.sql.Connection;47import java.sql.DriverManager;48import java.sql.SQLException;49public class Main {50 public static void main(String[] args) {
createConnection
Using AI Code Generation
1import org.testcontainers.containers.JdbcDatabaseContainer;2import org.testcontainers.containers.PostgreSQLContainer;3import java.sql.Connection;4import java.sql.SQLException;5import java.sql.Statement;6import java.util.Properties;7public class TestPostgres {8 public static void main(String[] args) throws SQLException {9 JdbcDatabaseContainer postgres = new PostgreSQLContainer().withDatabaseName("test");10 postgres.start();11 Properties properties = new Properties();12 properties.setProperty("user", postgres.getUsername());13 properties.setProperty("password", postgres.getPassword());14 properties.setProperty("ssl", "false");15 Connection connection = postgres.createConnection(properties);16 Statement statement = connection.createStatement();17 statement.execute("CREATE TABLE test (id int)");18 statement.execute("INSERT INTO test VALUES (1)");19 statement.execute("INSERT INTO test VALUES (2)");20 statement.execute("INSERT INTO test VALUES (3)");21 statement.execute("INSERT INTO test VALUES (4)");22 statement.execute("INSERT INTO test VALUES (5)");23 statement.execute("SELECT * FROM test");24 }25}26psql (12.1, server 11.6 (Debian 11.6-1.pgdg90+1))27test=> select * from test;
createConnection
Using AI Code Generation
1import org.testcontainers.containers.JdbcDatabaseContainer;2import org.testcontainers.jdbc.ConnectionUrl;3import java.sql.Connection;4import java.sql.SQLException;5public class TestConnection {6 public static void main(String[] args) throws SQLException {7 JdbcDatabaseContainer container = new JdbcDatabaseContainer() {8 public String getJdbcUrl() {9 return null;10 }11 public String getDriverClassName() {12 return null;13 }14 };15 .withUsername("testuser")16 .withPassword("testpass")17 .build());18 System.out.println(connection);19 }20}21import org.testcontainers.containers.JdbcDatabaseContainer;22import org.testcontainers.jdbc.ConnectionUrl;23import java.sql.Connection;24import java.sql.SQLException;25public class TestConnection {26 public static void main(String[] args) throws SQLException {27 JdbcDatabaseContainer container = new JdbcDatabaseContainer() {28 public String getJdbcUrl() {29 return null;30 }31 public String getDriverClassName() {32 return null;33 }34 };35 .withUsername("testuser")36 .withPassword("testpass")37 .build());38 System.out.println(connection);39 }40}
createConnection
Using AI Code Generation
1import org.testcontainers.containers.JdbcDatabaseContainer;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.SQLException;5public class Main {6 public static void main(String[] args) {7 JdbcDatabaseContainer container = new JdbcDatabaseContainer("mysql:5.7.22");8 container.start();9 Connection connection = container.createConnection("");10 }11}12import org.testcontainers.containers.JdbcDatabaseContainer;13import java.sql.Connection;14import java.sql.DriverManager;15import java.sql.SQLException;16public class Main {17 public static void main(String[] args) {18 JdbcDatabaseContainer container = new JdbcDatabaseContainer("mysql:5.7.22");19 container.start();20 Connection connection = container.createConnection("");21 }22}23import org.testcontainers.containers.JdbcDatabaseContainer;24import java.sql.Connection;25import java.sql.DriverManager;26import java.sql.SQLException;27public class Main {28 public static void main(String[] args) {29 JdbcDatabaseContainer container = new JdbcDatabaseContainer("mysql:5.7.22");30 container.start();31 Connection connection = container.createConnection("");32 }33}34import org.testcontainers.containers.JdbcDatabaseContainer;35import java.sql.Connection;36import java.sql.DriverManager;37import java.sql.SQLException;38public class Main {39 public static void main(String[] args) {40 JdbcDatabaseContainer container = new JdbcDatabaseContainer("mysql:5.7.22");41 container.start();42 Connection connection = container.createConnection("");43 }44}45import org.testcontainers.containers.JdbcDatabaseContainer;46import java.sql.Connection;47import java.sql.DriverManager;48import java.sql.SQLException;49public class Main {50 public static void main(String[] args) {51public class 1 {52 public static void main(String[] args) throws SQLException {53 JdbcDatabaseContainerProvider provider = new PostgreSQLContainerProvider();54 JdbcDatabaseContainer container = provider.newInstance("postgres:9.6.8");55 container.start();56 System.out.println(container.getJdbcUrl());57 System.out.println(container.getUsername());58 System.out.println(container.getPassword());59 Connection connection = container.createConnection("");60 System.out.println(connection);61 }62}63Connection: PostgreSQL JDBC Driver (version 42.2.5)
createConnection
Using AI Code Generation
1import org.testcontainers.containers.JdbcDatabaseContainer;2import org.testcontainers.containers.MySQLContainer;3import java.sql.Connection;4import java.sql.DriverManager;5import java.sql.SQLException;6import java.sql.Statement;7public class 1 {8 public static void main(String[] args) throws SQLException {9 JdbcDatabaseContainer container = new MySQLContainer("mysql:5.7.22");10 container.start();11 Connection connection = container.createConnection("");12 Statement statement = connection.createStatement();13 statement.execute("CREATE TABLE IF NOT EXISTS test (id int)");14 statement.close();
createConnection
Using AI Code Generation
1package org.testcontainers.containers;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.SQLException;5import java.sql.Statement;6import java.util.Properties;7public class JdbcDatabaseContainerTest {8 public static void main(String[] args) throws SQLException {9 try (MySQLContainer container = new MySQLContainer()) {10 container.start();11 Connection connection = container.createConnection("");12 Statement statement = connection.createStatement();13 statement.executeUpdate("CREATE TABLE test (id int)");14 statement.close();15 connection.close();16 }17 }18}19package org.testcontainers.containers;20import java.sql.Connection;21import java.sql.DriverManager;22import java.sql.SQLException;23import java.sql.Statement;24import java.util.Properties;25public class JdbcDatabaseContainerTest {26 public static void main(String[] args) throws SQLException {27 try (MySQLContainer container = new MySQLContainer()) {28 container.start();29 Connection connection = container.createConnection("");30 Statement statement = connection.createStatement();31 statement.executeUpdate("CREATE TABLE test (id int)");32 statement.close();33 connection.close();34 }35 }36}37package org.testcontainers.containers;38import java.sql.Connection;39import java.sql.DriverManager;40import java.sql.SQLException;41import java.sql.Statement;42import java.util.Properties;43public class JdbcDatabaseContainerTest {44 public static void main(String[] args) throws SQLException {45 try (MySQLContainer container = new MySQLContainer()) {46 container.start();47 Connection connection = container.createConnection("");48 Statement statement = connection.createStatement();49 statement.executeUpdate("CREATE TABLE test (id int)");50 statement.close();51 connection.close();52 }53 }54}55package org.testcontainers.containers;56import java.sql.Connection;57import java.sql.DriverManager;58import java.sql.SQLException;59import java.sql.Statement;60import java.util.Properties;61public class JdbcDatabaseContainerTest {62 public static void main(String[] args) throws SQLException {63 try (MySQLContainer container = new MySQLContainer()) {64 container.start();65 Connection connection = container.createConnection("");66 Statement statement = connection.createStatement();67 statement.executeUpdate("CREATE TABLE test (id int)");68 statement.close();
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.
LambdaTest Learning Hubs:
- JUnit Tutorial
- TestNG Tutorial
- Webdriver Tutorial
- WebDriverIO Tutorial
- Protractor Tutorial
- Selenium 4 Tutorial
- Jenkins Tutorial
- NUnit Tutorial
- Jest Tutorial
- Playwright Tutorial
- Cypress Tutorial
- PyTest Tutorial
YouTube
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Run Testcontainers-java automation tests on LambdaTest cloud grid
Perform automation testing on 3000+ real desktop and mobile devices online.
Most used method in JdbcDatabaseContainer
- Object
- JdbcDatabaseContainer
- getDriverClassName
- getJdbcUrl
- getDatabaseName
- getUsername
- getPassword
- getTestQueryString
- withUsername
- withPassword
- withDatabaseName
- withUrlParam
- withStartupTimeoutSeconds
- withConnectTimeoutSeconds
- withInitScript
- waitUntilContainerStarted
- containerIsStarted
- getJdbcDriverInstance
- createConnection
- constructUrlForConnection
- constructUrlParameters
- optionallyMapResourceParameterAsVolume
- runInitScriptIfRequired
- setParameters
- addParameter
- getStartupTimeoutSeconds
- getConnectTimeoutSeconds
- getDatabaseDelegate
- NoDriverFoundException
Try LambdaTest Now !!
Get 100 minutes of automation test minutes FREE!!
Was this article helpful?
