import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.*;
import com.siptech.security.webservice.*;

public class Sample
{

    public Sample()
    {
    }

    public static void main(String[] args) throws Exception {
	System.out.println("Inside Main of Sample ####");
	Sample.getConnectionToDatabase();
    }

    public static Connection getConnectionToDatabase()
        throws DatabaseConnectionException
    {
        Connection connection = null;
        try
        {
                System.out.println("Here");
		System.out.println("Database Driver :"+databaseDriver);
		System.out.println("Database Datasource :"+databaseDatasource);
		System.out.println("Database Login :"+databaseLogin);
		System.out.println("Database Password :"+databasePassword);

                Class.forName(databaseDriver);
                connection = DriverManager.getConnection(databaseDatasource, databaseLogin, databasePassword);
        }
        catch(Exception exception)
        {
         	exception.printStackTrace();   
       	} 
        return connection;
    }

    static String databaseLogin = "";
    static String databasePassword = "";
    static String databaseDriver = "";
    static String databaseDatasource = "";

    static 
    {
        try
        {
            ResourceBundle resourcebundle = ResourceBundle.getBundle("sipsecurityconfig", Locale.getDefault());
                databaseDriver = resourcebundle.getString("PostGRESQL_Database_Driver");
                databaseDatasource = resourcebundle.getString("PostGRESQL_Database_Datasource");
                databaseLogin = resourcebundle.getString("PostGRESQL_Database_Login");
                databasePassword = resourcebundle.getString("PostGRESQL_Database_Passord");
        }
        catch(MissingResourceException missingresourceexception)
        {
            System.err.println("Properties File not found");
        }
        catch(Exception exception)
        {
            System.err.println("Exception siploginconfig " + exception);
        }
    }
}