EDIT

import eu.etaxonomy.cdm.database.types.MariaDbDatabaseType;

    MariaDB(12),  //not yet tested

            case 12:

                this.dbType = new MariaDbDatabaseType(); break;

                throw new RuntimeException("Database type not handled");

        }else if (product.toLowerCase().matches("\\.*mariadb\\.*")) {

            return MariaDB;

/**

* Copyright (C) 2007 EDIT

* European Distributed Institute of Taxonomy

* http://www.e-taxonomy.eu

*

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.database.types;

import org.hibernate.dialect.Dialect;

import org.hibernate.dialect.MySQL5MyISAMUtf8Dialect;

import eu.etaxonomy.cdm.database.ICdmDataSource;

/**

 * @author a.mueller

 *

 */

public class MariaDbDatabaseType extends DatabaseTypeBase {

	//typeName

	protected String typeName = "MariaDB";

	//class

	protected String classString = "com.mariadb.jdbc.Driver";

	//url

    protected String urlString = "jdbc:mariadb://";

    //port

    private final int defaultPort = 3306;

    private static String dbSeparator = "/";

    //hibernate dialect

    // see #3371 (switch cdm to MySQL InnoDB)

//    private Dialect hibernateDialect = new MySQL5InnoDBUtf8Dialect();

    //MariaDB specific dialect starts with hibernate 5.2.8 only

//    https://stackoverflow.com/questions/37066024/what-is-the-mariadb-dialect-class-name-for-hibernate

    private Dialect hibernateDialect = new MySQL5MyISAMUtf8Dialect();

    //connection String

	@Override

    public String getConnectionString(ICdmDataSource ds, int port){

        return urlString + ds.getServer() + ":" + port + dbSeparator + ds.getDatabase() + "?useUnicode=true&characterEncoding=utf8" + "&zeroDateTimeBehavior=convertToNull";

        //return urlString + ds.getServer() + ":" + port + "/" + ds.getDatabase() + "?useUnicode=true&characterEncoding=utf8&connectionCollation=utf8_general_ci&characterSetResults=utf8&jdbcCompliantTruncation=false";

    }

    @Override

    public String getDatabaseNameByConnectionString(String connectionString){

    	String result;

    	result = getDatabasePartOfConnectionString(connectionString, dbSeparator);

    	if(result == null) {

    		return null;

    	}

    	int posParams = result.indexOf("?");

    	if (posParams != -1){

    		result = result.substring(0, posParams);

    	}

     	return result;

    }

    /**

     * Constructor

     */

    public MariaDbDatabaseType() {

    	init (typeName, classString, urlString, defaultPort,  hibernateDialect );

	}

}