Important

Self-managed SingleStore will soon transition from version 9.1 RC to version 10. This new semantic versioning scheme will provide SingleStore with finer control over engine and feature releases that were not possible with the current versioning scheme.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10 prior to its general availability. Ahead of this transition, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.

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

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 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.