package com.vci.server.base.dbutil;

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

import javax.sql.DataSource;

public final class DBPoolManagement {

private static DataSource _myDataSource = null;
	
	static 
	{
		if ( _myDataSource == null )
		{
			DBPoolInit dbpi = new DBPoolInit();
			dbpi.InitProperties("");
			try
			{
				_myDataSource = dbpi.getDBPool();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
		}		
	}

	public  static Connection getConnection() 
		throws SQLException
	{
	    Connection conn = null;
	    try 
		{
	    	conn = _myDataSource.getConnection();
	    }
	    catch (SQLException error) 
		{
	      error.printStackTrace();
	    }
	    return conn;
	}
}