Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
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,