next.jdbc - unable to find valid certification path to requested target

Question

The error ; Execution error (SunCertPathBuilderException) at sun.security.provider.certpath.SunCertPathBuilder/build (SunCertPathBuilder.java:141). ; unable to find valid certification path to requested target The code (Clojure) (ns backend.core (:require [next.jdbc :as jdbc])) (defn -main "I don't do a whole lot ... yet." [& args] (println "Hello, World!")) (def db {:dbtype "sqlserver" :dbname "dbname" :user "MY_USER" :password "MY_PASSWORD" :host "MY_HOST" :port 1234}) (def datasource (jdbc/get-datasource db)) (defn create-product "Create a product." [name ds] (jdbc/execute! ds [(str "insert into dbo.product (name) value('" name "')")])) (comment (create-product "my-product" datasource)) I'm playing around with clojure/sql server/next.jdbc and trying to work with my distant SQL Server 2017, but this error appear... It look like I need some certificate. Is it the case? How can I generate it? How can I install it on my dev PC? Should it be install in a specific place? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

I fixed my issue by changing the content of the (def db ...). Here is the updated code working. (ns backend.core (:require [next.jdbc :as jdbc])) (defn -main "I don't do a whole lot ... yet." [& args] (println "Hello, World!")) (def db {:jdbcUrl "jdbc:sqlserver://MY_DISTANT_HOST:12345;databaseName=DB_NAME;user=USERNAME;password=MY_PASSWORD;encrypt=true;trustServerCertificate=true"}) (def datasource (jdbc/get-datasource db)) (defn create-product "Create a product." [name ds] (with-open [connection (jdbc/get-connection ds)] (jdbc/execute! connection ["insert into dbo.product (name) values (?)" name] {:return-keys true}))) (comment (create-product "my-product" datasource)) You can find more information about jdbc connection string here: https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver15 I too ran into a second issue after updating the data-source configuration. The error was: no mssql-jdbc_auth-8.2.1.x64 in java.library.path I only needed to download zip file here https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15, unzip it and follow instructions inside install.txt and finally restart my IDE (VS Code).