Symfony 6中视图实体无主键的Doctrine错误解决方法

问题核心 #

Doctrine ORM强制要求每个实体必须有主键，哪怕是映射数据库视图（视图本身无主键），你需要手动指定一个或多个在视图中唯一的列作为Doctrine识别的主键。

你的代码问题分析 #

当前代码存在两个关键问题：

• 混合使用了属性注解和DocBlock注解，且属性注解未正确导入ORM命名空间下的类
• $contactId属性类型为string，但对应的setContactId方法参数是int，类型不匹配

修正方案 #

1. 统一使用属性注解（Symfony 6+推荐） #

先确保导入正确的ORM注解类，然后为视图中唯一的列（比如contactId）标记#[ORM\Id]注解，同时配置#[ORM\Column]对应数据库列的信息。

2. 修正类型不匹配 #

保证属性类型与 setter 方法参数类型一致，根据数据库中contactId的实际类型调整（比如是字符串就保持string，是整数就改为int）。

修正后的完整代码 #

<?php

namespace App\Entity;

use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity]
#[ORM\Table(
    name: "contact_vw",
    indexes: [
        new ORM\Index(name: "city", columns: ["city"]),
        new ORM\Index(name: "customer", columns: ["customer"]),
        new ORM\Index(name: "name", columns: ["name"]),
        new ORM\Index(name: "country_sold_to", columns: ["country_sold_to"])
    ]
)]
class ContactVw
{
    #[ORM\Id]
    #[ORM\Column(name: "contact_id", type: "string", length: 255, nullable: false)]
    private string $contactId;

    #[ORM\Column(name: "first", type: "string", length: 255, nullable: true, options: ["default" => "NULL"])]
    private ?string $first = 'NULL';

    #[ORM\Column(name: "middle", type: "string", length: 255, nullable: true, options: ["default" => "NULL"])]
    private ?string $middle = 'NULL';

    #[ORM\Column(name: "last", type: "string", length: 255, nullable: false)]
    private string $last;

    #[ORM\Column(name: "customer", type: "decimal", precision: 38, scale: 0, nullable: false)]
    private string $customer;

    #[ORM\Column(name: "email", type: "string", length: 255, nullable: true, options: ["default" => "NULL"])]
    private ?string $email = 'NULL';

    #[ORM\Column(name: "phone", type: "string", length: 255, nullable: true, options: ["default" => "NULL"])]
    private ?string $phone = 'NULL';

    #[ORM\Column(name: "mobile", type: "string", length: 255, nullable: true, options: ["default" => "NULL"])]
    private ?string $mobile = 'NULL';

    #[ORM\Column(name: "skill_id", type: "boolean", nullable: false)]
    private bool $skillId;

    #[ORM\Column(name: "skill", type: "string", length: 255, nullable: false)]
    private string $skill;

    #[ORM\Column(name: "country", type: "string", length: 2, nullable: false)]
    private string $country;

    #[ORM\Column(name: "country_sold_to", type: "string", length: 41, nullable: true, options: ["default" => "NULL"])]
    private ?string $countrySoldTo = 'NULL';

    #[ORM\Column(name: "name", type: "string", length: 35, nullable: false)]
    private string $name;

    #[ORM\Column(name: "name_2", type: "string", length: 35, nullable: true, options: ["default" => "NULL"])]
    private ?string $name2 = 'NULL';

    #[ORM\Column(name: "postal_code", type: "decimal", precision: 38, scale: 0, nullable: true, options: ["default" => "NULL"])]
    private ?string $postalCode = 'NULL';

    #[ORM\Column(name: "city", type: "string", length: 35, nullable: false)]
    private string $city;

    public function __construct(string $contactId)
    {
        $this->contactId = $contactId;
    }

    public function getContactId(): string
    {
        return $this->contactId;
    }

    public function setContactId(string $contactId): self
    {
        $this->contactId = $contactId;
        return $this;
    }

    // 以下getter/setter保持原有逻辑，无需修改
    public function getFirst(): ?string
    {
        return $this->first;
    }

    public function setFirst(?string $first): self
    {
        $this->first = $first;
        return $this;
    }

    public function getMiddle(): ?string
    {
        return $this->middle;
    }

    public function setMiddle(?string $middle): self
    {
        $this->middle = $middle;
        return $this;
    }

    public function getLast(): ?string
    {
        return $this->last;
    }

    public function setLast(string $last): self
    {
        $this->last = $last;
        return $this;
    }

    public function getCustomer(): ?string
    {
        return $this->customer;
    }

    public function setCustomer(string $customer): self
    {
        $this->customer = $customer;
        return $this;
    }

    public function getEmail(): ?string
    {
        return $this->email;
    }

    public function setEmail(?string $email): self
    {
        $this->email = $email;
        return $this;
    }

    public function getPhone(): ?string
    {
        return $this->phone;
    }

    public function setPhone(?string $phone): self
    {
        $this->phone = $phone;
        return $this;
    }

    public function getMobile(): ?string
    {
        return $this->mobile;
    }

    public function setMobile(?string $mobile): self
    {
        $this->mobile = $mobile;
        return $this;
    }

    public function isSkillId(): ?bool
    {
        return $this->skillId;
    }

    public function setSkillId(bool $skillId): self
    {
        $this->skillId = $skillId;
        return $this;
    }

    public function getSkill(): ?string
    {
        return $this->skill;
    }

    public function setSkill(string $skill): self
    {
        $this->skill = $skill;
        return $this;
    }

    public function getCountry(): ?string
    {
        return $this->country;
    }

    public function setCountry(string $country): self
    {
        $this->country = $country;
        return $this;
    }

    public function getCountrySoldTo(): ?string
    {
        return $this->countrySoldTo;
    }

    public function setCountrySoldTo(?string $countrySoldTo): self
    {
        $this->countrySoldTo = $countrySoldTo;
        return $this;
    }

    public function getName(): ?string
    {
        return $this->name;
    }

    public function setName(string $name): self
    {
        $this->name = $name;
        return $this;
    }

    public function getName2(): ?string
    {
        return $this->name2;
    }

    public function setName2(?string $name2): self
    {
        $this->name2 = $name2;
        return $this;
    }

    public function getPostalCode(): ?string
    {
        return $this->postalCode;
    }

    public function setPostalCode(?string $postalCode): self
    {
        $this->postalCode = $postalCode;
        return $this;
    }

    public function getCity(): ?string
    {
        return $this->city;
    }

    public function setCity(string $city): self
    {
        $this->city = $city;
        return $this;
    }
}

关键说明 #

• 如果视图中没有单一唯一列，可以用复合主键：为多个列添加#[ORM\Id]注解，Doctrine会将这些列的组合视为唯一标识
• 视图是只读的，建议给实体添加#[ORM\ReadOnly]注解，避免Doctrine尝试更新视图数据

内容的提问来源于stack exchange，提问作者Juergen Schulze