Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

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, while SingleStore 9.0 is recommended for production workloads.

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.