Tag: Ubuntu

Java – Connect to SQL Server on Ubuntu No.5

Posted on by kumoman

In this blog, how to connect to SQL Server on Ubuntu using Java is shown. ▼1. What is SQL Server on Ubuntu SQL Server is Relational Database (RDB) provided by Microsoft. SQL Server works on both Windows and Linux. we can use free trial version which is called as “Express Edition” within 180 days. ▼2. How to connect to SQL Server on Ubuntu 2-1. Installing SQL Server on Ubuntu Quickstart: Install SQL Server and create a database on Ubuntu 2-2. Installing Microsoft JDBC Driver 8.2 for SQL Server Installing Microsoft JDBC Driver 8.2 for SQL Server (tar.gz) from Release notes for the Microsoft JDBC Driver for SQL Server Unzip tar –zxvf … Continue reading “Java – Connect to SQL Server on Ubuntu No.5”

Java -Retrieve data on Azure Cosmos DB (SQL API) No.15

Posted on by kumoman

In this blog, how to retrieve data on Azure Cosmos DB is shown. ▼1. Retrieve Data on Azure Cosmos DB (SQL API)  Using steam() and iterableByPage() in CosmosPagedIterable<T> class of com.azure.cosmos.util library, We can retrieve data on Cosmos DB. ▼2. Prerequisites 2-1. Free trial Cosmos DB account is available without subscription. https://azure.microsoft.com/ja-jp/try/cosmosdb/ 2-2. Enabling Maven auto-import in IntelliJ IDEA on Ubuntu Enable auto-import on IntelliJ IDEA No.13 2-3. Creating sample data Java – Create Database on Azure Cosmos DB (SQL API) Database No.14 ▼3. Java code to retrieve data on Cosmos DB (SQL API) 3-1. Creating Java code to find item Update the following parameters according to the setting on your environment … Continue reading “Java -Retrieve data on Azure Cosmos DB (SQL API) No.15”

Java – Download files from Azure Blob Storage No.27

Posted on by kumoman

In this blog, How to download files from Azure Blob Storage using Java is shown. ▼1. List file names and download files from Azure Blob Storage Using IntelliJ IDEA 2021.1.2 (Community Edition) on Ubuntu , Java application lists files on Azure Blob Storage and downloads these files. ▼2. Prerequisites 2-1. Installing Java 8 JDK Azul Zulu OpenJDK Java 8 (LTS) is supportable on Azure Service. steps of installation are shown in this document. Download Azul Zulu Builds of OpenJDK | Azul 2-2. Free trial Azure account for Azure Blob Storage Azure free account FAQ 2-3. Connecting to Azure Blob Storage using Azure Storage Explorer Creating Container and putting the file … Continue reading “Java – Download files from Azure Blob Storage No.27”

Java – Create Database on Azure Cosmos DB (SQL API) No.14

Posted on by kumoman

In this blog, how to create database on Azure Cosmos DB (SQL API) using Java is shown. ▼1. Some kinds of Azure Cosmos DB Azure Cosmos DB is NoSQL Database. there are some kinds of API below. Choose an API in Azure Cosmos DB ▼2. Prerequisites 2-1. Free trial Cosmos DB account is available without subscription. https://azure.microsoft.com/ja-jp/try/cosmosdb/ 2-2. Enable Maven auto-import in IntelliJ IDEA on Ubuntu Enable auto-import on IntelliJ IDEA No.13 ▼3. Creating Database , Container and Data on Cosmos DB (SQL API) の Database, Container by Java 3-1. Java Coding These parameters should be changed according to your setting on your environment. Family class is used to insert … Continue reading “Java – Create Database on Azure Cosmos DB (SQL API) No.14”

Java – Delete Data on Azure Cosmos DB (SQL API) No.18

Posted on by kumoman

How to delete data on Azure Cosmos DB SQL API is written in this blog. ▼1. Delete data on Azure Cosmos DB (SQL API) Multiple Items in container on Azure Cosmos DB (SQL API) will be deleted using CosmosContainer.<T>deleteItem of Java. ▼2. Prerequisites 2-1. Free trial Cosmos DB account is available without subscription. https://azure.microsoft.com/ja-jp/try/cosmosdb/ 2-2. Enable Maven auto-import in IntelliJ IDEA on Ubuntu Enable auto-import on IntelliJ IDEA No.13 2-3.  Using Azure Cosmos DB Java SDK v4 4.8.0 Adding dependency of a Cosmos DB library in pom.xml Azure Cosmos DB Java SDK v4 for Core (SQL) API: release notes and resources 2-4. Creating Database and container Java – Create Database … Continue reading “Java – Delete Data on Azure Cosmos DB (SQL API) No.18”

React – Visual Studio Code on Ubuntu No.77

Posted on by kumoman

I will show you the development of a web site using React in Visual Studio Code on Ubuntu. ▼1. What is React ? React is JavaScript library developed by Facebook for building user interfaces. the details is written in this document. React – A JavaScript library for building user interfaces (reactjs.org) ▼2. Prerequisites 2-1. Creating React application https://releases.ubuntu.com/20.04/ 2-2. Installing Visual Studio Code https://code.visualstudio.com/docs/setup/linux 2-3. Installing curl 2-4. Installing Node.js and npm W can install Node.js JavaScript runtime and npm using the following commands. Ref:distributions/README.md at master · nodesource/distributions (github.com)Download | Node.js (nodejs.org) ▼3. Deploying Web site 3-1. Creating a React application We can create a React application under the … Continue reading “React – Visual Studio Code on Ubuntu No.77”

Rust – Visual Studio Code on Ubuntu No.76

Posted on by kumoman

I will show you the execute Rust programming language in Visual Studio Code on Ubuntu. ▼1. What is Rust ? Rust is blazingly fast and memory-efficient without no runtime or garbage collector. Rust is memory-safety and thread-safety. we can use Rust on performance critical services. Ref: https://www.rust-lang.org/ These toolsets are installed when Rust is installed. ▼2. Prerequisites 2-1. Installing Ubuntu 20.04.2 LTS https://releases.ubuntu.com/20.04/ 2-2. Install Visual Studio Code https://code.visualstudio.com/docs/setup/linux 2-3. Installing Rust Install Rust using the command (Ref) https://www.rust-lang.org/learn/get-started 2-4. Installing rust-analyzer Extension ▼3. Print “Hello World!” using Rust 3-1. Creating Rust code to show Hello World in web site. We use Cargo command to create a project. 3-2. Starting … Continue reading “Rust – Visual Studio Code on Ubuntu No.76”

Java – Save the results of select query on SQL Server into Azure Blob Storage No.75

Posted on by kumoman

I will show Java code that save results of select query on SQL Server into Azure Blob Storage. ▼1. Copy data on SQL Server into Azure Blob Storage Azure Data Factory (ADF) is a good and easy way to copy data on SQL Server into Azure Blob Storage. please refer to this document. in this blog, I will show Java code to do it instead of ADF. Ref: Copy and transform data to and from SQL Server by using Azure Data Factory or Azure Synapse Analytics ▼2. Prerequisites We execute select query on SQL Server for Ubuntu. 2-1. Installation of SQL Server on Ubuntu Ref: Quickstart: Install SQL Server and … Continue reading “Java – Save the results of select query on SQL Server into Azure Blob Storage No.75”

Java – Save the results of select on Azure Cosmos DB SQL API into Azure Blob Storage No.74

Posted on by kumoman

I will show Java code that save results of select query as a JSON file into Azure Blob Storage. In the previous blog, I shared how to save results of select query on Cosmos DB as a JSON file into the local path. in this blog, I will save results into Azure Blob Storage. ▼1. Migration data from Cosmos DB to Azure Blob Storage We can migrate data from Cosmos DB to Azure Blob Storage using dt.exe or dtui.exe easily. this document is helpful for these migration. but I will share you how to migrate data on Azure Cosmos DB into Azure Blob Storage using Java. Ref:  Tutorial: Use Data … Continue reading “Java – Save the results of select on Azure Cosmos DB SQL API into Azure Blob Storage No.74”

Java – Azure Cosmos DB (SQL) : Save results of select into a JSON file No.73

Posted on by kumoman

I will show Java code that save results of select query into a JSON file. In the previous blog, I shared how to save results of select query on Cosmos DB into a text file. in this blog, I will save results into a JSON file. ▼1. What is a JSON format? The following data types are supported in JSON format. This is an example of a JSON file. Ref: JSON – Wikipedia { “Records”: [ { “id”: 1, “lastName”: “Travase”, “isRegistered”: false }, { “id”: 2, “lastName”: “Ken”, “isRegistered”: true }, { “id”: 3, “lastName”: “Sai”, “isRegistered”: false } ] } ▼2. Prerequisites 2-1. Free trial Azure Cosmos DB Account … Continue reading “Java – Azure Cosmos DB (SQL) : Save results of select into a JSON file No.73”