azure-mariadb-connector-java

MariaDB Java client with redirection support for Azure MySQL/MariaDB. Take advantage of this client to improve the connection latency between application front end and Azure Database for MySQL/MariaDB.

License

License

LGPL-2.1
Categories

Categories

Java Languages
GroupId

GroupId

com.microsoft.azure
ArtifactId

ArtifactId

azure-mariadb-connector-java
Last Version

Last Version

2.7.0
Release Date

Release Date

Type

Type

jar
Description

Description

azure-mariadb-connector-java
MariaDB Java client with redirection support for Azure MySQL/MariaDB. Take advantage of this client to improve the connection latency between application front end and Azure Database for MySQL/MariaDB.
Project URL

Project URL

https://github.com/microsoft/mariadb-connector-j
Project Organization

Project Organization

microsoft.com
Source Code Management

Source Code Management

https://github.com/microsoft/mariadb-connector-j

Download azure-mariadb-connector-java

How to add to project

<!-- https://jarcasting.com/artifacts/com.microsoft.azure/azure-mariadb-connector-java/ -->
<dependency>
    <groupId>com.microsoft.azure</groupId>
    <artifactId>azure-mariadb-connector-java</artifactId>
    <version>2.7.0</version>
</dependency>
// https://jarcasting.com/artifacts/com.microsoft.azure/azure-mariadb-connector-java/
implementation 'com.microsoft.azure:azure-mariadb-connector-java:2.7.0'
// https://jarcasting.com/artifacts/com.microsoft.azure/azure-mariadb-connector-java/
implementation ("com.microsoft.azure:azure-mariadb-connector-java:2.7.0")
'com.microsoft.azure:azure-mariadb-connector-java:jar:2.7.0'
<dependency org="com.microsoft.azure" name="azure-mariadb-connector-java" rev="2.7.0">
  <artifact name="azure-mariadb-connector-java" type="jar" />
</dependency>
@Grapes(
@Grab(group='com.microsoft.azure', module='azure-mariadb-connector-java', version='2.7.0')
)
libraryDependencies += "com.microsoft.azure" % "azure-mariadb-connector-java" % "2.7.0"
[com.microsoft.azure/azure-mariadb-connector-java "2.7.0"]

Dependencies

compile (5)

Group / Artifact Type Version
com.github.waffle : waffle-jna Optional jar 2.2.1
net.java.dev.jna : jna Optional jar 5.5.0
net.java.dev.jna : jna-platform Optional jar 5.5.0
org.slf4j : slf4j-api Optional jar [1.4.0,1.7.25]
com.amazonaws : aws-java-sdk-rds Optional jar 1.11.734

provided (2)

Group / Artifact Type Version
org.osgi : org.osgi.core jar 6.0.0
org.osgi : org.osgi.compendium jar 5.0.0

test (2)

Group / Artifact Type Version
junit : junit jar 4.13
ch.qos.logback : logback-classic Optional jar 1.2.3

Project Modules

There are no modules declared in this project.

MariaDB Java Connector For Azure MySQL/MariaDB

For general introduction for MariaDB java connector, please check on https://github.com/MariaDB/mariadb-connector-j. The source code here is in the latest version same with the related branch on https://github.com/MariaDB/mariadb-connector-j with redirection feature support. Take advantage of this client to improve the connection latency between application front end and Azure Database for MySQL/MariaDB. Following is a brief guide of how to install and test the driver.

Available versions

Maven repository version

This driver is now available from Maven central repository search from https://mvnrepository.com/artifact/com.microsoft.azure/azure-mariadb-connector-java. The version number is same with related branch on https://github.com/MariaDB/mariadb-connector-j with redirection feature support. You may use following sample pom definition to include the driver in your project:

<dependency>
    <groupId>com.microsoft.azure</groupId>
    <artifactId>azure-mariadb-connector-java</artifactId>
    <version>2.7.0</version>
</dependency>

Source code version

The source code here is in the latest status same with the realted branch on https://github.com/MariaDB/mariadb-connector-j with redirection feature support(2020-06-03). Valid branches:

  • master: based on MariaDB/mariadb-connector-j branch master with redirection support.
  • 2.7.0-with-redirection: based on MariaDB/mariadb-connector-j tag 2.7.0 with redirection support.
  • 2.6.0-with-redirection: based on MariaDB/mariadb-connector-j tag 2.6.0 with redirection support.
  • 2.5.1-with-redirection: based on MariaDB/mariadb-connector-j tag 2.5.1 with redirection support.

Notice There is an issue traced for MariaDB/mariadb-connector-j 2.5.2+ on https://jira.mariadb.org/browse/CONJ-807. The problem has been fixed on 2.7.0. The recommended branch is 2.7.0-with-redirection or 2.5.1-with-redirection.

Redirection option Usage

A new connection option is introduced for redirection and the option name is enableRedirect, default value: off.

The detailed usage of the option enableRedirect is as follows:

off(0) - Redirection will not be used.
on(1) Will enforce redirection.
- If redirection is not supported on the server, the connection will be aborted and the following error is returned: "Connection aborted because redirection is not enabled on the MySQL server or the network package doesn't meet redirection protocol."
- If the MySQL server supports redirection, but the redirected connection failed for any reason, also abort the first proxy connection. Return the error of the redirected connection.
preferred(2) - It will use redirection if possible.
- If the connection does not use SSL on the driver side, the server does not support redirection, or the redirected connection fails to connect for any non-fatal reason while the proxy connection is still a valid one, it will fall back to the first proxy connection.

Step to build and install from source

Tools prerequisite to build the drivers

  • Java 1.8+
  • Maven

Build

mvn package

The default test database names is testj which need to be created ahead, user is root, and without password. You can also specify the connection string as follows for test:

mvn -DdbUrl=jdbc:mariadb://localhost:3306/testj?user=root&password=xxx -DlogLevel=FINEST package

Please notice that the unit test sets is not designed fully compatibitale with Azure MySQL server, so don't run this test against Azure MySQL server and expect a full pass.

If you want to build without running unit tests and document check, use:

mvn -Dmaven.javadoc.skip=true -Dmaven.test.skip=true package

Install

After build, you should have JDBC jar mariadb-java-client-x.y.z.jar in the 'target' subdirectory, e.g. mariadb-java-client-2.5.1.jar. Replace this jar with the mariadb-java-client jar package you currently used in your environemnt. Following are two use examples in different scenario:

After install, specify the connection string setting with enableRedirect option, e.g.

jdbc:mysql://xxx.mysql.database.azure.com/testj/?user=xx&password=xx&useSSL=true&serverSslCert=xx/BaltimoreCyberTrustRoot.crt.pem&enableRedirect=on"

Notice: Please notice that there is a limitation for Azure DB for MySQL where redirection is only possible when the connection is configured with SSL and only works with TLS 1.2 with a FIPS approved cipher for redirection.

Test

    // Load the JDBC driver
    Class.forName("org.mariadb.jdbc.Driver");
    System.out.println("Driver loaded");

    int count = 10;
    String query = "SELECT 1";
    int i=0;
    // Try to connect
    String url = "jdbc:mysql://xxx.mysql.database.azure.com"+
            "?verifyServerCertificate=false"+
            "&useSSL=true"+
            "&requireSSL=true" +
			"&enableRedirect=on";

    Connection connection = DriverManager.getConnection (url, "username", "password");
    double t1 = System.nanoTime();
    Statement s1 = connection.createStatement();
    for(i=0;i<count;i++)
    {
        s1.executeQuery(query);
    }
    double t2 = System.nanoTime();
    System.out.println (" time = " + (t2 - t1)/count/1000000);
    connection.close();
com.microsoft.azure

Microsoft

Open source projects and samples from Microsoft

Versions

Version
2.7.0