MariaDB Command-line Client from MariaDB Server Version 10.3.12 (GPLv2)
Binary | URL |
---|---|
Linux RHEL 6 x86_64 | |
Linux RHEL 7 x86_64 | |
Windows x86_64 |
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();
Note
The details of your host, port, credentials, etc. should be updated in the examples above.