postgresql数据库验证证书报错. 其实早就找到答案了, 但是由于不细心, 墨迹了一天 真是不识庐山真面目,只缘身在此山中。废话不多说,上过程
代码:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class jdbcTest {
public static void main(String[] args){
/* String url = "jdbc:postgresql://192.168.1.202:5432/herodb?ssl=true&sslcert=E:\\certificate\\sysadmin.crt&sslkey=E:\\certificate\\sysadmin.key&sslrootcert=E:\\certificate\\ca.crt";
String username = "sysadmin";
String password = "";*/
String url = "jdbc:postgresql://192.168.1.202:5432/herodb";
Properties props = new Properties();
props.setProperty("user","sysadmin");
props.setProperty("sslmode","verify-ca");//确保连接加密,客户端信任服务器证书。
props.setProperty("sslcert","E:\\certificate\\sysadmin.crt");
props.setProp