How to define the MySQL connection string in Information Designer to use noAccessToProcedureBodies parameter

How to define the MySQL connection string in Information Designer to use noAccessToProcedureBodies parameter

The parameter noAccessToProcedureBodies is used in the JDBC connection string for cases when a procedure is created by another user (DEFINER) which is different than the calling user. If it is set to true and user cannot access the procedure body with SHOW CREATE PROCEDURE or from mysql.proc then the driver will treat all parameters as IN VARCHAR (but still allowing to call registerOutParameter on them) and no exception will be thrown. This may be required when you are creating your MySQL Data Source template in the Information Designer. The following is an example MySQL JDBC connection string format which includes the noAccessToProcedureBodies parameter:

jdbc:mysql://ipaddress:3306/test?noAccessToProcedureBodies=true

External: 5.1 Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J:

• https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html

External: noAccessToProcedureBodies with JDBC, MySQL stored procedure and Java/JSP

• https://www.jvmhost.com/articles/noaccesstoprocedurebodies-with-jdbc-mysql-stored-procedure-and-java-jsp/