Using JDBC to Connect to Doris in SSL Mode (Certificate Verification Not Needed)

When code retry and load balancing are performed at the application layer, multiple Doris FE node addresses need to be configured for an application. If a connection exits abnormally, the system automatically retries on another connection.

• The HTTPS must be enabled for the cluster in advance.
• Download the certificate on the cluster details page.

Sample code:

public class Main {
  private static String URL = "jdbc:mysql:loadbalance://" +
          "[FE1_host]:[FE1_port],[FE2_host]:[FE2_port],[FE3_host]:[FE3_port]/[your_database]?" +
          "loadBalanceConnectionGroup=first&ha.enableJMX=true";
  static Connection getNewConnection() throws SQLException, ClassNotFoundException {
      Class.forName("com.mysql.cj.jdbc.Driver");
      // There will be security risks if the password used for authentication is directly written into code. Encrypt the password in the configuration file or environment variables for storage;
      // In this example, the password is stored in environment variables for identity authentication. Before running the code in this example, configure environment variables first.
      String password = System.getenv("USER_PASSWORD");
      String user = "your_username";
      Properties props = new Properties();
      props.setProperty("user", user);
      props.setProperty("password", password);
      props.setProperty("useSSL", "true");
      props.setProperty("requireSSL", "true");
      return DriverManager.getConnection(URL, props);
  }
  public static void main(String[] args) throws Exception {
      Connection c = getNewConnection();
      try {
          System.out.println("begin print");
          String query = "your sqlString";
          c.setAutoCommit(false);
          Statement s = c.createStatement();
          ResultSet resultSet = s.executeQuery(query);
          while(resultSet.next()) {
              int id = resultSet.getInt(1);
              System.out.println("id is: "+id);
          }
          System.out.println("end print");
          Thread.sleep(Math.round(100 * Math.random()));
          c.close();
      } catch (Exception e) {
          e.printStackTrace();
      }
  }
}