exception SQL Server instance in use does not support column encryption #65
Comments
|
@valda-z thank you for filling the issue.
Am I right? thank you in advance |
|
Hello,
Yes, exactly. Linux version 16.04 LTS…
Valdemar
From: v-xiangs [mailto:notifications@github.com]
Sent: Wednesday, December 7, 2016 02:08
To: Microsoft/mssql-jdbc <mssql-jdbc@noreply.github.com>
Cc: Valdemar Zavadsky <Valdemar.Zavadsky@microsoft.com>; Mention <mention@noreply.github.com>
Subject: Re: [Microsoft/mssql-jdbc] exception SQL Server instance in use does not support column encryption (#65)
@valda-z<https://github.com/valda-z> thank you for filling the issue.
I just want to clarify the scenario with you.
From my understanding (with columnEncryptionSetting enabled):
1. when you run your program on Linux, it fails to connect to your Azure SQL instance;
2. when you run your program on Windows, it succeeds to connect to the same Azure SQL instance.
3. the Linux VM that your program runs on is a VM on Azure cloud
Am I right? thank you in advance
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#65 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AVS7tRqfxs4CXDeenz53kPHufwufsMt1ks5rFgbngaJpZM4LFKHh>.
|
|
Now tested also on Azure Web App with Tomcat (default Windows based instance) and also failed with same exception. Important is that from another Web App in Azure which hosts .NET base application it works correctly. It means - I hope - that it is not in some SQL related setting in Azure SQL databaze. com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server instance in use does not support column encryption. |
|
@valda-z thank you for all your very detailed descriptions. I created a PR for this issue, could you please check if that resolves the issue? it should work. Thank you. |
|
Perfect! Well done! I can confirm that this patch works for me. Do you have any idea when it will be merged to final version which will be published to mvnrepository? Valdemar |
|
@valda-z, our current approach is to release a few"early technical previews" that will roll into a release that is pushed into Maven. It may take a few more of these previews before we publish in Maven. |
|
Thank you,
Understood,
Valdemar
From: Andrea Lam [mailto:notifications@github.com]
Sent: Thursday, December 8, 2016 22:17
To: Microsoft/mssql-jdbc <mssql-jdbc@noreply.github.com>
Cc: Valdemar Zavadsky <Valdemar.Zavadsky@microsoft.com>; Mention <mention@noreply.github.com>
Subject: Re: [Microsoft/mssql-jdbc] exception SQL Server instance in use does not support column encryption (#65)
@valda-z<https://github.com/valda-z>, our current approach is to release a few"early technical previews" that will roll into a release that is pushed into Maven. It may take a few more of these previews before we publish in Maven.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#65 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AVS7taqAGy7NqmbLaVG5q2Ow6_AOfjqAks5rGHOzgaJpZM4LFKHh>.
|
I have solution which tries to connect to Azure SQL database, database contains one table with few columns, one of columns has enabled column encryption (Always Encrypted with Azure KeyVault provider).
application is not able to connect to Azure SQL on Linux machine.
Finally I prepared docker image based on standard dockerhub java image (linux based). When I am running this image on my Windows 10 OS (but internally it still uses Linux docker in docker for windows) connection is successful, but when I upload my image to ubuntu linux VM in Azure it fails with exception:
com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server instance in use does not support column encryption.
at com.microsoft.sqlserver.jdbc.TDSReader.TryProcessFeatureExtAck(IOBuffer.java:7346)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:123)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4376)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3188)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:61)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3151)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1973)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1616)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1447)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:788)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1187)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at Main.main(Main.java:81)
If I change connection string to use standard sql connection without columnEncryptionSetting than it works on both platforms.
included source codes and also trace logs from both scenario - docker on ubuntu linux and same docker image on windows10 docker.
Valdemar
project.zip
docker-on-ubuntu-1604.txt
docker-on-windows10.txt
The text was updated successfully, but these errors were encountered: