I get this exception after I log into application after a specified period of time or when I log in for the first time. when I try to re login immediately after I get this exception it works fine. The environment I am running my application is
mysql-connector-java-5.1.7-bin is the jdbc connector I am using.
My connection pool defined in tomcat context.xml:
I have set the permission:
And When I execute
I am able to see the entire body of the procedure.
And one more point is I get this exception only when i run my application on my remote server which runs on unix platform and not on my local machine which runs on windows.