Unable to retrieve metadata for procedure.

[Jaidev Arer]

I am calling a stored procedure from my dao object. But i am getting the Unable to retrieve metadata for procedure. error
Dao code

 public String updateLitres(int litres,String fromdate,int customer_id) throws SQLException 
{
try 
	{
	 String proc3StoredProcedure = "{ oxy_update_delivery_changes(?,?) }";
	    CallableStatement cs = conn.prepareCall(proc3StoredProcedure);
	    cs.setInt(1, customer_id);
	    cs.setInt(2, litres);
	    cs.execute();
	    conn.close();
	}
	catch (Exception e) 
	{
	e.printStackTrace();
}
return null;
}   

If the stored procedure is executed at the back end its working properly. The problem i am facing is during calling it from the java(front end)
Error

   java.sql.SQLException: Unable to retrieve metadata for procedure.
	at com.mysql.jdbc.CallableStatement.extractProcedureName(CallableStatement.java:657)
	at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:496)
	at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:401)
	at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4072)
	at com.mysql.jdbc.Connection.prepareCall(Connection.java:4146)
	at com.mysql.jdbc.Connection.prepareCall(Connection.java:4120)
	at app.dao.mydao.dao.updateLitres(dao.java:518)
	at app.AdminSubmit.perform(AdminSubmit.java:66)
	at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source) 

Please guide.
Thanks

[Jan Cumps]

This post on another forum says you have to call a stored procedure (i.e.: put a call before the procedure name).


... StoredProcedure = "{ call oxy ...

Regards, Jan

[Jaidev Arer]

Thanks a lot.
You made my day. was debugging this from past two hours.