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

This article explains how to define the connection string to use the noAccessToProcedureBodies parameter when connecting to MySQL server
 

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. 

Resolution:

The following is an example MySQL JDBC connection string format which includes the noAccessToProcedureBodies parameter:

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

References:

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/