Bump org.mariadb.jdbc:mariadb-java-client from 2.7.9 to 3.4.0

[dependabot[bot]]

Bumps org.mariadb.jdbc:mariadb-java-client from 2.7.9 to 3.4.0.

Release notes

Sourced from org.mariadb.jdbc:mariadb-java-client's releases.

MariaDB Connector/Java 3.3.3

3.3.3 (Feb 2024)

Full Changelog

Bugs Fixed

• CONJ-1050 regression in 3.x.y: nonparameterized batch "INSERT INTO products( name ) VALUES ( 'aaaa' )" fails
• CONJ-1150 Error using PrepareStatement.setURL with null url
• CONJ-1152 Improve message when reaching socket timeout during connection initial commands

MariaDB Connector/Java 3.3.2

3.3.2 (Dec 2023)

Full Changelog

Bugs Fixed

• CONJ-1117 new option returnMultiValuesGeneratedIds for connector 2.x compatibility, so getGeneratedKeys() return all ids of multi-value inserts
• CONJ-1140 regression caussing ClassCastException on DatabaseMetaData when use with option defaultFetchSize set
• CONJ-1129 Metadata.getPrimaryKeys table comparison using like in place of strict equality
• CONJ-1130 ensuring batch parameter are cleared after SQL Failure
• CONJ-1131 NullPointerException when Calling getGeneratedKeys() after an SQL Failure
• CONJ-1132 Ensuring reseting result for getUpdateCount() after an SQL Failure
• CONJ-1135 ensuring BULK command not used when using INSERT ON DUPLICATE KEY UPDATE in order to always have unique affected rows by default
• CONJ-1136 wrong decoding for Resultset.getByte() results for binary varchar fields
• CONJ-1137 ensuring never having NPE in OkPacket when setting auto commit
• CONJ-1138 Inconsistency in Behavior of PreparedStatement After closeOnCompletion() Between MariaDB and MySQL Connectors
• CONJ-1049 Metadata getTableTypes result was not ordered by TABLE_TYPE

MariaDB Connector/Java 3.3.1

3.3.1 (Nov 2023)

Full Changelog

Bugs Fixed

• CONJ-1120 java 8 compatibility error in 3.3.0
• CONJ-1123 missing OSGi javax.crypto dependency
• CONJ-1124 ensure not having OOM when setting huge fetch size
• CONJ-1109 Regression in clearBatch() for parameterized statements
• CONJ-1126 setting fetchSize directly on a ResultSet object does not reflect the expected change
• CONJ-1127 Statement.getResultSetType () failed to change the result set type
• CONJ-1128 Setting Negative Fetch Size on ResultSet Without Throwing Error

MariaDB Connector/Java 3.3.0

3.3.0 (Nov 2023)

... (truncated)

Changelog

Sourced from org.mariadb.jdbc:mariadb-java-client's changelog.

3.4.0 (Apr 2024)

Full Changelog

Notable Changes

• CONJ-981 Add support for connection redirection
• CONJ-1087 handle mariadb-11.1+ transaction_isolation
• CONJ-1100 Be able to filter system tables and views
• CONJ-1105 TLS certificate validation without needs to provide certificate client side
• CONJ-1171 timezone support missing feature
• CONJ-1173 Bulk implementation returning individual results for MariaDB 11.5
• CONJ-1154 avoid unnecessary set transaction isolation queries

Bugs Fixed

• CONJ-1103 Connector/J Version 3 Does Not Respect "nullCatalogMeansCurrent" Property
• CONJ-1161 Database connection failing on android
• CONJ-1107 MariaDB Connector 3 no longer supports query timeout with MySQL
• CONJ-1125 Inconsistency in Handling PreparedStatement.executeQuery() between MariaDB and MySQL Connectors
• CONJ-1156 getTables should be ordered as expected
• CONJ-1163 jdbcCompliantTruncation Does Not Appear To Be Working
• CONJ-1164 Variable initialization ahead of LOAD DATA INFILE not possible by validateLocalFileName pattern
• CONJ-1168 useBulkStmts compatibility value with pre 3.2 version
• CONJ-1169 improve Client prepared statement setMaxRows implementation
• CONJ-1170 OFFSET missing from getSQLKeywords
• CONJ-1158 DatabaseMetaData#getFunctions's result not property ordered
• CONJ-1159 DatabaseMetaData#getClientInfoProperties not ordered correctly
• CONJ-1166 Implement connection properties fallbackToSystemKeyStore and fallbackToSystemTrustStore
• CONJ-1174 ConnectorJ gives precision of 20 for signed bigint

3.3.3 (Feb 2024)

Full Changelog

Bugs Fixed

• CONJ-1050 regression in 3.x.y: nonparameterized batch "INSERT INTO products( name ) VALUES ( 'aaaa' )" fails
• CONJ-1150 Error using PrepareStatement.setURL with null url
• CONJ-1152 Improve message when reaching socket timeout during connection initial commands

3.3.2 (Dec 2023)

Full Changelog

Bugs Fixed

• CONJ-1117 new option returnMultiValuesGeneratedIds for connector 2.x compatibility, so getGeneratedKeys() return all ids of multi-value inserts
• CONJ-1140 regression caussing ClassCastException on DatabaseMetaData when use with option defaultFetchSize set
• CONJ-1129 Metadata.getPrimaryKeys table comparison using like in place of strict equality

... (truncated)

Commits

• c19f608 [misc] code simplification
• 92d8414 Merge branch 'develop'
• 474e969 bump 3.4.0
• c9786f2 [CONJ-1173] Bulk implementation returning individual results
• da50647 [misc] metadata ensure correct join in case of using catalog in the future
• 4a0b526 [CONJ-1171] ensure compatibility with 3.x current behavior
• 0a7a094 [CONJ-1174] wrong value for ResultSetMetaData.getPrecision() signed numeric
• 365d6a3 [misc] avoid fallthrough warning
• e0aff1e [misc] avoid checking redirection for empty string value
• 4567d3b [CONJ-1171] timezone new options
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[phuongnq]

@sumerjabri I created PRs to update MariaDB4j to support this mariadb-java-client upgrade to v3. In v3, we will need to add permitMysqlScheme to the connection string while securing the MariaDB instance. Please refer the details here: https://mariadb.com/kb/en/about-mariadb-connector-j/#jdbcmysql-scheme-compatibility

I updated MariaDB4j to 3.1.0.2 to add this flag. MariaDB4j needs to be merged and published a new version first before merging the PR for craftercms/craftercms. This PR can be closed to use the new one here: https://github.com/craftercms/craftercms/pull/6877

[sumerjabri]

@dependabot recreate

[dependabot[bot]]

Looks like org.mariadb.jdbc:mariadb-java-client is up-to-date now, so this is no longer needed.