Bug #29208 CALLABLE STATEMENT
Submitted: 19 Jun 2007 12:45 Modified: 31 Mar 2014 14:41
Reporter: AMITA JAYASWAL Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:5.0 OS:Windows
Assigned to: Alexander Soklakov CPU Architecture:Any

[19 Jun 2007 12:45] AMITA JAYASWAL
Description:
HI,
I AM AMITA. I AM USING CALLABLE STATEMENT THROUGH STORED PROCEDURE. BUT I CANT SUCCESS.  

How to repeat:
3 TO 4 TIMES I HAVE TRIED.

Suggested fix:
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%
			try
			{
					Connection con=null;
					Class.forName("com.mysql.jdbc.Driver");
					con=DriverManager.getConnection("jdbc:mysql://localhost/soft?user=root&password=");		
					CallableStatement cstmt = con.prepareCall(
                          "{call cl_stock1(?, ?)}");
    cstmt.registerOutParameter(1, java.sql.Types.DECIMAL, 8,3);
    cstmt.registerOutParameter(2, java.sql.Types.DECIMAL, 8,3);
    cstmt.executeQuery();
	out.println("Purchase"+cstmt.getString(1));
	out.println("sales"+cstmt.getString(2));
			

						}
						catch(Exception e)
						{
							out.println(e);
						}
%>
[20 Jun 2007 5:13] Valeriy Kravchuk
Thank you for a problem report. What exact versions of Connector/J and MySQL server do you use?
[20 Jul 2007 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".
[31 Mar 2014 14:41] Alexander Soklakov
I close this report as "Can't repeat" because there is no feedback for a long time and codebase is too old. Please, feel free to reopen it if the problem still exists in current driver.