package com.nsi.persistence;

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

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

import com.nsi.util.settings.SystemSettings;

public class PoolingDataSrc extends DataSrcImpl
{
	public PoolingDataSrc()
	{
	}
	/**
	 * @see com.nsi.persistence.IsqlDataSource#getConnection()
	 */
	public Connection getConnection() throws Exception, SQLException
	{
		Context initCtxt = new InitialContext();
		Context envCtxt = ( Context )initCtxt.lookup("java:/comp/env");
		String jndiName = SystemSettings.getInstance().getDBDataSourceName();
		DataSource ds = ( DataSource )envCtxt.lookup(jndiName);
		Connection conn = ds.getConnection();
		return conn;
	}
	
	/**
	 * @see com.nsi.persistence.IsqlDataSource#getConnection()
	 */
	public Connection getConnection(String dbType) throws Exception, SQLException
	{
		Context initCtxt = new InitialContext();
		Context envCtxt = ( Context )initCtxt.lookup("java:/comp/env");
		String jndiName = SystemSettings.getInstance().getMSSQLDBDataSourceName();
		DataSource ds = ( DataSource )envCtxt.lookup(jndiName);
		Connection conn = ds.getConnection();
		return conn;
	}
	
}