Contributions
How to retrieve the encrypted column as decrypted through ReadyAPI?
I need to verify some data in acolumn encrypted database. The database is using clientId and clientSecret to authentication to AKV. To decrypt the database, I usedAlways Encrypted with the JDBC driver connection Connection string "jdbc:sqlserver://<server>:<port>;columnEncryptionSetting=Enabled;keyStoreAuthentication=KeyVaultClientSecret;keyStorePrincipalId=<clientId>;keyStoreSecret=<clientSecret>" Database driver:Microsoft JDBC "mssql-jdbc-9.2.1.jre11.jar" ReadyAPI version: 3.8.0 The first connection try was connected successfully. The second connection try failed and popped up an error "Failed to get a connection for the specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Key store providers cannot be set more than once." In the first connection, if I run the query to try retrieving encrypted column, it will be hanging there; but if I tried retriving non-encrypted column, it worked and could return the column data. Did anyone experience this situation?Solved3 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.3KViews0likes2CommentsRe: How to retrieve the encrypted column as decrypted through ReadyAPI?
Hirichie, Thank you so much for your help! I have checked everything you mentioned. They were all good. The main issue was caused by missing jar files. When some jar files were missing, it did not show in ReadyAPI logs, so it was just hanging there. However, if I run readyapi.bat from command line, it will show the logs there. I add jar files one by one based on the prompt in logs, then it worked.3 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.2KViews0likes0Comments