Java DataSource getGlobalVariable(DataSource dataSource, String variable)

Description

Get global variable value.

License

Apache License

Parameter

Parameter	Description
dataSource	a parameter
variable	a parameter

Exception

Parameter	Description
SQLException	an exception

Return

global variable value of empty string.

Declaration

public static String getGlobalVariable(DataSource dataSource, String variable) throws SQLException 

Method Source Code

//package com.java2s;
/*//from ww  w . jav  a2  s.co m
 * Copyright 2017 StreamSets Inc.
 *
 * 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.
 */

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

public class Main {
    /**
     * Get global variable value.
     * @param dataSource
     * @param variable
     * @return global variable value of empty string.
     * @throws SQLException
     */
    public static String getGlobalVariable(DataSource dataSource, String variable) throws SQLException {
        try (Connection conn = dataSource.getConnection()) {
            try (Statement stmt = conn.createStatement();
                    ResultSet rs = stmt.executeQuery(String.format("show global variables like '%s'", variable));) {
                if (rs.next()) {
                    return rs.getString(2);
                } else {
                    return "";
                }
            }
        }
    }
}

Related

1. getDataSource(String jndi)
2. getDataSource(String jndiName)
3. getDataSource(String service)
4. getDataSourceCache(String hostName)
5. getDBConnection(DataSource dataSource)
6. getJdbcUrlFromDataSource(DataSource dataSource)
7. getJNDIConnectionByContainer(String dataSource)
8. getProductAllCount(DataSource ds, String key, String sql_allcount)
9. getSchemaSeparator(DataSource dataSource)