Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
    Bookmark Topic Watch Topic
  • New Topic

Function does not Exist

 
Srividhya Kiran
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hello All

I am getting this exception





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

unix platform
tomcat 6.0.18
mysql 5.0.67
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:

view plaincopy to clipboardprint?

1. GRANT ALL ON mydb.* TO 'root'@'%' IDENTIFIED BY 'xxxx';

GRANT ALL ON mydb.* TO 'root'@'%' IDENTIFIED BY 'xxxx';

And When I execute

view plaincopy to clipboardprint?

1. Show Create Procedure mydb.myproc;

Show Create Procedure mydb.myproc;

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.

Any help or suggestion would be appreciated.

Thanks
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please don't post the same question in more than one forum.
 
Srividhya Kiran
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Report post to moderator
Sorry not sure about the exact forum to post this question.
 
    Bookmark Topic Watch Topic
  • New Topic