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 – Connection String of Microsoft JDBC Driver for SQL Server No.7

Posted on by kumoman

I would like to share the detail of connection string of JDBC Driver for SQL Server in this blog. ▼1. Connection String of Microsoft JDBC Driver for SQL Server Connection String contains login timeout, socket timeout,query timeout, query timeout, authentication way and application name etc. ▼2. Example for the connection string of JDBC Driver for SQL Server We can avoid intermittent connection issue by implementing timeout, retry and interval of retry etc. This is an example for the connection string of Microsoft JDBC Driver for SQL Server. ▼3. Reference That’s all. Have a nice day ahead !!!

Enable auto-import on IntelliJ IDEA No.13

Posted on by kumoman

I would like to show how to enable auto-import on IntelliJ IDEA to load libraries automatically. ▼1. Setting to load the relevant libraries automatically 1-1. Enable Maven auto-import on IntelliJ IDEA We can find this icon from View -> Tool Windows -> Maven menu as blow. And then, we can choose “Enable auto-reload after any changes” after clicking “Toggle Auto Reload Mode”. 1.2. Check if you could confirm downloaded libraries after this settings After you add the following dependencies in Pom.xml and save pom.xml, you can find downloaded libraries from File -> Project Structure -> Project Settings -> Libraries I checked above setting on the following IntelliJ IDEA version before. IntelliJ … Continue reading “Enable auto-import on IntelliJ IDEA No.13”

Robo Advisor – WealthNavi: My performance review of investments No.17

Posted on by kumoman

I will show the result of performance on Nov 2022 about my Robo Advisor WealthNavi in this blog. https://corp.wealthnavi.com/en Here is a public result of the investment performance by WealthNavi. https://www.wealthnavi.com/performance/data In my case, Risk 3 is chosen. as the result of it, Percentage change is +50% What is the result of my investments by Robo Advisor – WealthNavi on Nov 2022? Before answering this question, I will provide you my history of this investment. For now, the result of my investment on Nov 2022 is here. Down from the public performance by WealthNavi! About Portofolio At last, I will show the results of my investments using Tumitate NISA in … Continue reading “Robo Advisor – WealthNavi: My performance review of investments No.17”