MS SQLServer JDBC Parameter "appName=<project name>"

[drosemeyer]

Hello,

on tracing my job I noticed that

parameter "appName=<project name>" was added to the jdbc connection

string automatically to show the project name in SQL Server activity monitor.

But the correct name of the parameter is “applicationName=<projectname>"

I’m using MS SQLServer 2016 and 2019 with MS jdbc driver 10.2.

Is there a way to correct this?

Regards Dirk

[Anonymous]

Hi

What problem could this parameter cause? This parameter is added to connection string automatically, the parameter name can be modified from the source file of component,

url_<%=cid%> += ";appName=" + projectName + ";" + <%=dbproperties%>;

  String dbschema_<%=cid%> = <%=dbschema%>;

if you think that it is a bug, please open a jira issue with our R&D team for further investigation.

Regards

Shong

[drosemeyer]

Hi,

this parameter does not cause any problems, but if it does not work it is useless.

So from my point of view it should be corrected or dropped in one of the next releases.

But thanks for the hint.

I also found out, that it can be added as additional parameter in jdbc url.