Related Documentation Download this Manual Excerpts from this Manual


This page has moved or been replaced. The new page is located here:

Please update any bookmarks that point to the old page.

Download this Manual
User Comments
  Posted by francesco antoci on May 31, 2007
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).
  Posted by stephen d on July 22, 2009
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.
Sign Up Login You must be logged in to post a comment.