Method getCoreConnection

src/main/java/dbProcs/Database.java:95–127

Returns connection to core schema in database @param ApplicationRoot @return Connection to core schema with admin privileges

(String ApplicationRoot)

	 * @return Connection to core schema with admin privileges
	 */
	public static Connection getCoreConnection(String ApplicationRoot)
	{
	   Connection conn = null;
	   try
	   {
		   //log.debug("Getting Prop File");
		   //Pull Driver and DB URL out of database.properties
		   
		   String props = Constants.DBPROP;
		   
		   //log.debug("Getting Driver");
		   String DriverType = FileInputProperties.readfile(props, "DriverType");
		   //log.debug("Getting Driver Instance");
		   Class.forName(DriverType).newInstance();
		   String connectionURL=FileInputProperties.readfile(props, "databaseConnectionURL");
		   
		   //Pull Schema, User name and Password from SqlInjLesson.properties
		   
		   //log.debug("Reading Prop File");
		   connectionURL= connectionURL + FileInputProperties.readfile(props, "databaseSchema");
		   String username=FileInputProperties.readfile(props, "databaseUsername");
		   String password=FileInputProperties.readfile(props, "databasePassword");
		   
		   //log.debug("Creating Connection to DB");
		   conn = DriverManager.getConnection(connectionURL,username,password);
	   }
	   catch(Exception e)
	   {
		   log.fatal("Unable to create database connection: " + e);
		   e.printStackTrace();
	   }
	   return conn;
	}
	
	 public static Connection getDatabaseConnection(String ApplicationRoot) {
		 return getDatabaseConnection(ApplicationRoot, false);