Technical Reference Document: MYSql Update error "Parameter metadata not available for the given statement"

When updating complex data types such as BLOB, CLOB, XML, JSON columns you may see the metadata not available error. This error is caused as by default MYSql does not generate parameter metadata that is required by Andi during SQL processing. To generate the metadata, you must add a parameter to your JDBC connection URL to tell MYSql to generate the parameter data if it doesn't exist.

The bolded parameter below indicates that MYSql should generate the parameter data. Note the & seperator which is required if this will be connection parameter 2 or more. 

jdbc:mysql://localhost:3306/andi?sslMode=REQUIRED&generateSimpleParameterMetadata=true