/**
 *    '$RCSfile: DatabaseConnectionPoolFactory.java,v $'
 *
 *     '$Author: leinfelder $'
 *       '$Date: 2007/10/05 21:10:17 $'
 *   '$Revision: 1.1 $'
 *
 *  For Details: http://kepler.ecoinformatics.org
 *
 * Copyright (c) 2003 The Regents of the University of California.
 * All rights reserved.
 * 
 * Permission is hereby granted, without written agreement and without
 * license or royalty fees, to use, copy, modify, and distribute this
 * software and its documentation for any purpose, provided that the
 * above copyright notice and the following two paragraphs appear in
 * all copies of this software.
 * 
 * IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY
 * FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES
 * ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN
 * IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY
 * OF SUCH DAMAGE.
 * 
 * THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
 * INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
 * MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE
 * PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY
 * OF CALIFORNIA HAS NO OBLIGATION TO PROVIDE MAINTENANCE, SUPPORT,
 * UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
 */
package edu.ucsb.nceas.metacat.dataquery;

import edu.ucsb.nceas.metacat.properties.PropertyService;

import java.sql.Connection;
import java.sql.SQLException;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.ecoinformatics.datamanager.database.ConnectionNotAvailableException;
import org.ecoinformatics.datamanager.database.DatabaseConnectionPoolInterface;

/**
 * This class provides an implementation of DataConnetionPoolInterface 
 * Implementation and database information for this class will be read from property file.
 * 
 * @author leinfelder
 * 
 */
public class MetacatDatabaseConnectionPoolFactory {
	
	public static Log log = LogFactory.getLog(MetacatDatabaseConnectionPoolFactory.class);
	
	private static String implementationClass = null;
		
	static {
		loadOptions();
	}
	
	/**
	 * Constructor. Loading database parameter from property file
	 * 
	 */
	public MetacatDatabaseConnectionPoolFactory() {
	}

	/**
	 * Loads Data Manager options from a configuration file.
	 */
	private static void loadOptions() {
		try {
			implementationClass = PropertyService.getProperty("datamanager.implementation");
		} 
		catch (Exception e) {
			log.error("Error in loading options: " + e.getMessage());
		}
	}

	public static DatabaseConnectionPoolInterface getDatabaseConnectionPoolInterface() {
		DatabaseConnectionPoolInterface instance = null;
		try {
			instance = 
				(DatabaseConnectionPoolInterface) Class.forName(implementationClass).newInstance();
		} catch (Exception e) {
			log.error(e.getMessage() 
					+ ": could not create DatabaseConnectionPoolInterface implementation: " 
					+ implementationClass);
			e.printStackTrace();
		} 
		
		return instance;

	}

	public static void main(String arg[]) {
		Connection conn = null;
		try {
			conn = MetacatDatabaseConnectionPoolFactory.getDatabaseConnectionPoolInterface().getConnection();
			log.debug("conn=" + conn);
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ConnectionNotAvailableException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}