MySQLProperties.java

/*
 * This file is part of Waarp Project (named also Waarp or GG).
 *
 *  Copyright (c) 2019, Waarp SAS, and individual contributors by the @author
 *  tags. See the COPYRIGHT.txt in the distribution for a full listing of
 * individual contributors.
 *
 *  All Waarp Project is free software: you can redistribute it and/or
 * modify it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or (at your
 * option) any later version.
 *
 * Waarp is distributed in the hope that it will be useful, but WITHOUT ANY
 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
 * A PARTICULAR PURPOSE. See the GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License along with
 * Waarp . If not, see <http://www.gnu.org/licenses/>.
 */

package org.waarp.common.database.properties;

import io.netty.util.internal.PlatformDependent;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import static org.waarp.common.database.model.DbModelMysql.*;

/**
 * MySQL Database Model
 */
public class MySQLProperties implements DbProperties {
  public static final String PROTOCOL = "mysql";

  private static final String VALIDATION_QUERY = "select 1";

  private final String driverName;

  public MySQLProperties() {
    if (PlatformDependent.javaVersion() >= 8) {
      String driver = MYSQL_DRIVER_JRE6;
      try {
        Class.forName(MYSQL_DRIVER_JRE8);
        driver = MYSQL_DRIVER_JRE8;
      } catch (final Exception e) {
        driver = MYSQL_DRIVER_JRE6;
      } finally {
        driverName = driver;
      }
    } else {
      driverName = MYSQL_DRIVER_JRE6;
    }
  }

  public static String getProtocolID() {
    return PROTOCOL;
  }

  @Override
  public String getDriverName() {
    return driverName;
  }

  @Override
  public String getValidationQuery() {
    return VALIDATION_QUERY;
  }

  @Override
  public int getMaximumConnections(final Connection connection)
      throws SQLException {
    Statement stm = null;
    ResultSet rs = null;
    try {
      stm = connection.createStatement();
      rs = stm.executeQuery("SELECT @@GLOBAL.max_connections");
      if (!rs.next()) {
        throw new SQLException("Cannot find max connection");
      }
      return rs.getInt(1);
    } finally {
      if (rs != null) {
        try {
          rs.close();
        } catch (final SQLException ignored) {
          // nothing
        }
      }
      if (stm != null) {
        try {
          stm.close();
        } catch (final SQLException ignored) {
          // nothing
        }
      }
    }
  }
}