package webchurch.push.util;

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

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class ConnectorPool {
	private Context context = null;
	private DataSource dataSource = null;
	public ConnectorPool(String dbName) {
		// TODO Auto-generated constructor stub
		try {
			context = new InitialContext();
			dataSource = (DataSource) context.lookup("java:comp/env/jdbc/Ms"+dbName);
		} catch (NamingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("Push Server Pool : fail to initialize DBCP ");
		}
		
	}
	
	
	public Connection getConnection(){
		Connection con = null; 
		try {
			con = dataSource.getConnection();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("Push Server Pool : fail to get Connection");
		}
		System.out.println("Push Server Pool : getConnection.");
		return con;
	}
	
}