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

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Binary	URL
Linux RHEL 6 x86_64	MariaDB-10.3.12-centos6-x86_64-client.rpm
Linux RHEL 7 x86_64	MariaDB-10.3.12-centos73-x86_64-client.rpm
Windows x86_64	mariadb-10.3.12-winx64.msi

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

Java

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

Java

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();

Note

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