DataSourceProvider.java

package org.utplsql.cli;

import org.utplsql.cli.datasource.TestedDataSourceProvider;

import javax.sql.DataSource;
import java.io.File;
import java.sql.SQLException;

/**
 * Helper class to give you a ready-to-use datasource
 *
 * @author pesse
 */
public class DataSourceProvider {

    static {
        String oracleHome = System.getenv("ORACLE_HOME");
        if (oracleHome != null && System.getProperty("oracle.net.tns_admin") == null) {
            System.setProperty("oracle.net.tns_admin",
                    String.join(File.separator, oracleHome, "NETWORK", "ADMIN"));
        }
    }

    public static DataSource getDataSource(String connectString, int maxConnections) throws SQLException {

        requireOjdbc();

        ConnectionConfig config = new ConnectionConfig(connectString);
        warnIfSysDba(config);

        return new TestedDataSourceProvider(config, maxConnections).getDataSource();
    }

    private static void requireOjdbc() {
        if (!OracleLibraryChecker.checkOjdbcExists()) {
            System.out.println("Could not find Oracle JDBC driver in classpath. Please download the jar from Oracle website" +
                    " and copy it to the 'lib' folder of your utPLSQL-cli installation.");
            System.out.println("Download from http://www.oracle.com/technetwork/database/features/jdbc/jdbc-ucp-122-3110062.html");

            throw new RuntimeException("Can't run utPLSQL-cli without Oracle JDBC driver");
        }
    }

    private static void warnIfSysDba(ConnectionConfig config) {
        if (config.isSysDba()) {
            System.out.println("WARNING: You are connecting to the database as SYSDBA or SYSOPER, which is NOT RECOMMENDED and can put your database at risk!");
        }
    }
}