Method getUserIdFromName

src/main/java/dbProcs/Getter.java:1809–1832

@param ApplicationRoot The current running context of the application @param userName The username of the user @return The user id of the submitted user name

(String ApplicationRoot, String userName)

	 * @return The user id of the submitted user name
	 */
	public static String getUserIdFromName (String ApplicationRoot, String userName)
	{
		log.debug("*** Getter.getUserIdFromName ***");
		String result = new String();
		Connection conn = Database.getCoreConnection(ApplicationRoot);
		try
		{
			CallableStatement callstmt = conn.prepareCall("call userGetIdByName(?)");
			log.debug("Gathering userGetIdByName ResultSet");
			callstmt.setString(1, userName);
			ResultSet resultSet = callstmt.executeQuery();
			log.debug("Opening Result Set from userGetIdByName");
			resultSet.next();
			result = resultSet.getString(1);
		}
		catch (SQLException e)
		{
			log.error("Could not execute query: " + e.toString());
			result = null;
		}
		Database.closeConnection(conn);
		log.debug("*** END getUserIdFromName ***");
		return result;
	}
	
	/**
	 * @param ApplicationRoot The current running context of the application