public boolean has(int itemId) throws SQLException {
            final Queue<CompoundItemRequest> itemsToCheck = new LinkedList<>();
            itemsToCheck.add(new CompoundItemRequest(itemId, 1));

            Connection conn = DriverManager.getConnection(url, properties);
            PreparedStatement insufficientDetails = conn.prepareStatement(
                    "select 1 from product join tool "
                    + " on product.type_tool = 0 and product.code_tool = tool.id "
                    + " where product.code = ? and product.type_tool = 0 and product.size_tool * ? > tool.size");
            PreparedStatement compoundDetails = conn.prepareStatement(
                    "select code_tool, size_tool from product "
                    + " where code = ? and type_tool = 1");
   
                compoundDetails.setInt(1, itemId);  
                try (ResultSet rs = compoundDetails.executeQuery()) {
                        while (rs.next())
                            itemsToCheck.add(new CompoundItemRequest(rs.getInt("code_tool"), rs.getInt("size_tool") * 1));
                  }
                while(!itemsToCheck.isEmpty()){
                    final CompoundItemRequest item = itemsToCheck.remove();

                    insufficientDetails.setInt(1, item.itemId);
                    insufficientDetails.setInt(2, item.numberOfItems);
                    try (ResultSet rs = insufficientDetails.executeQuery()) {
                        if (rs.next())return false;
                        
                    }
                }     
                
            
            return true;
        }

BEGIN
  DROP TEMPORARY TABLE IF EXISTS `temp`;
  DECLARE code INT;
  DECLARE type_tool INT;
  DECLARE code_tool INT;
  DECLARE size_tool INT;
  DECLARE v_r INT;
               CREATE TEMPORARY TABLE `temp` (
            		`id` int(11) NOT NULL AUTO_INCREMENT,
  			`code` int(11) NOT NULL,
  			`type_tool` tinyint(1) NOT NULL,
  			`code_tool` int(11) NOT NULL,
  			`size_tool` int(11) NOT NULL);

  DECLARE done INT DEFAULT FALSE;

  DECLARE csr CURSOR FOR 
   Select `code`,`type_tool`,`code_tool`,`size_tool` FROM  `product`;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

  OPEN csr;
  read_loop: LOOP
    FETCH NEXT FROM csr INTO code,type_tool,code_tool,size_tool;
    IF done THEN
      LEAVE read_loop;
    END IF;
    INSERT INTO `temp` (id,code,type_tool,code_tool,size_tool) VALUE (0,code,type_tool,code_tool,size_tool);
  END LOOP;

  CLOSE csr;

  RETURN v_r;
END

create procedure Proc3
BEGIN
  create temporary table if not exists temp_table (id int, val int, notes varchar(100));
END

SQL-запрос:

CREATE PROCEDURE Proc3 BEGIN CREATE TEMPORARY TABLE IF NOT EXISTS temp_table(
id int,
val int,
notes varchar( 100 )
);

Ответ MySQL: Документация
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEGIN
  create temporary table if not exists temp_table (id int, val int, notes' at line 2 

create procedure Proc3
BEGIN
  create temporary table if not exists temp_table (id int, val int, notes varchar(100));
END

delimiter //
create procedure Proc32
BEGIN
  create temporary table if not exists temp_table (id int, val int, notes varchar(100));
END
delimiter;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEGIN create temporary table if not exists temp_table (id int, val int, notes' at line 2