org.kawanfw.sql.api.server.DataSourceStore Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aceql-http Show documentation

AceQL HTTP is a framework of REST like http APIs that allow to access to remote SQL databases over http from any device that supports http. AceQL HTTP is provided with four client SDK: - The AceQL C# Client SDK allows to wrap the HTTP APIs using Microsoft SQL Server like calls in their code, just like they would for a local database. - The AceQL Java Client SDK allows to wrap the HTTP APIs using JDBC calls in their code, just like they would for a local database. - The AceQL Python Client SDK allows SQL calls to be encoded with standard unmodified DB-API 2.0 syntax

There is a newer version: 12.2

Show newest version

/*
 * Copyright (c)2022 KawanSoft S.A.S. All rights reserved.
 * 
 * Use of this software is governed by the Business Source License included
 * in the LICENSE.TXT file in the project's root directory.
 *
 * Change Date: 2026-11-01
 *
 * On the date above, in accordance with the Business Source License, use
 * of this software will be governed by version 2.0 of the Apache License.
 */
package org.kawanfw.sql.api.server;

import java.util.Map;
import java.util.Set;
import java.util.concurrent.ConcurrentHashMap;

import javax.sql.DataSource;

import org.kawanfw.sql.servlet.injection.properties.ConfPropertiesStore;
import org.kawanfw.sql.tomcat.TomcatSqlModeStore;

/**
 * 
 * Allows to retrieve for each database the
 * {@code org.apache.tomcat.jdbc.pool.DataSource} corresponding to the Tomcat
 * JDBC Pool created at AceQL Web server startup. 

 * (Pools are defined in aceql-server.properties file, Tomcat JDBC Connection
 * Pool Section).
 * 
 * @author Nicolas de Pomereu
 *
 */
public class DataSourceStore {

    /**
     * Protected Constructor
     */
    protected DataSourceStore() {

    }

    /**
     * Method to be called by users servlets to get info on the JDBC Pool
     * DataSources created for each database. 

     * 

     * The {@link DefaultPoolsInfo} servlet with url-pattern
     * {@code /default_pools_info} is provided to query some info for of each
     * database {@code DataSource}. 

     * 
     * @return the the {@code Map} of {@code org.apache.tomcat.jdbc.pool.DataSource}
     *         per database
     */
    public static Map getDataSources() {
	Set databases = ConfPropertiesStore.get().getDatabaseNames();

	//TomcatStarterUtil.testDatabasesLimit(databases);
	
	Map dataSourceSet = new ConcurrentHashMap<>();

	if (databases == null || databases.isEmpty()) {
	    return dataSourceSet;
	}

	for (String database : databases) {
	    dataSourceSet.put(database, TomcatSqlModeStore.getDataSource(database));
	}
	return dataSourceSet;
    }

}