Lucee MariaDB Extension

This extension installs the MariaDB Connector/J Type 4 JDBC driver for creating MariaDB data sources in Lucee Server. It is an alternative to the generic MySQL driver.

Installation

via Forgebox

1. In your Lucee Administrator, go to the Extension > Providers page and add https://forgebox.io as a New Extension Provider if not already present
2. Go to Extension > Applications and look for MariaDB in the "Not installed" section
3. Click the extension and install

Manual

1. Download the the lucee-mariadb.lex file
2. In your Lucee Administrator, go to the Extension > Applications page
3. Under "Upload new extension", select the lex file and click "Upload"

Usage

Once installed you can either create datasources in the Lucee Administrator using the newly added "MariaDB" type, or you can define them in your Application.cfc as follows:

this.datasource = {
	class: "org.mariadb.jdbc.Driver"
	,connectionString: "jdbc:mariadb: //[hostname]:[port]/[database]?<parameter>=<value>"
	,username: [username]
	,password: [password]
	//other options if required
};

More details on defining Lucee datasources

Full driver documentation

Migration from the MySQL driver

Note that when inserting records into tables with an auto-increment primary key, the MySQL driver returns the new primary key value in two variables in the query result:

GENERATED_KEY
generatedKey

However the MariaDB driver returns the value in the following variables:

generatedKey
insert_id

Before switching drivers, you should therefore check that your code is using generatedKey and not GENERATED_KEY.

UNIX socket connections

The extension supports local UNIX Domain Socket connections out of the box. This is a potentially more performant and secure alternative to password authenticated connections over TCP on NIX based systems where the database server is on the same local host. Simply specify the socket path in your datasource definition in Application.cfc:

this.datasource = {
	class: "org.mariadb.jdbc.Driver"
	,connectionString: "jdbc:mariadb: //localhost/[yourdatabase]?localSocket=/tmp/mariadb/mysqld.sock"
	,username: [username]
	,password: [password]
	//other options if required
};

Replace [yourdatabase] with the name (minus brackets) of database. To verify your database's local socket path execute the following query: SELECT @@socket. Note that a port is not required.

Credits

Inspiration came from Bruce Kirkpatrick.