Java – JDBC Driver for SQL Server on Ubuntuの自動リトライ接続 No53

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Date;

public class ConSQLRetry2 {
    public static void main(String[] args) throws InterruptedException{
        Connection con = null;

        System.out.println("START: " + new Timestamp(new Date().getTime()));
        try {
            String connectionUrl = "jdbc:sqlserver://localhost:1433;" + "databaseName=TestDB;user=sa;password=Password;loginTimeout=30;socketTimeout=60000;queryTimeout=60;cancelQueryTimeout=60;connectRetryCount=3;connectRetryInterval=15;;encrypt=true;trustServerCertificate=true;";
            System.out.println("Connecting to SQL Server...: " + new Timestamp(new Date().getTime()));
            con = DriverManager.getConnection(connectionUrl);
        } catch (SQLException se) {
            System.out.println("Connection failed after several retries.");
            se.printStackTrace();
        }
        System.out.println("This connection ended - Current Timestamps 1: " + new Timestamp(new Date().getTime()));
    }
} 

START: 2022-06-24 10:23:00.906
Connecting to SQL Server...: 2022-06-24 10:23:00.913
This connection ended - Current Timestamps 1: 2022-06-24 10:23:01.488

START: 2022-06-24 10:24:07.665
Connecting to SQL Server...: 2022-06-24 10:24:07.692
Connection failed after several retries.
This connection ended - Current Timestamps 1: 2022-06-24 10:24:37.687
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1443 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:237)
	at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:288)
	at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2720)
	at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:761)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3180)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2833)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2671)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1640)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:936)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:270)
at ConSQLRetry2.main(ConSQLRetry2.java:15)