Created 06-14-2022 01:43 AM
Hi do you have any ide what how i solve the above error
Created 06-14-2022 02:18 AM
How you are passing SSL details in DBCPConnectionPool used by ConvertJSONToSQL? in configured JDBC URL?
Created 06-14-2022 02:22 AM
yes my jdbc is the below
jdbc:sqlserver://uxxxxx:1433;encrypt=true;trustServerCertificate=true;database=xxx;
Created 06-14-2022 05:15 AM
I per MS SQL docs I found this example String connectionUrl =
"jdbc:sqlserver://localhost:1433;" +
"databaseName=AdventureWorks;integratedSecurity=true;" +
"encrypt=true; trustServerCertificate=false;" +
"trustStore=storeName;trustStorePassword=storePassword"; Can you please check ? also the URL which you have used works outside of nifi ?
Created 06-17-2022 12:32 AM
@vkotsas, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.
Regards,
Vidya Sargur,