SNOW-3411310: Snowflake JDBC driver uses port 80 when using connections.toml

[sfc-gh-padhia]

❗ If you need urgent assistance then file a case with Snowflake Support.
Otherwise continue here.

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of JDBC driver are you using?
   4.1.0

2. What operating system and processor architecture are you using?
   MacOS, aarch64

3. What version of Java are you using?
   21.0.8

4. What did you do?

Running the following snippet using scala-cli reproduces the issue

//> using dep org.tpolecat::doobie-core::1.0.0-RC12
//> using dep net.snowflake:snowflake-jdbc:4.1.0
//> using javaOpt --add-opens=java.base/java.nio=ALL-UNNAMED

import cats.effect.*
import doobie.*
import doobie.syntax.all.*

object TestJDBC extends IOApp.Simple:
  val xa = Transactor.fromDriverManager[IO](
    "net.snowflake.client.jdbc.SnowflakeDriver",
    s"jdbc:snowflake:auto?connectionName=sample&tracing=WARNING&disablePlatformDetection=true",
    None
  )

  val run =
    sql"select current_user()"
      .query[String]
      .unique
      .transact(xa)
      .map(println)

5. What did you expect to see?
   Expected output: A successful output with value of current_user()

Relevant lines from the actual output

SEVERE: [requestId=66708a29-4953-49ee-a0a6-2ae0606a32f1] Stop retrying as max retries have been reached for request: POST https://xxxxx-xxxxx.snowflakecomputing.com:80/session/v1/login-request?databaseName=SNOWFLAKE_SAMPLE_DATA&schemaName=TPCH_SF1&warehouse=DEMO&roleName=SYSADMIN&requestId=66708a29-4953-49ee-a0a6-2ae0606a32f1 HTTP/1.1! Max retry count: 7
Apr 20, 2026 10:57:44 AM net.snowflake.client.internal.jdbc.RestRequest executeWithRetries
SEVERE: [requestId=66708a29-4953-49ee-a0a6-2ae0606a32f1] Returning null response. Cause: javax.net.ssl.SSLException: Unsupported or unrecognized SSL message, request: POST https://xxxxx-xxxxx.snowflakecomputing.com:80/session/v1/login-request?databaseName=SNOWFLAKE_SAMPLE_DATA&schemaName=TPCH_SF1&warehouse=ADHOC&roleName=SYSADMIN&requestId=66708a29-4953-49ee-a0a6-2ae0606a32f1 HTTP/1.1
net.snowflake.client.api.exception.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Unsupported or unrecognized SSL message.
        at net.snowflake.client.internal.jdbc.RestRequest.executeWithRetries(RestRequest.java:1085)

6. Can you set logging to DEBUG and collect the logs?

   https://community.snowflake.com/s/article/How-to-generate-log-file-on-Snowflake-connectors

   Before sharing any information, please be sure to review the log and remove any sensitive
   information.

[sfc-gh-dszmolka]

thanks for drawing attention to this bug, we're looking into it. (for future considerations, you can file it simply via an internal jira, don't necessarily need to go the full round of creating a GH issue first just to create a jira - but either way is good)

[sfc-gh-dszmolka]

fixed with #2591, pending next release, will update with release progress

[sfc-gh-dszmolka]

released with snowflake-jdbc v4.2.0