After upgrade JDBC from 6.4 to 12.8, Application failed to connect its database (AWS RDS MSSQL)

Anonymous
2025-01-29T04:17:47+00:00

Application , Java application running with Apache Tomcat 9.0.97

Database : AWS RDS MS SQL 2019 Standard edition , Always On

JDBC : 12.8

Symptom : when restart the application , there is following error and the application shutdown due to cannot connect to its database

Interim solution : adding transparentNetworkIPResolution=true or multiSubnetFailover=true into JDBC connection properties

However in Microsoft JDBC knowledge base Setting the connection properties - JDBC Driver for SQL Server | Microsoft Learn.

it mentioned, that " Beginning with Microsoft JDBC Driver 6.0 for SQL Server, it's no longer required to set multiSubnetFailover to "true" to connect to an availability group listener. A new property, transparentNetworkIPResolution, which is enabled by default, provides the detection of and connection to the (currently) active server.

if so , this sound a bug in JDBC 12.8??

Loading JCIFS configuration from: /app/AppSystems/config/jcifs.properties

Loading JNQ configuration from: /app/AppSystems/config/jnq.properties

java.lang.RuntimeException: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: The TCP/IP connection to the

host listener.mydatabase-mssqldb-rds.mx6ldguybgep.eu-west-2.rds.amazonaws.com, port xxxx

has failed. Error: "connect timed out. 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.appanywhere.ga.data.access.DataAccessLayerFactory.initDataSource(DataAccessLayerFactory.java:83)

    at com.appanywhere.ga.data.access.DataAccessLayerFactory.initSequenceDataSource(DataAccessLayerFactory.java:76)

    at com.appanywhere.ga.data.access.DataAccessLayerFactory.(DataAccessLayerFactory.java:58)

    at com.appanywhere.ga.core.system.DataFactory.initialize(DataFactory.java:219)

    at com.appanywhere.commons.stream.MemoizingSupplier.get(MemoizingSupplier.java:92)

    at com.appanywhere.ga.core.system.DataFactory.getConnection(DataFactory.java:143)

    at com.appanywhere.ga.core.system.DataFactory.getConnection(DataFactory.java:131)

    at com.appanywhere.ga.core.settings.SettingsController.getSettingsAsMap(SettingsController.java:544)

    at com.appanywhere.ga.core.settings.SettingsAPI.getAllSettingsAsMap(SettingsAPI.java:50)

    at com.appanywhere.dpa.DPASettings.loadSettings(DPASettings.java:1532)

    at com.appanywhere.dpa.DPASettings.load(DPASettings.java:766)

    at com.appanywhere.commons.stream.MemoizingSupplier.get(MemoizingSupplier.java:92)

    at com.appanywhere.dpa.DPASettings.initialize(DPASettings.java:772)

    at com.appanywhere.startup.TomcatStarter.start(TomcatStarter.java:328)

    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

    at java.base/java.lang.reflect.Method.invoke(Unknown Source)

    at com.appanywhere.bootstrap.AppAnywhereBootstrap.main(AppAnywhereBootstrap.java:82)

Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: The TCP/IP connection to the host

listener.mydatabase-mssqldb-rds.mx6ldguybgep.eu-west-2.rds.amazonaws.com, port xxxx has failed.

Error: "connect timed out. 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.".

    ... 14 more 

Application was shut down.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2025-01-29T13:43:24+00:00

    Hello,

    Thank you for posting in Microsoft Community forum.

    Based on the description, I understand your question is related to SQL Server

    Since there are no engineers dedicated to SQL Server in this forum. In order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

    Here is the link for Q&A forum.
    Questions - Microsoft Q&A

    Have a nice day.

    Best Regards,

    Hania Lian

    0 comments No comments