The moose likes Tomcat and the fly likes Function does not Exist Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Tomcat
Reply locked New topic

Function does not Exist

Srividhya Kiran
Ranch Hand

Joined: Feb 17, 2008
Posts: 166
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.

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Please don't post the same question in more than one forum.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Srividhya Kiran
Ranch Hand

Joined: Feb 17, 2008
Posts: 166
Sorry not sure about the exact forum to post this question.
I agree. Here's the link: http://aspose.com/file-tools
subject: Function does not Exist
Similar Threads
No operations allowed after statement closed.
Using PreparedStatement
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException
Unable to connect to MYSQL through eclipse
Function does not exist