-
New Feature
-
Resolution: Fixed
-
Minor
-
None
Currently MySql is supported, but not the MariaDB fork.
Problem Description
For using Jenkins in comercial enviroment it would be creat to support MariaDB too.
It is fully compatible with MySql 5.7. Using MariaDB-Server results in the following Warning (but works):
Non validated MySQL version 5.5.5-10.2.20-MariaDB. MySQL Server version 5.7+ or Amazon Aurora MySQL 5.6+ is required
Discovering introspecting the JDBC driver metadata that it's MariaDB
docker run -e MYSQL_ROOT_PASSWORD=mypass -e MYSQL_DATABASE=jenkins -e MYSQL_USER=jenkins -e MYSQL_PASSWORD=jenkins -p 3307:3306 -d mariadb/server:latest
| Property Name | Value |
|---|---|
| JDBC Driver CLASSNAME | com.mysql.jdbc.Driver |
| JDBC Driver CLASSPATH | No files specified in 'Extra ClassPath' tab for driver |
| getURL | jdbc:mysql://localhost:3307/jenkins |
| isReadOnly | false |
| getRowIdLifetime | ROWID_UNSUPPORTED |
| supportsStoredFunctionsUsingCallSyntax | true |
| autoCommitFailureClosesAllResultSets | false |
| getClientInfoProperties | |
| generatedKeyAlwaysReturned | true |
| getMaxLogicalLobSize | 0 |
| supportsRefCursors | false |
| getResultSetHoldability | 1 |
| getUserName | jenkins@172.17.0.1 |
| supportsCatalogsInTableDefinitions | true |
| supportsSchemasInTableDefinitions | false |
| getDriverName | MySQL Connector/J |
| getCatalogSeparator | . |
| storesMixedCaseIdentifiers | true |
| storesUpperCaseIdentifiers | false |
| getDatabaseProductName | MySQL |
| getDatabaseProductVersion | 5.5.5-10.3.11-MariaDB-1:10.3.11+maria~bionic |
| getDatabaseMajorVersion | 5 |
| getIdentifierQuoteString | ` |
| supportsSchemasInDataManipulation | false |
| supportsStoredProcedures | true |
| supportsSavepoints | true |
| getCatalogTerm | database |
| getSchemaTerm | |
| getProcedureTerm | PROCEDURE |
| supportsCatalogsInDataManipulation | true |
| supportsCatalogsInProcedureCalls | true |
| supportsMultipleResultSets | true |
| getJDBCMajorVersion | 4 |
| getJDBCMinorVersion | 2 |
| supportsNamedParameters | false |
| supportsMultipleOpenResults | true |
| supportsGetGeneratedKeys | true |
| getDatabaseMinorVersion | 5 |
| getSQLStateType | 2 |
| locatorsUpdateCopy | true |
| supportsStatementPooling | false |
| allProceduresAreCallable | false |
| allTablesAreSelectable | false |
| nullsAreSortedHigh | false |
| nullsAreSortedLow | true |
| nullsAreSortedAtStart | false |
| nullsAreSortedAtEnd | false |
| getDriverVersion | mysql-connector-java-8.0.13 (Revision: 66459e9d39c8fd09767992bc592acd2053279be6) |
| getDriverMajorVersion | 8 |
| getDriverMinorVersion | 0 |
| usesLocalFiles | false |
| usesLocalFilePerTable | false |
| supportsMixedCaseIdentifiers | true |
| storesLowerCaseIdentifiers | false |
| supportsMixedCaseQuotedIdentifiers | true |
| storesUpperCaseQuotedIdentifiers | true |
| storesLowerCaseQuotedIdentifiers | false |
| storesMixedCaseQuotedIdentifiers | true |
| getSearchStringEscape | \ |
| getExtraNameCharacters | #@ |
| supportsAlterTableWithAddColumn | true |
| supportsAlterTableWithDropColumn | true |
| supportsColumnAliasing | true |
| nullPlusNonNullIsNull | true |
| supportsConvert | false |
| supportsTableCorrelationNames | true |
| supportsDifferentTableCorrelationNames | true |
| supportsExpressionsInOrderBy | true |
| supportsOrderByUnrelated | false |
| supportsGroupBy | true |
| supportsGroupByUnrelated | true |
| supportsGroupByBeyondSelect | true |
| supportsLikeEscapeClause | true |
| supportsMultipleTransactions | true |
| supportsNonNullableColumns | true |
| supportsMinimumSQLGrammar | true |
| supportsCoreSQLGrammar | true |
| supportsExtendedSQLGrammar | false |
| supportsANSI92EntryLevelSQL | true |
| supportsANSI92IntermediateSQL | false |
| supportsANSI92FullSQL | false |
| supportsIntegrityEnhancementFacility | false |
| supportsOuterJoins | true |
| supportsFullOuterJoins | false |
| supportsLimitedOuterJoins | true |
| isCatalogAtStart | true |
| supportsSchemasInProcedureCalls | false |
| supportsSchemasInIndexDefinitions | false |
| supportsSchemasInPrivilegeDefinitions | false |
| supportsCatalogsInIndexDefinitions | true |
| supportsCatalogsInPrivilegeDefinitions | true |
| supportsPositionedDelete | false |
| supportsPositionedUpdate | false |
| supportsSelectForUpdate | true |
| supportsSubqueriesInComparisons | true |
| supportsSubqueriesInExists | true |
| supportsSubqueriesInIns | true |
| supportsSubqueriesInQuantifieds | true |
| supportsCorrelatedSubqueries | true |
| supportsUnion | true |
| supportsUnionAll | true |
| supportsOpenCursorsAcrossCommit | false |
| supportsOpenCursorsAcrossRollback | false |
| supportsOpenStatementsAcrossCommit | false |
| supportsOpenStatementsAcrossRollback | false |
| getMaxBinaryLiteralLength | 16777208 |
| getMaxCharLiteralLength | 16777208 |
| getMaxColumnNameLength | 64 |
| getMaxColumnsInGroupBy | 64 |
| getMaxColumnsInIndex | 16 |
| getMaxColumnsInOrderBy | 64 |
| getMaxColumnsInSelect | 256 |
| getMaxColumnsInTable | 512 |
| getMaxConnections | 0 |
| getMaxCursorNameLength | 64 |
| getMaxIndexLength | 256 |
| getMaxSchemaNameLength | 0 |
| getMaxProcedureNameLength | 0 |
| getMaxCatalogNameLength | 32 |
| getMaxRowSize | 2147483639 |
| doesMaxRowSizeIncludeBlobs | true |
| getMaxStatementLength | 65531 |
| getMaxStatements | 0 |
| getMaxTableNameLength | 64 |
| getMaxTablesInSelect | 256 |
| getMaxUserNameLength | 16 |
| getDefaultTransactionIsolation | TRANSACTION_READ_COMMITTED |
| supportsTransactions | true |
| supportsDataDefinitionAndDataManipulationTransactions | false |
| supportsDataManipulationTransactionsOnly | false |
| dataDefinitionCausesTransactionCommit | true |
| dataDefinitionIgnoredInTransactions | false |
| supportsBatchUpdates | true |
Discovering running SQL queries that it's MariaDB
MariaDB Docker image
docker run -e MYSQL_ROOT_PASSWORD=mypass -e MYSQL_DATABASE=jenkins -e MYSQL_USER=jenkins -e MYSQL_PASSWORD=jenkins -p 3307:3306 -d mariadb/server:latest
SELECT VERSION();
10.3.11-MariaDB-1:10.3.11+maria~bionic
MariaDB Centos
official MariaDB (Centos-Repo from https://downloads.mariadb.org/mariadb/repositories/):
SELECT VERSION();
10.3.11-MariaDB
