Skip to main content

MariaDB Command-line Client from MariaDB Server Version 10.3.12 (GPLv2)

Source code: mariadb-10.3.12.tar.gz

Configuring the MariaDB Connector

The documentation can be found on the MariaDB website: https://mariadb.com/kb/en/about-mariadb-connector-j/#usage-examples

Example of Creating a Table on a MariaDB

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "username", "password");
Statement stmt = connection.createStatement();
stmt.executeUpdate("CREATE TABLE table1 (id INT NOT NULL PRIMARY KEY, colchar VARCHAR(20))");
stmt.close();
connection.close();

Example of Calling an Existing Stored Procedure via MariaDB

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "username", "password");
Statement stmt = connection.createStatement();
stmt.executeUpdate("ECHO sp_name(parameter);");
stmt.close();
connection.close();

Notice

The details of your host, port, credentials, etc. should be updated in the examples above.