I have a Spring Boot (2.7.6) / Java (8) application that's creating a SQL Server JDBC data source, that gets a valid connection. But, whenever I get the connection from the data source to select some data I get the following lines in my log file:
Attempting to get a test connection.
c.microsoft.aad.msal4j.WSTrustResponse : Found token of type: urn:oasis:names:tc:SAML:1.0:assertion
com.microsoft.aad.msal4j.HttpHelper : [Correlation ID: null] Sent (null) Correlation Id is not same as received (null).
com.microsoft.aad.msal4j.HttpHelper : [Correlation ID: null] Sent (null) Correlation Id is not same as received (cb6846d3-895e-4693-87e0-f72ef3262fd1)
Got a connection!!!!
I'm running the code locally, and connecting to a PAAS SQL Server DB running in a cloud. Here are the pertinent lines of code used to create the data source:
com.microsoft.sqlserver.jdbc.SQLServerDataSource ss = new com.microsoft.sqlserver.jdbc.SQLServerDataSource();
ss.setUser(dbUser);
ss.setPassword(AESUtility.decrypt(dbPassword));
ss.setServerName(dbServername);
ss.setDatabaseName(dbDatabasename);
ss.setPortNumber(Integer.parseInt(dbPortNumber));
ss.setAuthentication("ActiveDirectoryPassword");
ss.setEncrypt("true");
ss.setTrustServerCertificate(true);
System.out.println("Attempting to get a test connection.");
connection = ss.getConnection();
System.out.println("Got a connection!!!!");
The JDBC driver is version:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>11.2.1.jre8</version>
</dependency>