DatasourceExample.java

/*
 * Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License").
 * You may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package software.amazon;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import software.amazon.jdbc.ds.AwsWrapperDataSource;

public class DatasourceExample {
  private static final String USER = "username";
  private static final String PASSWORD = "password";

  public static void main(String[] args) throws SQLException {
    AwsWrapperDataSource ds = new AwsWrapperDataSource();

    ds.setJdbcProtocol("jdbc:postgresql:");

    // Specify the driver-specific data source:
    ds.setTargetDataSourceClassName("org.postgresql.ds.PGSimpleDataSource");

    // Configure basic data source information:
    ds.setServerName("db-identifier.cluster-XYZ.us-east-2.rds.amazonaws.com");
    ds.setDatabase("employees");
    ds.setServerPort("5432");

    // Configure the driver-specific and AWS JDBC Driver properties (optional):
    Properties targetDataSourceProps = new Properties();

    // Alternatively, instead of using the methods above to configure the basic data source information,
    // those properties can be set using the target data source properties:
    // targetDataSourceProps.setProperty("serverName", "db-identifier.cluster-XYZ.us-east-2.rds.amazonaws.com");
    // targetDataSourceProps.setProperty("database", "employees");
    // targetDataSourceProps.setProperty("serverPort", "5432");

    // Configure any driver-specific properties:
    targetDataSourceProps.setProperty("ssl", "true");

    // Configure any AWS JDBC Driver properties:
    targetDataSourceProps.setProperty("wrapperLoggerLevel", "ALL");

    ds.setTargetDataSourceProperties(targetDataSourceProps);

    // Try and make a connection:
    try (final Connection conn = ds.getConnection(USER, PASSWORD);
        final Statement statement = conn.createStatement();
        final ResultSet rs = statement.executeQuery("SELECT * FROM employees")) {
      System.out.println(Util.getResult(rs));
    }
  }
}