import java.sql.SQLException;
import java.sql.Statement;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.DatabaseMetaData;
import java.util.*;
import java.io.*;

public class bug8142 {

    protected static String dbUrl = "jdbc:mysql:///test?";
    protected static Connection conn = null;
    protected static ResultSet rs = null;
    protected static PreparedStatement cstmt = null;

    public static void main(String[] args) throws Exception {

        Class.forName("com.mysql.jdbc.Driver").newInstance();

        conn = DriverManager.getConnection(dbUrl,"root","simsim");
        conn.setAutoCommit(false);

	if (cstmt!=null) cstmt.close(); 
	cstmt = ( CallableStatement )conn.prepareCall("{ call st_proc_name(?, ?, ?, ?) }" );
   
	cstmt.setString( 1, "1");
	cstmt.setString( 2, "24-01-2005");
	cstmt.setString( 3, "300");
	cstmt.setString( 4, "500");

	cstmt.execute();
	conn.commit();

	if (cstmt!=null) cstmt.close(); 
	cstmt = ( CallableStatement )conn.prepareCall("{ call st_proc_name(?, ?, ?, ?) }" );

	cstmt.setString( 1, "1");
	cstmt.setString( 2, "24-01-2005");
	cstmt.setString( 3, "500");
	cstmt.setString( 4, "600");

	cstmt.execute();
	conn.commit();
        /* 
        rs = stmt.executeQuery("SELECT * from bug7768");
        while (rs.next()) {
            String dusseldorf = rs.getString(1);
            out.println(dusseldorf);   

        }
       */
   }
}