Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Incomplete
-
2.4.3
-
None
-
Test Case
jars for ms sql client
adal4j 1.6.4
oauth2-oidc-sdk 6.16.2
json-smart 2.3
nimbus-jose-jwt 7.9
mssql-jdbc 7.4.0.jre8
Slow JDBC URL using AD
"jdbc:sqlserver://<SERVER NAME>:1433;database=<DB NAME>;user=<AD USERNAME>;password=<PASSWORD>;encrypt=true;ServerCertificate=false;trustServerCertificate=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword"
URL For Expect Performance Using SQL Server Account
"jdbc:sqlserver://<SERVER NAME>:1433;database=<DB NAME>;user=<SS USERNAME>;password=<PASSWORD>;encrypt=true;ServerCertificate=false;trustServerCertificate=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=sqlPassword"
Test Case jars for ms sql client adal4j 1.6.4 oauth2-oidc-sdk 6.16.2 json-smart 2.3 nimbus-jose-jwt 7.9 mssql-jdbc 7.4.0.jre8 Slow JDBC URL using AD "jdbc:sqlserver://<SERVER NAME>:1433;database=<DB NAME>;user=<AD USERNAME>;password=<PASSWORD>;encrypt=true;ServerCertificate=false;trustServerCertificate=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPassword" URL For Expect Performance Using SQL Server Account "jdbc:sqlserver://<SERVER NAME>:1433;database=<DB NAME>;user=<SS USERNAME>;password=<PASSWORD>;encrypt=true;ServerCertificate=false;trustServerCertificate=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=sqlPassword"
Description
When creating a dataframe via JDBC from MS SQL Server performance is so bad to be unusable when authentication was performed with Active Directory. When authentication is using SQL Server account performance is as expected. Created a java that that connected to the same Azure SQL database via Active Directory account and performance was the as Sql Server account. When connecting via Active Directory it could 30 minutes to 1 hour to read a 250 row table compared to 5 seconds using SQL Server account or using a console Java app connecting via AD.