MariaDB Client Library for Java Applications

The MariaDB Client Library for Java Applications is used to connect applications developed in Java to MariaDB and MySQL databases using the standard JDBC API. The client library is LGPL licensed.

Introduction

The MariaDB Client Library for Java Applications is a Type 4 JDBC driver. It was developed specifically as a lightweight JDBC connector for use with MySQL and Drizzle database servers. It's based on the Drizzle JDBC driver with a lot of additions and fixes.

Obtaining the driver

The driver is downloaded from http://downloads.mariadb.org

Installing the driver

Installation is as simple as placing the .jar file in your classpath.

Requirements

• Java 5 or Java 6
• maven (if you are testing / building from source)
• A MariaDB or MySQL Server

Source code

The source code is available on Launchpad: https://launchpad.net/mariadb-java-client

License

GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

Testing the driver

The section deals with building the connector from source and testing it. If you have downloaded a ready built connector, in a jar file, then this section may be skipped.

MariaDB Client Library for Java Applications uses maven. You first need to ensure you have both java and maven installed on your server before you can build the driver.

Currently, the test suite is more development oriented, but we provide information on how to run it in case the user wishes to do so.

Note you will need a MariaDB or MySQL server running on localhost and a schema called test_units_jdbc to be able to package the JDBC jar binary (tests need to be run successfully to build the package)

Note You will also need a MariaDB or MySQL server running on localhost with a no-username-password user which has access to a test database. The username/password can be changed, look in the constructor of src/test/java/org/mariadb/jdbc/MySQLDriverTest.java

To execute the test suite: To run the test suite, you need a running version of drizzled on localhost with a database called test: $ mvn test

To compile the jar and run the tes suite, use $mvn package

Installing the driver

Installation of the client library is very simple, the jar file should be saved in an appropriate place for your application and the classpath of your application altered to include the MariaDB Client Library for Java Applications rather than your current connector.

Using the driver

The following subsections show the formatting of JDBC connection strings for MariaDB, MySQL and Drizzle database servers. Additionally, sample code is provided that demonstrates how to connect to one of these servers and create a table.

As this is a standard JDBC driver, it should be a drop-in replacement for any other driver. Certain features outside the standard from other drivers may not currently be implemented / available.

Driver Manager

Applications designed to use the driver manager to locate the entry point need no further configuration, the MariaDB Client Library for Java Applications will automatically be loaded and used in the way any previous MySQL driver would have been.

Driver Class

The driver class provided by the MariaDB Client Library for Java Applications is org.mariadb.jdbc.Driver. This provides a standard JDBC driver interface and also allows used of the javax PoolConnections.

Connection strings

Use the following connection strings when connecting to one of the listed database servers.

MariaDB and MySQL connections

jdbc:mysql:<host>:<port>/<database>?username=<username>&password=<password>

Usage examples

The following code provides a basic example of how to connect to a MariaDB or MySQL server and create a table.

Creating a table on a MariaDB or MySQL Server

Connection  connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "username", "password");
Statement stmt = connection.createStatement();
stmt.executeUpdate("CREATE TABLE a (id int not null primary key, value varchar(20))");
stmt.close();
connection.close();