Contact MySQL |
Login | Register
Table of Contents [+/-]
This section provides some general JDBC background.
I think that the usage of parameter dontTrackOpenResources=true should be emphasized with an example (or default set to "true").The novice user will most likely overlook the description of this parameter in the long parameter list provided, and end-up with an annoying and "hard-to-explain" memory-leak behaviour of his/her application. It should be clearly pointed out that the connector's close() method for ResultSet and Statement does not fully comply with the Interface specification when dontTrackOpenResources=false (as it does NOT release immediately all JDBC resources).
There is one important thing however you need to remember before invoking the "prepareCall()" method, the mysql "user" you are using should have at least "SELECT" privilege on the `mysql`.`proc` table, else you will get the following exception :-"java.sql.SQLException:User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types."Or Alternatively you Could listen to the above exception and configure your connection URL likewise.