Java - Test Containers for Oracle

About

Example on how to use OracleContainer Xe of Test container.

Usage

There is two usage:

• via container instantation
• or via a modification of the Jdbc url

Via OracleContainer instantiation

The OracleContainer instantiation can be scoped:

• to a class (or a test)
• to the run (singleton)

in a test class

@ClassRule
public static OracleContainer oracle = new OracleContainer("wnameless/oracle-xe-11g-r2")
	.withUsername("system")
	.withPassword("oracle")
	.withExposedPorts(1521)
	.withEnv("ORACLE_ALLOW_REMOTE", "true");

@BeforeClass
public static void setUp() {
  String url = oracle.getJdbcUrl();
  String username =oracle.getUsername();
  String password = oracle.getPassword();
  // Make your connection
}

a singleton

Doc

• instantiate it as a static field

public abstract class OracleTestContainer {

  static final OracleContainer ORACLE_CONTAINER;

  static {
    ORACLE_CONTAINER = new OracleContainer("wnameless/oracle-xe-11g-r2")
      .withUsername("system")
      .withPassword("oracle")
      .withExposedPorts(1521)
      .withEnv("ORACLE_ALLOW_REMOTE", "true");
  }

}

• and use it in the test

@Test
public static void setUp() {
  String url = ORACLE_CONTAINER.getJdbcUrl();
  String username =ORACLE_CONTAINER.getUsername();
  String password = ORACLE_CONTAINER.getPassword();
  // Make your connection
}

Via JDBC URL modification

In this case, you just modify the Jdbc Url and use your code as it. You do it in tow steps

• Define the image in the test Container properties file

oracle.container.image=wnameless/oracle-xe-11g-r2

• Modify the url in your code by adding tc and removing the host and port

@BeforeClass
public static void setUp() {
  String url = "jdbc:tc:oracle:thin:@///ORCL";
  String username = "system";
  String password = "oracle";
  // Make your connection
}