[CONJ-1077] Add `rewriteBatchedStatements` option in Mariadb CONJ for MySql database compatibility. - Jira

XML

Word

Printable

Details

Type: New Feature
Status: Closed (View Workflow)
Priority: Major
Resolution: Won't Do
Affects Version/s: 3.0.0, 3.0.3, 3.0.4, 3.0.5, 3.0.6, 3.0.7, 3.0.8, 3.0.9, 3.1.0, 3.0.10, 3.1.1, 3.1.2, 3.1.3, 3.1.4
Fix Version/s: N/A
Component/s: JDBC compatibility, MySQL compatibility
Labels:

Description

Add `rewriteBatchedStatements` option in Mariadb CONJ for MySql database compatibility. The support for Add `rewriteBatchedStatements` option is removed from the driver from version `3..`, this was good for performance with MySql database. Currently there is no alternate option (other than writing query manually) to do bulk updates to MySql database, The new options `useBulkStmts` uses protocol `COM_STMT_BULK_EXECUTE`, which is no supported for MySql so services using Mriadb CONJ will be at performance loss. Everyone prefers Mariadb CONJ because of its better performance than MySql connector/j and LGPL license, So it would be very nice to have back the `rewriteBatchedStatements` option in the new versions.

Attachments

Activity

People

Assignee:: Diego Dupin

Reporter:: Pranjal Gupta

Votes:: 1 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2023-05-15 14:32

Updated:: 2023-12-15 13:25

Resolved:: 2023-12-15 13:25

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.