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

[15 Apr 2008 5:00] ani ani
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
[15 Apr 2008 10:03] Valeriy Kravchuk
Thank you for a problem report. What exact version of Connector/J do you use?
[15 Apr 2008 11:58] ani ani
MySql version 5.0.26
[15 Apr 2008 12:07] Valeriy Kravchuk
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.
[15 May 2008 23:00] Bugs System
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".
[26 Apr 2013 8:11] Alexander Soklakov
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.