MySQL Bugs: #36075: Problem in calling stored procedure

Bug #36075	Problem in calling stored procedure
Submitted:	15 Apr 2008 5:00	Modified:	26 Apr 2013 8:11
Reporter:	ani ani	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / J	Severity:	S1 (Critical)
Version:	5.0.26	OS:	Windows (Windows 2000)
Assigned to:	Alexander Soklakov	CPU Architecture:	Any
Tags:	PROCEDURE, Procedure calling

Description:
I have written the following procedure for deleting records from some tables.
DELIMITER $$
DROP PROCEDURE IF EXISTS `mcams`.`tempDelete` $$
CREATE DEFINER=`root`@`%` PROCEDURE `tempDelete`( )
begin
delete FROM intertourbattingscoresheet ;
delete FROM intertourbowlingscoresheet;
delete FROM intertourclubmaster;
delete FROM intertourscoresheet;
delete FROM  intertourwktkeeperscoresheet;
delete FROM intertourmatchmaster;
delete FROM intertourcategorymaster;
delete FROM intertourdefmaster;
end $$

DELIMITER ;

I am calling it from my JAVA class by following way 

public boolean updateIntranetTemp(Connection conn) throws SQLException
	{
		CallableStatement calstat = null;
		boolean blnUpdate=false;
		System.out.println("********* IN updateIntranetTemp **********");
		try {
			calstat = conn.prepareCall("{call tempDelete()}");
			blnUpdate = calstat.execute();
			System.out.println("***** blnUpdate *********:---"+blnUpdate);
		}finally{
			if(calstat != null)
			calstat.close();
		}
		return blnUpdate;
	}//end of updateIntranetTemp

But it is giving me 'false'  values return after execution .
Is there any thing wrong in it .
Your help will be preciatous for me.

How to repeat:
create procedure first
Then simply call it from Java Class

Thank you for a problem report. What exact version of Connector/J do you use?

MySql version 5.0.26

You already noted server version (it is ages old, by the way, try to use 5.0.51a, if possible). I asked about Connector/J's version you used to connect to MySQL server.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hi Ani,

There is no feedback since apr 2008, so I close this report as "Can't repeat".
Please, feel free to reopen it if the problem still exists with current driver versions.