MS Sql connections and LDAP Connections appear twice

[CommunityUser]

Hi,

I am using Lit 4 Java.

I have several JDBC connection (Sybase, Oracle and MSSQL Server).

All is ok with Sybase and Oracle, but with MS SQL Server, my connection appears twice, one time with a name "XXX-MS SQL Server", and another time with "XXX-Microsoft SQL Server".

All the parameters (Host, Port, Schema, MajorVersion and URL) are the same between both connection but the vendor.

I found several place where the "Microsoft SQL Server" is coded :

* com.microsoft.sqlserver.jdbc.Util.nameAndVersion()

* com.microsoft.sqlserver.jdbc.SQLServerDriver.getPropertyInfo()

* com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getDatabaseProductName()

* com.microsoft.sqlserver.jdbc.SQLServerDataSource.getApplicationName()

But nowhere with the text "MS SQL Server".

Where does this name came from ? How can I have only one conneciton ?

We use the driver sqljdbc-1.2.jar

I have a same problem with LDAP request my connection appear 3 times with the names : "LDAP NamingEnumeration GetNextBatch", "LDAP NamingEnumeration NextAux" and "LDAP Search".

[Arun_Dasetty]

Hi,

Thanks for writing into appsphere community forum. We see such issues when any of the host, url, vendor , port and schema property values varies for same database(ms sql, oracle etc) as you have mentioned, In lite we do not have option to configure backend naming where we disable "vendor" property in default backend naming config to resolve such issues, which is available in pro version of the product, let us know if any disconnect.

refere docs: http://docs.appdynamics.com/display/PRO13S/Configure+Backend+Detection

Regarding LDAP can you please confirm whether you have customized any settings and let us know if customizing backend naming config helps

Thanks,

Arun

[CommunityUser]

Hi,

They didn't vary, they are defined only once in the DataSource.

Do you have some variation in the getting of vendor name.

I can't access to your documentation, my account is not authorized.

Why do you protect the documentation ? It's not very attractive to discover the full features of the Pro Version.

Philippe

[Arun_Dasetty]

Hi,

Please find the answers to your queries inline:

>>>>>. They didn't vary, they are defined only once in the DataSource. Do you have some variation in the getting of vendor name.

Answer: Database naming or backend detection will vary in UI based on the database driver used by the web application, let us know if there are different db drivers using in your application. Vendor name details may vary based on the database used. (Ex: vendor name may show as "MS" for a lower driver version and it might return as "Microsoft sql server" for higher version hence we see difference,

>>>>>>>.  I can't access to your documentation, my account is not authorized.

Why do you protect the documentation ? It's not very attractive to discover the full features of the Pro Version.

Answer:  we request you to register an account and get 30 day free pro trial, once you have free trial you should be able to access docs.

http://info.appdynamics.com/freetrial.html

Please let us know if that clarifies your queries

Thanks,

Arun

[CommunityUser · Accepted solution]

I found another driver jar for MSSql.

I removed it and it seems to resolve my duplication even I can't find any 'MS' String in those driver.

Thanks for you help,

Philippe