Function does not Exist

[Srividhya Kiran]

Hello All

I am getting this exception

 1. FUNCTION myproc does not exist  
   2. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION myproc does not exist  
   3.         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)  
   4.         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)  
   5.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)  
   6.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)  
   7.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)  
   8.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)  
   9.         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)  
  10.         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)  
  11.         at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)  
  12.         at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1589)  
  13.         at com.mysql.jdbc.DatabaseMetaData.getProcedureOrFunctionColumns(DatabaseMetaData.java:4136)  
  14.         at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:4073)  
  15.         at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:828)  
  16.         at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:626)  
  17.         at com.mysql.jdbc.CallableStatement.getInstance(CallableStatement.java:519)  
  18.         at com.mysql.jdbc.ConnectionImpl.parseCallableStatement(ConnectionImpl.java:3916)  
  19.         at com.mysql.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:4000)  
  20.         at com.mysql.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:3974)  
  21.         at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareCall(DelegatingConnection.java:275)  
  22.         at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareCall(PoolingDataSource.java:292)  

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:

<Resource name="jdbc/MYDB1" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="root" password="xxxx" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/mydb?autoReconnect=true"/>

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]

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

[Srividhya Kiran]

Sorry not sure about the exact forum to post this question.