software.amazon.jdbc.targetdriverdialect.MariadbDriverHelper Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of aws-advanced-jdbc-wrapper Show documentation
Amazon Web Services (AWS) Advanced JDBC Wrapper
There is a newer version: 2.5.2
Show newest version
/*
 * 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.jdbc.targetdriverdialect;

import static software.amazon.jdbc.util.ConnectionUrlBuilder.buildUrl;

import com.mysql.cj.jdbc.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Collections;
import java.util.Properties;
import java.util.concurrent.TimeUnit;
import java.util.logging.Logger;
import javax.sql.DataSource;
import org.checkerframework.checker.nullness.qual.NonNull;
import org.mariadb.jdbc.MariaDbDataSource;
import org.mariadb.jdbc.MariaDbPoolDataSource;
import software.amazon.jdbc.HostSpec;
import software.amazon.jdbc.PropertyDefinition;
import software.amazon.jdbc.util.Messages;
import software.amazon.jdbc.util.PropertyUtils;

public class MariadbDriverHelper {

  private static final Logger LOGGER =
      Logger.getLogger(MariadbDriverHelper.class.getName());

  private static final String LOGIN_TIMEOUT = "loginTimeout";
  private static final String DS_CLASS_NAME = MariaDbDataSource.class.getName();
  private static final String DS_CP_CLASS_NAME = MariaDbPoolDataSource.class.getName();

  public void prepareDataSource(
      final @NonNull DataSource dataSource,
      final @NonNull String protocol,
      final @NonNull HostSpec hostSpec,
      final @NonNull Properties props) throws SQLException {

    if (dataSource instanceof MariaDbDataSource) {
      final MariaDbDataSource mariaDbDataSource = (MariaDbDataSource) dataSource;

      mariaDbDataSource.setUser(PropertyDefinition.USER.getString(props));
      mariaDbDataSource.setPassword(PropertyDefinition.PASSWORD.getString(props));

      final String loginTimeoutValue = props.getProperty(LOGIN_TIMEOUT, null);
      if (loginTimeoutValue != null) {
        mariaDbDataSource.setLoginTimeout(Integer.parseInt(loginTimeoutValue));
        props.remove(LOGIN_TIMEOUT);
      }

      Integer loginTimeout = PropertyUtils.getIntegerPropertyValue(props, PropertyDefinition.LOGIN_TIMEOUT);
      if (loginTimeout != null) {
        mariaDbDataSource.setLoginTimeout((int) TimeUnit.MILLISECONDS.toSeconds(loginTimeout));
      }

      // keep unknown properties (the ones that don't belong to AWS Wrapper Driver)
      // and include them to connect URL.
      PropertyDefinition.removeAllExcept(props,
          PropertyDefinition.DATABASE.name,
          PropertyDefinition.TCP_KEEP_ALIVE.name,
          PropertyDefinition.CONNECT_TIMEOUT.name,
          PropertyDefinition.SOCKET_TIMEOUT.name);

      String finalUrl = buildUrl(protocol, hostSpec, props);
      LOGGER.finest(() -> "Connecting to " + finalUrl);
      mariaDbDataSource.setUrl(finalUrl);

    } else if (dataSource instanceof MariaDbPoolDataSource) {

      final MariaDbPoolDataSource mariaDbPoolDataSource = (MariaDbPoolDataSource) dataSource;

      mariaDbPoolDataSource.setUser(PropertyDefinition.USER.getString(props));
      mariaDbPoolDataSource.setPassword(PropertyDefinition.PASSWORD.getString(props));

      final String loginTimeoutValue = props.getProperty(LOGIN_TIMEOUT, null);
      if (loginTimeoutValue != null) {
        mariaDbPoolDataSource.setLoginTimeout(Integer.parseInt(loginTimeoutValue));
        props.remove(LOGIN_TIMEOUT);
      }

      Integer loginTimeout = PropertyUtils.getIntegerPropertyValue(props, PropertyDefinition.LOGIN_TIMEOUT);
      if (loginTimeout != null) {
        mariaDbPoolDataSource.setLoginTimeout((int) TimeUnit.MILLISECONDS.toSeconds(loginTimeout));
      }

      // keep unknown properties (the ones that don't belong to AWS Wrapper Driver)
      // and include them to connect URL.
      PropertyDefinition.removeAllExcept(props,
          PropertyDefinition.DATABASE.name,
          PropertyDefinition.TCP_KEEP_ALIVE.name,
          PropertyDefinition.CONNECT_TIMEOUT.name,
          PropertyDefinition.SOCKET_TIMEOUT.name);

      String finalUrl = buildUrl(protocol, hostSpec, props);
      LOGGER.finest(() -> "Connecting to " + finalUrl);
      mariaDbPoolDataSource.setUrl(finalUrl);

    } else {
      throw new SQLException(Messages.get(
          "TargetDriverDialectManager.unexpectedClass",
          new Object[] { DS_CLASS_NAME + ", " + DS_CP_CLASS_NAME, dataSource.getClass().getName() }));
    }
  }

  public boolean isDriverRegistered() throws SQLException {
    return Collections.list(DriverManager.getDrivers())
        .stream()
        .filter(x -> x instanceof org.mariadb.jdbc.Driver)
        .map(x -> true)
        .findAny()
        .orElse(false);
  }

  public void registerDriver() throws SQLException {
    try {
      DriverManager.registerDriver(new org.mariadb.jdbc.Driver());
    } catch (SQLException e) {
      throw new SQLException(Messages.get("MariadbDriverHelper.canNotRegister"), e);
    }
  }
}