[FLINK-29060] can not set rewriteBatchedStatements parameter for JDBC catalog for MySQL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.15.1
• Fix Version/s: 1.20.0
• Component/s: Connectors / JDBC
• Assignee: Unassigned
• Reporter: macdoor615
• Created: 22/Aug/22 11:00
• Updated: 11/Mar/24 12:43

Description

execute following code in sql-client.sh

CREATE CATALOG mysql_bnpmp3 WITH(
 'type' = 'jdbc',
 'default-database' = 'gem_tmp',
 'username' = 'bnpmp',
 'password' = '*********',
 'base-url' = 'jdbc:mysql://hb3-prod-mysql:32759?rewriteBatchedStatements=true'
);

output an error

[ERROR] Could not execute SQL statement. Reason:
java.lang.IllegalArgumentException: No enum constant com.mysql.cj.conf.BooleanPropertyDefinition.AllowableValues."TRUE"/GEM_TMP

rewriteBatchedStatements is a very import parameter, without it, data insertion performance will be very poor. 

I found a trick to overcome this problem. I changed jdbcUrl format and it works.

CREATE CATALOG mysql_bnpmp WITH(
    'type' = 'jdbc',
    'default-database' = 'gem_tmp',
    'username' = 'bnpmp',
    'password' = '*******',
    'base-url' = 'jdbc:mysql://(host=hb3-prod-mysql,port=32759,rewriteBatchedStatements=true)'
);