Python -Error handling & Retry in SQL Server on Ubuntu No.93

How to implement the error handling and retry with some interval in SQL Server on Ubuntu by Python is shown in this blog. Contents ▼1. Why do we need an error handling and an retry logic?▼2. Prerequisites▼3. Creating the Python code to implement the error handling & retry logic3-1. Developing a python code for an error handling and a retry logic3-2. Results for this code▼4. Reference▼1. Why do we need an error handling and an retry logic? We often use a cloud service and a remote service through the network. if the network intermittently cause something problems, the client application cannot access these services and will stop. to avoid this … Continue reading “Python -Error handling & Retry in SQL Server on Ubuntu No.93”

Java – Run a transactional query in SQL Server on Ubuntu No9

How to execute a transactional query in SQL Server on Ubuntu using Java is shown in this blog. Contents ▼1. How to execute a transactional query in SQL Server on Linux▼2. Implement insert query using transaction in SQL Server on Linux2-1. Creating Java code2-2. 実行結果▼3. Reference▼1. How to execute a transactional query in SQL Server on Linux Commit or Rollback by transaction can keep consistency of data when the query fails in the middle of the process. setAutoCommit method of SQLServerConnection class in JDBC Driver can use commit and rollback to implement a transactional query. ▼2. Implement insert query using transaction in SQL Server on Linux 2-1. Creating Java code … Continue reading “Java – Run a transactional query in SQL Server on Ubuntu No9”

Java – Error handling & Retry in SQL Server on Ubuntu No.6

How to implement the error handling and retry with some interval in SQL Server on Ubuntu by Java is shown in this blog. Contents ▼1. An error handling and a retry logic with interval are mandatory▼2. Creating Java code to implement Error handling & Retry logic2-1. Creating a Java code2-2. Results for this code▼3. Reference▼1. An error handling and a retry logic with interval are mandatory When we connect to cloud services, we often experience the intermittent network issue. in this case, an error handling and a retry logic with some interval are mandatory to keep application working on. ▼2. Creating Java code to implement Error handling & Retry logic … Continue reading “Java – Error handling & Retry in SQL Server on Ubuntu No.6”

Java -AutoRetry connection by JDBC Driver for SQLServer No53

How to implement auto retry with some internal by Java is shown in this blog. the connection string using Microsoft JDBC Driver for SQL Server “Connection String” has a feature of auto retry with some internal. Contents ▼1. Auto retry with some interval feature of Connection String of Microsoft JDBC Driver for SQL Server (Version 9.4 以上)▼2. Writing Java code to implement auto-retry when failing to connect to SQL Server2.2. Showing logs when the connection succeeded.2.3. Showing logs when the connection failed▼3. Reference▼1. Auto retry with some interval feature of Connection String of Microsoft JDBC Driver for SQL Server (Version 9.4 以上) As the mandatory setting for a cloud service, … Continue reading “Java -AutoRetry connection by JDBC Driver for SQLServer No53”

Java – Execute a Select query in SQL Server on Ubuntu No.8

How to run a select query in SQL Server on Ubuntu using Java is shown in this blog. Contents ▼1. Prerequisites▼2. Executing a query in SQL Server on Ubuntu by Java2-1. Creating Java code to execute Select query1-2. Results of this code▼2. Reference▼1. Prerequisites Creating a table “t1” in a database “TestDB” and inserting data intho this table are executed by sqlcmd utility. “sa” user is used in this sample. ▼2. Executing a query in SQL Server on Ubuntu by Java 2-1. Creating Java code to execute Select query 1-2. Results of this code Current Timestamps: 2020-05-26 06:52:10.564 [main] INFO ExecuteQSQLSvr – Connect to SQL Server successfully retrieve c1    c2 … Continue reading “Java – Execute a Select query in SQL Server on Ubuntu No.8”

Python – Creating sample data in SQL Server on Ubuntu No.62

How to create sample data in SQL Server on Ubuntu is shown in this blog. These steps are available for Windows OS, too. Contents ▼1. What is Microsoft SQL Server ?▼2. Prerequisites▼3. Creating sample data in bulk3-1. Preparation3-2. Developing “insertmultipledata.sql” to create sample data by python3-3. Executing the sql statement in “insertmultipledata.sql” by sqlcmd.exe3-4. Confirming the generated sample data using sqlcmd.exe▼4. Reference▼1. What is Microsoft SQL Server ? There are many kinds of SQL Server. for example, Azure SQL Database in cloud, Azure Synapse Analytics – SQL pool (SQL Data Warehouse) and on-premise SQL Server on Azure Virtual Machine (VM) etc We can find the version of SQL Server and hot … Continue reading “Python – Creating sample data in SQL Server on Ubuntu No.62”

Java – Put SQL Server select results into a csv file No.70

How to put results of select in SQL Server on Ubuntu into a csv file by Java is shown in this blog. Contents ▼1. Prerequisites1-1. Installing SQL Server1-2. Installing Visual Studio Code1-3. Installing Maven1-4. Generating sample data in SQL Server1-5. Executing a select query in SQL Server using Java▼2. Executing select statement in SQL Server and this results are put into a csv file using Java2-1.Creating a directory2-2. Creating a project using Apache Maven2-3. Deleting the existing App.java and AppTest.java2-4. Starting Visual Studio Code2-5. Updating pom.xml to use libraries of operations in SQL Server (Ctrl+S)2-6. Creating sqlsrvlocaloutput.java2-7. Confirming the csv file after executing this Java code▼3. Reference▼1. Prerequisites There are … Continue reading “Java – Put SQL Server select results into a csv file No.70”

Python – How to connect to SQL Server on Ubuntu  No.92

How to connect and run select query for a table in SQL Server on Ubuntu using Microsoft ODBC Driver for SQL Server by Python are shown in this blog. Contents ▼1. Connecting to SQL Server on Ubuntu▼2. Connecting to SQL Server and Select using Python2-1. Installing SQL Server on Linux2-2. Installing Microsoft ODBC Driver for SQL Server2-3. Creating a python code to connect to SQL Server on Linux and run Select2-4. Results of this python code when it work fine.▼3. Reference▼1. Connecting to SQL Server on Ubuntu In the past, how to connect and run queries using Java are shown in this blog as below. (As of 2022/12) ▼2. Connecting … Continue reading “Python – How to connect to SQL Server on Ubuntu  No.92”

Java – Update Statistics in SQL Server on Ubuntu No.91

How to update statistics for the table in SQL Server on Ubuntu by Java is shown in this blog. Contents ▼1. The latency of a query execution in SQL Server▼2. Prerequisites2-1. Reference Java – Creating sample data for SQL Server on Ubuntu No.89▼3. Updating statistics and re-generate a query execution plan by Java3-1. Creating a project using Apache Maven3-2. Deleting the existing App.java and AppTest.java files3-3. Starting Visual Studio Code3-4. Adding a library in pom.xml for the operation in SQL Server and saving pom.xml (Ctrl+S) 3-5. Creating sqlupdstat.java code3-6. The results of this Java code▼4. Reference▼1. The latency of a query execution in SQL Server We often see the latency … Continue reading “Java – Update Statistics in SQL Server on Ubuntu No.91”

Java – Creating sample data for SQL Server on Ubuntu No.89

In this blog, how to create sample records for SQL Server on Ubuntu using Java is shown. Contents ▼1. Creating sample data using Java▼2. Prerequisites2-1. Checking Java – Generating the sample data on SQL Server No.87 to execute below.▼3. Creating sample data for SQL Server by Java3-1. Create an Apache Maven project3-2. Remove the existed both App.java and AppTest.java3-3. Start Visual Studio Code3-4. Update pom.xml as below to run query on SQL Server and save it (Ctrl+S)3-5. Creating Java code sqlsample2.java3-6. Results of this code▼4. Reference▼1. Creating sample data using Java In the past blog, these blogs are shared. they use .sql file to create data by sqlcmd. In this … Continue reading “Java – Creating sample data for SQL Server on Ubuntu No.89”