Connecting to Azure Data Explorer with JDBC

Machiri Marodi 0

I am trying to connect to Azure Data Explorer with JDBC using MATLAB but I keep running into the error shown in the insert below. A little bit of googling revealed that this issue could potentially be resolved by "opening port 443 and the necessary endpoints to obtain the Azure Active Directory token" (Execution of class com.microsoft.aad.adal4j.AcquireTokenCallable failed), Port 443 is open and the mssql-jdbc (7.0.0-jre8) and adal4j (1.6.3) jar files, and all of their dependencies have been downloaded and added to dynamic java path. Does anyone have any idea what could be causing this error?

PRADEEPCHEEKATLA-MSFT 84,051 Reputation points Microsoft Employee

2024-03-14T10:30:05.67+00:00

@Machiri Marodi - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

PRADEEPCHEEKATLA-MSFT 84,051 Reputation points Microsoft Employee

2024-03-01T04:50:25.6633333+00:00
@Machiri Marodi - Thanks for the question and using MS Q&A platform.

Based on the error message you provided, it seems like you have already taken some steps to resolve the issue by opening port 443 and downloading the necessary jar files. However, there could be other reasons why you are still encountering this error.

Here are a few things you could try to troubleshoot the issue:

Double-check that you have correctly configured the connection string for Azure Data Explorer in your MATLAB code. Make sure that you have specified the correct server name, database name, and authentication details.

Check that you have the correct version of the mssql-jdbc jar file. You can try downloading the latest version from the official Microsoft website.

Make sure that you have the correct version of the adal4j jar file. You can try downloading the latest version from the official GitHub repository.

Check that you have the necessary permissions to access Azure Data Explorer. You may need to check with your Azure administrator to ensure that you have the correct permissions.

Try running your MATLAB code on a different machine to see if the issue persists. This could help you determine if the issue is specific to your current environment.

If none of these steps resolve the issue, it may be helpful to provide more information about the error message you are seeing, such as the full stack trace. This could help identify the root cause of the issue.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Machiri Marodi 0 Reputation points

2024-03-01T06:27:08.6966667+00:00

Hi @PRADEEPCHEEKATLA-MSFT

Thanks for the quick response and information.

Which permissions do I need to access Azure Data Explorer exactly? The administrator just shared a link with me to the database but I don't know which permissions I have at the moment, is there a quick way to check this?

Here is the full full stack trace when using the database toolbox in MATLAB to establish a connection to Azure Data Explorer:

18:47:01.155 [pool-19-thread-1] ERROR com.microsoft.aad.adal4j.AuthenticationContext - [Correlation ID: f1e99947-e93d-4efc-bdc6-ecc721dbfaea] Execution of class com.microsoft.aad.adal4j.AcquireTokenCallable failed.

java.net.ConnectException: Connection timed out: connect

at java.net.DualStackPlainSocketImpl.connect0(Native Method) ~[?:1.8.0_202] at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79) ~[?:1.8.0_202] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0_202] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0_202] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0_202] at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) ~[?:1.8.0_202] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_202] at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0_202] at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:666) ~[?:1.8.0_202] at sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173) ~[?:1.8.0_202] at sun.net.NetworkClient.doConnect(NetworkClient.java:180) ~[?:1.8.0_202] at sun.net.www.http.HttpClient.openServer(HttpClient.java:463) ~[?:1.8.0_202] at sun.net.www.http.HttpClient.openServer(HttpClient.java:558) ~[?:1.8.0_202] at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264) ~[?:1.8.0_202] at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367) ~[?:1.8.0_202] at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191) ~[?:1.8.0_202] at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156) ~[?:1.8.0_202] at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050) ~[?:1.8.0_202] at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177) ~[?:1.8.0_202] at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1564) ~[?:1.8.0_202] at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492) ~[?:1.8.0_202] at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480) ~[?:1.8.0_202] at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:347) ~[?:1.8.0_202] at com.microsoft.aad.adal4j.HttpHelper.readResponseFromConnection(HttpHelper.java:77) ~[adal4j-1.6.3.jar:1.6.3] at com.microsoft.aad.adal4j.HttpHelper.getResponse(HttpHelper.java:181) ~[adal4j-1.6.3.jar:1.6.3] at com.microsoft.aad.adal4j.HttpHelper.executeGetRequest(HttpHelper.java:155) ~[adal4j-1.6.3.jar:1.6.3] at com.microsoft.aad.adal4j.HttpHelper.executeHttpGet(HttpHelper.java:49) ~[adal4j-1.6.3.jar:1.6.3] at com.microsoft.aad.adal4j.UserDiscoveryRequest.execute(UserDiscoveryRequest.java:51) ~[adal4j-1.6.3.jar:1.6.3] at com.microsoft.aad.adal4j.AcquireTokenCallable.getAuthorizationGrantIntegrated(AcquireTokenCallable.java:168) ~[adal4j-1.6.3.jar:1.6.3] at com.microsoft.aad.adal4j.AcquireTokenCallable.execute(AcquireTokenCallable.java:66) ~[adal4j-1.6.3.jar:1.6.3] at com.microsoft.aad.adal4j.AcquireTokenCallable.execute(AcquireTokenCallable.java:38) ~[adal4j-1.6.3.jar:1.6.3] at com.microsoft.aad.adal4j.AdalCallable.call(AdalCallable.java:47) [adal4j-1.6.3.jar:1.6.3] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]

Here is the full stack trace when running the java JDBC User Authentication code provided in the Microsoft documentation:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host clustername.region, p

ort 1433 has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:226)

        at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerExcept

ion.java:277)

        at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2379)

        at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:652)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2379)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2042)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1889)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1120)

        at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(SQLServerDataSource.java:1056)

        at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnection(SQLServerDataSource.java:85)

        at scratchJava.main(scratchJava.java:20)

PRADEEPCHEEKATLA-MSFT 84,051 Reputation points Microsoft Employee

2024-03-11T04:18:49.3166667+00:00

@Machiri Marodi - Apologize for the delay in response. Have you still experiencing the issue or it's resolved?
Sign in to comment

Share via

Connecting to Azure Data Explorer with JDBC

1 answer