Connect From Java App
Connect to MariaDB Cloud from a Java application using the MariaDB Connector/J JDBC driver, including connection URL format, TLS configuration, and authentication.
Last updated
Was this helpful?
Was this helpful?
export CLASSPATH="/path/to/application:/path/to/mariadb-java-client-3.4.1.jar"import java.sql.*;
import java.util.Properties;
public class App {
public static void main(String[] argv) {
Properties connConfig = new Properties();
connConfig.setProperty("user", "db_user");
connConfig.setProperty("password", "db_user_password");
**connConfig.setProperty("sslMode", "verify-full");**
try (Connection conn = DriverManager.getConnection("jdbc:mariadb://HOST:PORT", connConfig)) {
try (Statement stmt = conn.createStatement()) {
try (ResultSet contact_list = stmt.executeQuery("SELECT first_name, last_name, email FROM test.contacts")) {
while (contact_list.next()) {
System.out.println(String.format("%s %s <%s>",
contact_list.getString("first_name"),
contact_list.getString("last_name"),
contact_list.getString("email")));
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}import java.sql.*;
import java.util.Properties;
public class App {
public static void main(String[] argv) {
Properties connConfig = new Properties();
connConfig.setProperty("user", "db_user");
connConfig.setProperty("password", "db_user_password");
**connConfig.setProperty("useSsl", "true");**
try (Connection conn = DriverManager.getConnection("jdbc:mariadb://HOST:PORT", connConfig)) {
try (Statement stmt = conn.createStatement()) {
try (ResultSet contact_list = stmt.executeQuery("SELECT first_name, last_name, email FROM test.contacts")) {
while (contact_list.next()) {
System.out.println(String.format("%s %s <%s>",
contact_list.getString("first_name"),
contact_list.getString("last_name"),
contact_list.getString("email")));
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}