[QUESTION] Are the alias settings utilized as set in the SQL Server Native Client configuration?

[celliott-wdlp]

Question

I would like to use the alias settings as set within the SQL Server Native Client configuration for my application. However, I haven't been able to get it to work yet. I understand that the native client is old and deprecated. However, the settings are valid and used by other drivers. I tested with the latest SQL Server OLE driver - MSOLEDBSQL - and the alias settings are respected.

Does the mssql-jdbc driver use the alias settings? If so, what is the proper alias name to redirect the jdbc connection string? I understand how to redirect SSMS or a normal connection string from server1,port1 to server2,port2 via the alias, however I am not sure what text is needed in the alias to redirect jdbc:sqlserver://servername:port to a new servername and port. I tried to redirect both servername,port and servername:port without success. I tested with version com.microsoft.sqlserver:mssql-jdbc:9.4.0.jre11.

[tkyc]

Hi @celliott-wdlp, I'm afraid aliases are not support with the mssql-jdbc driver. I'll look into discussing this with the team as a potential enhancement.

[celliott-wdlp]

Thank you for confirming. This feature would be nice for enterprises like mine that need to redirect java applications to use a new server and port combination. We have hundreds of connection strings to update as part of an upcoming server migration.

[VladDBA]

Hello,
I'm not sure if you're taking votes on this, but I second @celliott-wdlp's statement about this being a very appreciated feature when it comes to easily redirecting java applications to newly migrated databases.
Thank you,

Vlad

[Jeffery-Wasty]

Hi @VladDBA,

Thank you, we'll take this into account during our next semester planning. Another place we look at to determine features to implement is our survey responses. You can find the survey here. Filling this out will also help us ensure this feature is properly planned and accounted for.

[VladDBA]

@Jeffery-Wasty, thank you!
I'll send the survey link to my colleagues.