Download Release Notes Changelog

Release date: 8 Aug 2025

MariaDB Connector/J 3.5.5 is a Stable (GA) release.

Bugs Fixed

• ensure rollback and release savepoint operation to be sent to server, even when there is no transaction in progress ()

• forceConnectionTimeZoneToSession doesn't always set the timezone to server ()

Changelog

For a complete list of changes made in MariaDB Connector/J 3.5.5, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 27 Mar 2025

MariaDB Connector/J 3.4.2 is a Stable (GA) release.

Bugs Fixed

• : Fixed issue with incorrect statements.isClosed value after closing connection

• : Prevented NPE (Null Pointer Exception) after reconnection failure in high availability configurations

• : Disabled BULK operations when no parameters are present

Changelog

For a complete list of changes made in MariaDB Connector/J 3.4.2, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 1 May 2023

MariaDB Connector/J 3.1.4 is a Stable (GA) release.

Bugs fixed

• wrong Resultset.wasNull() for zero-date timestamps

• getBlob on TEXT columns throw Exception

• Error response during Bulk execution might result in connection wrong state

• When some numeric data types are set to UNSIGNED, ResultSetMetaData.getColumnTypeName() does not return UNSIGNED

Changelog

For a complete list of changes made in MariaDB Connector/J 3.1.4, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 24 Jan 2023

MariaDB Connector/J 3.1.2 is a Stable (GA) release.

Notable Changes

• fix DatabaseMetaData.getColumns() on old server version (< MySQL 5.6.4 and < )

Bugs fixed

• possible ConcurrentModificationException when parsing properties when connecting

• possible ArrayIndexOutOfBoundsException when writing a parameter to socket pre-buffer when pre-buffer is exactly 16M

Changelog

For a complete list of changes made in MariaDB Connector/J 3.1.2, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 25 Aug 2023

MariaDB Connector/J 3.0.11 is a Stable (GA) release.

Bugs Fixed

• correcting 3.0.10 incompatibility with java 8

Changelog

For a complete list of changes made in MariaDB Connector/J 3.0.11, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 11 Jan 2023

MariaDB Connector/J 3.0.10 is a Stable (GA) release.

Bugs Fixed

• Connector/J doesn't set SSL cap bit in Handshake Response Packet

• timezone=auto option failure on non-fixed-offset zone machine

• Compatibility for deprecated arguments is case sensitive now

Changelog

For a complete list of changes made in MariaDB Connector/J 3.0.10, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 11 Aug 2021

MariaDB Connector/J 3.0.1 is a Beta (Beta) release.

Notable Changes

See for 3.0 release. with the following fixes :

Bugs Fixed

• Provide JPMS module descriptor

• metadata query performance correction

• MariaDbPoolDataSource leaks connections when the mariadb server restarts

• org.mariadb.jdbc.internal.util.pool.Pool swallows SQLException during addConnection

Changelog

For a complete list of changes made in MariaDB Connector/J 3.0.1, with links to detailed information on each push, see the .

Download Release Notes Changelog

Release date: 20 Feb 2024

MariaDB Connector/J 2.7.12 is a Stable (GA) release.

Bugs Fixed

• Wrong sequence number of sub header with compressing procotol active

• Wrong debug trace when using compression protocol

• Improve message when reaching socket timeout during connection initial commands

• session tracking only read first SYSTEM_VARIABLES session tracking change

Changelog

For a complete list of changes made in MariaDB Connector/J 2.7.12, with links to detailed information on each push, see the .

Download Release Notes Changelog

Release date: 25 Aug 2023

MariaDB Connector/J 2.7.10 is a Stable (GA) release.

Bugs Fixed

• Ensure setting connectTimeout as timeout for socket timeout until connection is done. This permit to set a connectTimeout, while socketTimeout can still be set to 0

Changelog

For a complete list of changes made in MariaDB Connector/J 2.7.10, with links to detailed information on each push, see the .

Download Release Notes Changelog

Release date: 22 Mar 2023

MariaDB Connector/J 2.7.9 is a Stable (GA) release.

Bugs Fixed

• correcting TlsSocketPlugin to use Driver classloader

• DatabaseMetaData.getTypeInfo() returns wrong value for UNSIGNED_ATTRIBUTE

Changelog

For a complete list of changes made in MariaDB Connector/J 2.7.9, with links to detailed information on each push, see the .

Download Release Notes Changelog

Release date: 19 Jan 2022

MariaDB Connector/J 2.7.5 is a Stable (GA) release.

Notable Change

• The connection id has been added to important log messages for easier correlation of these log messages with MariaDB Server logs

• The connect does not enable session_track_schema anymore when connecting to the server, as this is the server default already

Bugs Fixed

• Error message “[1036] Unknown variable: session_track_schema” when MariaDB Connector/J connects to MariaDB Xpand

• Connection Pools do not validate other connections before use when the socket fails

• Options useBatchMultiSend and usePipelineAuth are disabled without reason for RDS

Changelog

For a complete list of changes made in MariaDB Connector/J 2.7.5, with links to detailed information on each push, see the .

Download Release Notes Changelog

Release date: 11 Aug 2021

MariaDB Connector/J 2.7.4 is a Stable (GA) release.

Bugs Fixed

• getImportedKeys/getTables regression returning an empty resultset for null/empty catalog

• Ensure socket state when SocketTimeout occurs

• IndexOutOfBoundsException when executing prepared queries using automatic key generation in parallel

• MariaDbPoolDataSource leaks connections when the mariadb server restarts

• DatabaseMetaData.getColumns regression causing TINYINT(x) with x > 1 to return BIT type in place of TINYINT

• CallableStatement using function throw wrong error on getter

Changelog

For a complete list of changes made in MariaDB Connector/J 2.7.4, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 20 Mar 2020

MariaDB Connector/J 2.6.0 is a Stable (GA) release.

Notable Updates

• - Check Galera allowed state when connecting when option galeraAllowedState is set, and not only on validation

• - on failover, catalog changed might not be set when automatically recreating a connection.

• - remove unnecessary dependencies for fedora tar creation

Changelog

For a complete list of changes made in MariaDB Connector/J 2.6.0, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 22 Nov 2019

MariaDB Connector/J 2.5.2 is a Stable (GA) release.

Notable Updates

• - use pool reset only for corrected COM_RESET_CONNECTION

• - byte signed value wrong serialization for text protocol

• ensure plugin using Driver classloader

Changelog

For a complete list of changes made in MariaDB Connector/J 2.5.2, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 16 Oct 2019

MariaDB Connector/J 2.5.1 is a Release Candidate (RC) release.

Notable Updates

• - Error packet caching_sha2_password not handled when not having a password

• - PAM authentication multiple exchanges permitting multiple steps in connection string

• - Multi insert regression correction returning multi generated keys

• - OSGI compliance

Changelog

For a complete list of changes made in MariaDB Connector/J 2.5.1, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 18 Sep 2019

MariaDB Connector/J 2.4.4 is a Stable (GA) release.

Bugs

• : Do not ignore the Calendar parameter in ResultSet#getTime(int, Calendar)

• : Connection Failure when using PAM authenticated user on 10.4 MariaDB server

• : master-slave regression: commit on read-only server Executed only when there is an active transaction on master connection

• : removing possible NPE after failover on aurora cluster

Changelog

For a complete list of changes made in MariaDB Connector/J 2.4.4, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 5 Aug 2019

MariaDB Connector/J 2.4.3 is a Stable (GA) release.

Notes

New option blankTableNameMeta permit to have Resultset metadata getTableName methods always return blank in place of returning real table name as JDBC indicate. This is for ease migration from Oracle since Oracle driver always returns an empty string.

• : conversion function support for other data types than default MariaDB conversion type

• : Permit suppression of result-set metadata getTableName for oracle compatibility

• : Saving values using Java 8 LocalTime does not store fractional parts of seconds

• : Correcting possible NPE on non-thread safe NumberFormat (logging)

Changelog

For a complete list of changes made in MariaDB Connector/J 2.4.3, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 30 May 2018

MariaDB Connector/J 2.2.5 is a Stable (GA) release.

Minor change:

• [] Add server hostname to connection packet for proxy

• [] handle support for mysql 8.0 tx_isolation replacement by transaction_isolation

• [] Create option to configure DONOR/DESYNCED Galera nodes to be unavailable for load-balancing : Usually, Connection.isValid just send an empty packet to the server, and server sends a small response to ensure connectivity. When a new option "useBulkStmts" option is set, the connector will ensure galera server state ("wsrep_local_state" correspond to allowed values (4 = sync mode). see to now more.

Bug correction:

• [] Connection using "replication" Parameters fail when no slave is available

• [] Newlines where breaking calling stored procedures

• [] Using getDate with function DATE_ADD() with parameter using string format where return wrong result using the binary protocol

• [] Option "allowMasterDownConnection" improvement on connection validation and Exceptions on master down

Download | Release Notes | Changelog |

Release date: 14 May 2018

MariaDB Connector/J 2.2.4 is a Stable (GA) release.

Bug Fixes

• [] Some options are missing in documentation like default 'autocommit' value

• [] Internal exchanges send utf8mb4 with server even if default server collation is not utf8/utf8mb4

• [] Upgrading non-mandatory Waffle dependency to 1.9.0 (windows GSSAPI authentication)

• [] test addition to ensure YaSSL downgrade TLSv1.2 protocol to TLSv1.1

Release date: 11 Sep 2025

MariaDB Connector/J 3.5.6 is a (GA) release.

Notable changes

Release date: 27 Mar 2025

MariaDB Connector/J 3.5.3 is a (GA) release.

Notable Changes

Release date: 1 Jul 2025

MariaDB Connector/J 3.5.4 is a (GA) release.

Notable Changes

| Release Notes | |

Release date: 11 Feb 2025

MariaDB Connector/J 3.5.2 is a (GA) release.

Notable change

| Release Notes | |

Release date: 27 Mar 2025

MariaDB Connector/J 3.3.4 is a (GA) release.

Bugs Fixed

| Release Notes | |

Release date: 20 Feb 2024

MariaDB Connector/J 3.3.3 is a (GA) release.

Bugs Fixed

| Release Notes | |

Release date: 19 Dec 2023

MariaDB Connector/J 3.3.2 is a (GA) release, and will replace 3.2 as the maintenance releases.

Bugs Fixed

| Release Notes | |

Release date: 29 Nov 2023

MariaDB Connector/J 3.3.1 is a (GA) release, and will replace 3.2 as the maintenance releases.

Bugs Fixed

| Release Notes | |

Release date: 8 Nov 2023

MariaDB Connector/J 3.3.0 is a (GA) release, and will replace 3.2 as the maintenance releases.

Notable Changes

| Release Notes | |

Release date: 22 Mar 2023

MariaDB Connector/J 3.1.3 is a (GA) release.

Bugs fixed

| Release Notes | |

Release date: 11 Jan 2023

MariaDB Connector/J 3.1.1 is a (GA) release.

Bugs fixed

| Release Notes | |

Release date: 8 Nov 2022

MariaDB Connector/J 3.0.9 is a (GA) release.

Notable Changes

| Release Notes | |

Release date: 20 Sep 2022

MariaDB Connector/J 3.0.8 is a (GA) release.

Notable Changes

| Release Notes | |

Release date: 4 Aug 2022

MariaDB Connector/J 3.0.7 is a (GA) release.

Bugs Fixed

| Release Notes | |

Release date: 29 Jun 2022

MariaDB Connector/J 3.0.6 is a (GA) release.

Notable Changes

| Release Notes | |

Release date: 25 May 2022

MariaDB Connector/J 3.0.5 is a (GA) release.

Notable Changes

| | |

Release date: 25 Mar 2022

MariaDB Connector/J 3.0.4 is a (GA) release.

Bugs Fixed

| Release Notes | |

Release date: 16 Sep 2021

MariaDB Connector/J 3.0.2 is a release.

Release date: 17 Dec 2025

MariaDB Connector/J 2.7.13 is a (GA) release.

Bugs Fixed

Release date: 08 Nov 2023

MariaDB Connector/J 2.7.11 is a (GA) release.

Bugs Fixed

Release date: 24 Jan 2023

MariaDB Connector/J 2.7.8 is a (GA) release.

Bugs Fixed

Release date: 8 Nov 2022

MariaDB Connector/J 2.7.7 is a (GA) release.

Bugs Fixed

Release date: 29 Jun 2022

MariaDB Connector/J 2.7.6 is a (GA) release.

Bugs Fixed

Release date: 12 May 2021

MariaDB Connector/J 2.7.3 is a (GA) release.

Notable Change

Release date: 29 Jan 2021

MariaDB Connector/J 2.7.2 is a (GA) release.

Bugs Fixed

Release date: 23 Nov 2020

MariaDB Connector/J 2.7.1 is a (GA) release.

Notable changes

| Release Notes | |

Release date: 27 Jan 2020

MariaDB Connector/J 2.5.4 is a (GA) release.

| Release Notes | |

Release date: 8 Jan 2020

MariaDB Connector/J 2.5.3 is a (GA) release.

Notable Updates

| Release Notes | |

Release date: 22 Dec 2017

MariaDB Connector/J 2.2.1 is a (GA) release.

• [] provide support for authentication plugin ed25519

| Release Notes | |

Release date: 18 Mar 2019

MariaDB Connector/J 2.4.1 is a (GA) release.

Evolutions

| Release Notes | |

Release date: 14 Mar 2018

MariaDB Connector/J 2.2.3 is a (GA) release.

Bug Fixes

| Release Notes | |

Release date: 27 Jun 2017

MariaDB Connector/J 2.0.3 is a (GA) release.

Bug

Release Notes | |

Release date: 9 Dec 2020

MariaDB Connector/J 1.7.5 is a (GA) release.

This version contains breaking changes that weren't expect in a corrective release. Correction have been done with 1.7.6 version, that is the 1.7.4 version + corrections.

Note: This page describes features in an unreleased version of .Unreleased means there are no official packages or binaries available for download which contain the features. The source code is available on .

Download | Release Notes | Changelog |

Release date: 24 Oct 2024

MariaDB Connector/J 3.5.0 is a Stable (GA) release.

The MariaDB Connector/J 3.5 release series is replacing the maintenance releases for the 3.4 release series, as the new release series is fully compatible with 3.4.

Notable changes

PARSEC Authentication -

Support of the PARSEC Authentication Plugin which is provided starting with MariaDB Server 11.6. See for more details.

This requires java 15+ (to use java native ed25519 Algorithm implementation). For previous versions of java, this will require adding BouncyCastle as dependency.

New options truststore, trustStorePassword and trustStoreType -

Those options permit the use of a specific truststore that differs from the Java default truststore. This has been added for MariaDB 2.x and MySQL connector compatibility. See

New option connectionCollation -

The Connector is using the utf8mb4 charset per default when establishing a connection. ‘connectionCollation’ can be used to define which utf8mb4 collation should be used. If not set the server default collation for utf8mb4 will be used.

Starting with we recommend to instead set

Support for methods setObject/getObject and setArray/getArray -

This addition is a preparation for the Vector support of MariaDB Server

Example of Array:

Resultset:

Bugs Fixed

• A change of the collation via a session variable might be ignored

• Incorrect default behavior for forceConnectionTimeZoneToSession

  • NOTE: If client and server use different time zones and no timezone options where used, MariaDB Connector/J 3.4 introduces a change which is forcing client timezone to the session. This behavior is an not intended incompatibility change compared to MariaDB Connector/J 3.3, which is corrected in MariaDB Connector/J 3.5 with this change

Changelog

For a complete list of changes made in MariaDB Connector/J 3.5.0, with links to detailed information on each push, see the .

Download Release Notes Changelog

Release date: 25 Sep 2020

MariaDB Connector/J 2.7.0 is a Stable (GA) release.

Notable Changes

• normalization of resultset getDate/getTime of timestamp field.

• DatabaseMetadata.getBestRowIdentifier and getMaxProcedureNameLength correction

• Table with primary key with DEFAULT function can be inserted for 10.5 servers

• MySQLPreparedStatement.setObject can now handle java.lang.Character type

Bugs Fixed

• maxFieldSize string truncation occurs on bytes length, not character length

• Correcting possible Get Access Denied error if using multiple classloader

• setConfiguration not being called on classes that extend ConfigurableSocketFactory

• Switched position of REMARKS and PROCEDURE_TYPE in the getProcedures result

Changelog

For a complete list of changes made in MariaDB Connector/J 2.7.0, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 23 Jul 2020

MariaDB Connector/J 2.6.2 is a Stable (GA) release.

Notable Updates

• - Automatic charset correction

• - SelectResultSet's (ResultSet) MetaData always indicates all columns to be readonly

• - Version parsing depending on Classloader might result in connection Exception

Changelog

For a complete list of changes made in MariaDB Connector/J 2.6.2, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 23 Jun 2020

MariaDB Connector/J 2.6.1 is a Stable (GA) release.

Notable Updates

• - DatabaseMetaData.supportsMultipleResultSets() now return correctly true.

• - Using CallableStatement.getTimestamp() can't get data correctly

• - ParameterMetadata now return parameterCount() even if no information

• - avoid a NPE for malformed "jdbc:mariadb:/" connection string.

• - Temporal Data Tables are not listed in metadata

• - corrected escape sequence for multiple backslash escape

• - Connection.setReadOnly(true ) with option assureReadOnly now force read only connection even for mono server*

• - permit resultset.getRow() for TYPE_FORWARD_ONLY when streaming

• - Connector set UTF8mb4 equivalent in case of server configured with UTF8mb3 collation

• - implement Statement setEscapeProcessing to avoid escape

• - possible race condition using resultset getter using label

• - Missing import org.osgi.service.jdbc in Import-Package clause of the OSGi manifest

• - Logic error in stop() method of OSGi bundle activator

• - Logic error in implementation of OSGi DataSourceFactory (MariaDbDataSourceFactory)

• - resultset metadata always indicate that column is writable even if not

• - ensure connection reference removal on (prepared) Statement close

• - MariaDB Cloud testing

Changelog

For a complete list of changes made in MariaDB Connector/J 2.6.1, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 17 Jun 2019

MariaDB Connector/J 2.4.2 is a Stable (GA) release.

Notes

Evolutions

New option defaultFetchSize to set default fetch size. When set, all statements will be initialized with the indicated fetch size.

Bugs

• : ClassNotFoundException when trying to connect using two-authentication in an OSGI environment.

• : Xid format id is unsigned integer, currently sending as signed value.

• : autoReconnect=true on Basic Failover doesn't reconnect

• : failover might throw an unexpected exception with using "failover"/"sequential" configuration on socket error

Changelog

For a complete list of changes made in MariaDB Connector/J 2.4.2, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 20 Feb 2018

MariaDB Connector/J 2.2.2 is a Stable (GA) release.

Bug Fixes

• [] Never ever throw an instance of java.lang.Error

• [] Keywords missing from DatabaseMetaData.getSQLKeywords()

• [] UrlParser.initialUrl gets overwritten

• [] Permit java 9 serialization filtering

• [] forcing using toLowerCase/toUpperCase with Locale.ROOT

• [] Automatic module name for java 9

• [] windows testing using all mariadb server

• [] Add tests for 10.3.3 INVISIBLE column

Download | Release Notes | Changelog |

Release date: 10 Dec 2020

MariaDB Connector/J 1.7.6 is a Stable (GA) release.

Reporting correction/contribution to java 7 supported version

Bugs Fixed

• : When receiving an RST during connection validation, the pool will end up throwing a connection timeout exception in place of reusing another connection.

• : When using multiple pools and a pool is closed, it closes a global executor used by all pools. This occurs even if there are still other pools open.

• : protocol error when not setting database, indicating null authentication plugin

• : enabledSslProtocolSuites does not include TLSv1.2 by default

| Release Notes | |

Release date: 20 Nov 2024

MariaDB Connector/J 3.5.1 is a (GA) release.

The MariaDB Connector/J 3.5 release series is replacing the maintenance releases for the 3.4 release series, as the new release series is fully compatible with 3.4.

Notable changes

| Release Notes | |

Release date: 25 Aug 2023

MariaDB Connector/J 3.2.0 is a (GA) release. It is replacing 3.1 as the maintenance releases.

| Release Notes | |

Release date: 7 Sep 2018

MariaDB Connector/J 2.3.0 is a (GA) release.

Improve deadlock debugging capabilities

MariaDB has now 2 new options to permit identifying deadlock : New options:

| Release Notes | |

Release date: 9 Nov 2017

MariaDB Connector/J 2.2.0 is a (GA) release.

Features

| Release Notes | |

Release date: 7 Jun 2017

MariaDB Connector/J 2.0.2 is a (GA) release.

Bug

| Release Notes | |

Release date: 26 Sep 2017

MariaDB Connector/J 2.1.2 is a (GA) release.

Bug

| Release Notes | |

Release date: 14 Mar 2018

MariaDB Connector/J 1.7.3 is a (GA) release.

Bug Fixes

| Release Notes | |

Release date: 20 Feb 2018

MariaDB Connector/J 1.7.2 is a (GA) release.

Bug Fixes

Download | Release Notes | Changelog |

Release date: 17 Jul 2024

MariaDB Connector/J 3.4.1 is a Stable (GA) release.

Notable Changes

Implementation of pinGlobalTxToPhysicalConnection for XA Connection

For

The new boolean option pinGlobalTxToPhysicalConnection, when enabled, ensures that an operation for a specific XID is routed to the same connection, to permit supporting XA START <xid> when XA END has been called. This prevent errors like

Enhanced host description

For /

The host description for connecting to the server has been changed from either <host>[:<portnumber>] or address=(host=<host>)[(port=<portnumber>)][(type=(master|slave))] to a more detaild host description, permitting to set localsocket or pipe, and to define a specific ssl mode depending on the host. New format:

Example:

This connection string now permits to use a local unix socket if available, and host 10.0.0.1 with ssl if the unix socket is not available. A detailed host description option supersedes a global option description. The previous example can also be written in the following way, defining different ssl modes for both host options:

Adding databaseTerm alias

For

Option useCatalogTerm has an alias databaseTerm for MySQL connector compatibility.

Bugs Fixed

• The validation of a statement of the cache for prepared statements is not taking the use of different schemas into account, which can result in unexpected behavior when the same statement is executed on different schemas.

• DatabaseMetaData.getImportedKeys returns a different PK_NAME value than DatabaseMetaData.getExportedKeys when using a NON UNIQUE constraint.

• Slow performance of function DatabaseMeta.getExportedKeys()

• Android app incompatibility, regex CANON_EQ flag is not supported on Android OS

Changelog

For a complete list of changes made in MariaDB Connector/J 3.4.1, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 17 May 2024

MariaDB Connector/J 3.4.0 is a Stable (GA) release, and replaces 3.3 as the maintenance releases.

Notable Changes

ZERO-CONFIGURATION SSL ENCRYPTION

Using SSL (a more correct term would be TLS, but in reality SSL is more commonly used) has been simplified with . Before version 11.4, proper SSL configuration required multiple manual steps for the server and all the clients connecting to it.

For MariaDB Connector/J before 3.4 to establish an SSL encrypted connection, or a MariaDB Server release series previous to 11.4, three options can be used:

• Have server certificates generated with trusted Certificate Authorities (CA), using a configuration like: sslMode=verify-full

• Configure the connector using a server certificate, like: sslMode=verify-full&serverSslCert=file:///server-cert.pem

• Disable the verification of the SSL certificate, which is insecure and not recommended, using a configuration like: sslMode=trust

For MariaDB Connector/J 3.4 to establish an SSL encrypted connection to MariaDB Server 11.4, enabling SSL does not require any special configuration apart from using sslMode=verify-full. The connector doesn't need to know the server certificate anymore, as long as the password is not empty.

Changes to Timezone Configuration Options for TIMESTAMPS

The MariaDB Connector/J versions before 3.4 provide a single "timezone" option for working with different time zones for clients and servers. While this functionality remains compatible, it's now separated into two distinct settings:

• connectionTimeZone

• forceConnectionTimeZoneToSession

There are now 3 options that control timestamps behavior in the java connector:

• connectionTimeZone: (LOCAL | SERVER | ) This option defines the connection's time zone. LOCAL retrieves the JVM's default time zone, SERVER fetches the server's global time zone upon connection creation, and allows specifying a server time zone without requesting it during connection establishment.

• forceConnectionTimeZoneToSession: (true | false) This setting dictates whether the connector enforces the connection time zone for the session.

• preserveInstants: (true | false) This option controls whether the connector converts Timestamp values to the connection's time zone.

While remaining compatible with previous versions, this permits more flexibility when handling timezone difference scenarios. See for detailed information.

Add support for connection redirection

Since , the server has a new system variable redirect_url to provide a connection string using the forma mariadb/mysql://[<user>[:<password>]@]<host>[:<port>]/[<db>[?<opt1>=<value1>[&<opt2>=<value2>]]].

When set, all existing connections will be redirected to the designated URL values when appropriate. A connection will only be redirected when no transaction is active.

Example for enabling the redirection:set @@global.redirect_url="mariadb://somehost:3306/"

The redirection feature is enabled by default. It can be disabled by setting the new option permitRedirect to FALSE, which will result in ignoring the redirection URL.

Reduced overhead for issuing queries for retrieving and setting isolation level metadata

When session tracking is supported by the MariaDB Server release series, Connection.getTransactionIsolation() won’t query the server as the current state is already known from the session tracking information. Connection.setTransactionIsolation will skip the query to set the transaction isolation level if the server is already using the requested transaction isolation level.

Bugs Fixed

• Connector/J Version 3 Does Not Respect "nullCatalogMeansCurrent" Property

• Database connection failing on android

• MariaDB Connector 3 no longer supports query timeout with MySQL

• Inconsistency in Handling PreparedStatement.executeQuery() between MariaDB and MySQL Connectors

Changelog

For a complete list of changes made in MariaDB Connector/J 3.4.0, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 15 Nov 2022

MariaDB Connector/J 3.1.0 is a Stable (GA) release.

Performance

Other than features, connector permit significant performance improvements, reaching the same level of performance than c connector

Most significant change are :

• improve performance reading big result-set

• avoid creating array when receiving server packet

• pipelining sent (PREPARE+EXECUTE) are now sent into a single buffer, permitting in some case to have only one TCP-IP packet for 2 mysql packet.

Benchmark using JMH one a single 4 core ubuntu 22.04 server (AWS c5.xlarge) shows :

simple resultset command : "Select 1"

Client side prepared statement parsing : "DO 1000 parameters"

resultset with lots of columns : ""select 1 row from a 100 int columns"

UUID Object support

Since MariaDB server 10.7, a new UUID data format is supported. getter and setter can now pass java.util.UUID parameter (i.e. PrepareStatement setObject(index, ) / Resultset getObject(index, UUID.class) )

Resultset.getObject without class or type precision will now return UUID object for UUID fields by default

UUID metadata

Metadata for UUID fields will now return ResultSetMetaData.getColumnTypeName(index) => "uuid" ResultSetMetaData.getColumnClassName(index) => "java.util.UUID" ResultSetMetaData.getColumnType(index) => Types.OTHER

replacing :

ResultSetMetaData.getColumnTypeName(index) => "CHAR" ResultSetMetaData.getColumnClassName(index) => "java.lang.String" ResultSetMetaData.getColumnType(index) => Types.CHAR

For compatibility, a new option uuidAsString permit to consider UUID as String like previously.

Other changes

• load balance hosts are now chosen using ROUND ROBIN in place of RANDOM

• default value for socket option useReadAheadInput change to false.

Changelog

For a complete list of changes made in MariaDB Connector/J 3.1.0, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 4 May 2021

MariaDB Connector/J 3.0.0 is a Alpha (Alpha) release.

Notable Changes

This version is a complete rewrite of the Java driver. The goal being to have a more performant, easy to read, extendable, small driver.

• Complete rewrite, code simplification / clarification, reduced size (15%), more than 90% coverage tested.

• Performance Improvements:

  • Prepare and execution are now using pipelining when using option useServerPrepStmts

  • Performance enhancement with

SSL configuration

New Options :

The options useSsl, trustServerCertificate, and disableSslHostnameVerification still exist, but sslMode allows for easier configuration.

Easy logging

If using slf4j, just enable the package "org.mariadb.jdbc" log.

• Level ERROR will log connection errors

• Level WARNING will log query errors

• Level DEBUG will log queries

If not using slf4j, console logging will be used.

If you really want to use the JDK logger, the System property "mariadb.logging.fallback" set to JDK will indicate to use common logging.

Failover

The Failover implementation now permits redoing transactions : when creating a transaction, all commands will be cached, and can be replayed in case of failover.

This functionality can be enabled using the option transactionReplay.

This is not enabled by default, because it requires that the application avoid using non-idempotent commands.

Example:

Allow setup of socket TCP_KEEPIDLE, TCP_KEEPCOUNT, TCP_KEEPINTERVAL

Equivalent options are tcpKeepIdle, tcpKeepCount, tcpKeepInterval

Because these are available only with Java 11, setting these options with java < 11 will have no effect.

permit authentication plugin restriction

New Options :

example setting restrictedAuth to "mysql_native_password,client_ed25519,auth_gssapi_client", only those plugins can be use. If server return ask for an authentication plugin not listed in restrictedAuth, driver will throw an exception.

Extendable

The driver is built with a Service Provider Interface (SPI), permitting easy ways to extend the driver.

Possible extensions:

• org.mariadb.jdbc.codec.Codec : Allows encoding/decoding types

• org.mariadb.jdbc.plugin.authentication.AuthenticationPlugin : Allows authentication plugin additions. Defaults are "mysql_clear_password", "auth_gssapi_client", "client_ed25519", "mysql_native_password", "dialog" (PAM), and "caching_sha2_password"

• org.mariadb.jdbc.plugin.credential.CredentialPlugin : Allows login/password retrieval. Defaults are "AwsIamCredentialPlugin" to permit retrieve a temporary IAM authentication, "EnvCredentialPlugin" to get environment authentication, and "PropertiesCredentialPlugin" to get authentication info from java property

Bugs Fixed

• - includeThreadDumpInDeadlockExceptions always includes the thread dump, even when it is not a deadlock exception

• - Properties parameters that differ from string not taken in account

Changelog

For a complete list of changes made in MariaDB Connector/J 3.0.0, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 3 Oct 2019

MariaDB Connector/J 2.5.0 is a Release Candidate (RC) release.

Evolutions

Authentication service

are now defined as services. This permits to easily add new client authentication plugins. The driver has 2 new plugins caching_sha2_password and sha256_password plugin for MySQL compatibility

List of authentication plugins in java connector :

• mysql_clear_password

• auth_gssapi_client

• client_ed25519

• mysql_native_password

New authentication plugins can be created implementing interface org.mariadb.jdbc.authentication.AuthenticationPlugin, and listing new plugin in a META-INF/services/org.mariadb.jdbc.authentication.AuthenticationPlugin file.

Credential service

Credentials are usually set using user/password in the connection string or by using DriverManager.getConnection(String url, String user, String password).

Credential plugins permit to provide credential information from other means. Those plugins have to be activated setting option credentialType to designated plugin.

The driver has 3 default plugins :

AWS IAM

This permits AWS database IAM authentication. The plugin generate a token using IAM credential and region. Token is valid for 15 minutes and cached for 10 minutes.

To use this credential authentication, com.amazonaws:aws-java-sdk-rds dependency must be registred in classpath. Implementation use SDK DefaultAWSCredentialsProviderChain and DefaultAwsRegionProviderChain to get IAM credential and region. see and to check how those information can be retrieved (environment variable / system properties, files, ...)

Example: jdbc:mariadb://host/db?credentialType=AWS-IAM&useSsl&serverSslCert=/somepath/rds-combined-ca-bundle.pem

with AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY and AWS_REGION environment variable set.

Environment

User and Password are retrieved from environment variables. default environment variables are MARIADB_USER and MARIADB_PWD, but can be changed by setting additional option userKey and pwdKey

Example : using connection string jdbc:mariadb://host/db?credentialType=ENV user and password will be retrieved from environment variable MARIADB_USER and MARIADB_PWD.

Property

User and Password are retrieved from java properties. default property name are mariadb.user and mariadb.pwd, but property names can be changed by setting additional option userKey and pwdKey

Example : using connection string jdbc:mariadb://host/db?credentialType=PROPERTY&userKey=mariadbUser&pwdKey=mariadbPwd user and password will be retrieved from java properties mariadbUser and mariadbPwd

SSL factory service

A connection to a server initially creates a socket. When set, SSL socket is layered over this existing socket. Implementing org.mariadb.jdbc.tls.TlsSocketPlugin permit to provide custom SSL implementation for example create a new implementation.

Custom implementation need to implement org.mariadb.jdbc.tls.TlsSocketPlugin and register service META-INF/services/org.mariadb.jdbc.tls.TlsSocketPlugin

Custom implementation are activated using option tlsSocketType

Other

• : JDBC 4.3 partial implementation java.sql.Statement methods isSimpleIdentifier, enquoteIdentifier, enquoteLiteral and enquoteNCharLiteral

• : ConnectionPoolDataSource interface addition to MariaDbPoolDataSource

• : closing possible option batch thread on driver deregistration.

Bug fixes

• : Driver getPropertyInfo returns no options information when url is empty

• : DatabaseMetaData.getSchemaTerm now return "schema", not empty string

New options

Changelog

For a complete list of changes made in MariaDB Connector/J 2.5.0, with links to detailed information on each push, see the .

Download | Release Notes | Changelog |

Release date: 29 Jan 2019

MariaDB Connector/J 2.4.0 is a Stable (GA) release.

[CONJ-654] change metadata behaviour: DatabaseMetaData.getDatabaseProductName() nows return "MariaDB"/"MySQL" according to server. This can cause some incompatibilities with some libraries and products that do not yet know Database Type "MariaDB"

Evolutions

• : permit multiple alternative authentication methods for the same user ()

• : permit indication of truststore/keystore type (JKS/PKCS12), then not relying on java default type

• : GSSAPI: client can provide SPN

• : Support MYSQL_TYPE_JSON datatype

New options

Bug fixes

• : possible NullPointerException when connection lost to database using aurora configuration with one node

• : batch using multi-send can hang when using query timeout

• : disable SSL session resumption when using SSL

• : correcting Clob.length() for utf8mb4

Minor

• : small optimization when validating galera connection

• : add coverage test

• : DatabaseMetaData.getDriverName() returns connector/J with a lowercase c, DatabaseMetaData.getDatabaseProductName() "MariaDB"/"MySQL" according to server

Download | Release Notes | Changelog |

Release date: 6 Sep 2017

MariaDB Connector/J 2.1.1 is a Stable (GA) release.

Bug

• [] Updatable result-set possible NPE when same field is repeated.

• [] ResultSet method wasNull() always return true after a call on a "null-date" field binary protocol handling

• [] Permit using updatable result-set when fetching

• [] Add legacy SSL certificate Hostname verification with CN even when SAN are set

• [] Improve MariaDB driver stability in case JNA errors

Misc

• correct typo in error message when setting wrong parameter

• add trace to HostnameVerifier implementation

• handling connection error when no database is provided