Doctrine 2 Composite Primary Keys as Foreign Key

Question

I have ClassA mapped to the entity ClassB with ManyToOne relation (simple so far).

class ClassA{ /** * @var string * @ORM\Id * @ORM\Column(name="keyA", type="string", length=255) */ private $keyA; /** * @var ClassB $classB * @ORM\ManyToOne(targetEntity="ClassB", inversedBy="classAs") * @ORM\JoinColumns({ * @ORM\JoinColumn(name="ClassB_keyB", referencedColumnName="keyB") * }) */ private $classB; }

And this is the ClassB:

class ClassB{ /** * @var string * @ORM\Id * @ORM\Column(name="keyB", type="string", length=255) */ private $keyB; /** * * @var ClassC $classC * @ORM\Id * @ORM\ManyToOne(targetEntity="ClassC", inversedBy="classBs") * @ORM\JoinColumns({ * @ORM\JoinColumn(name="ClassC_keyC", referencedColumnName="keyC") * }) */ private $classC; /** * @var ArrayCollection $classAs * @ORM\OneToMany(targetEntity="ClassA", mappedBy="classB") */ private $classAs; }

As you can notice the ClassB contains a composite primary key (2 entities and on column).
And this is the ClassC:

class ClassC{ /** * @var string * @ORM\Id * @ORM\Column(name="keyC", type="string", length=255) */ private $keyC; /** * @var ArrayCollection $classBs * @ORM\OneToMany(targetEntity="ClassB", mappedBy="classC") */ private $classBs; }

Whene i try to display all entities of ClassA (using findAll()) I get this exception Missing value for primary key classC on ERP\................\ClassB

What am I missing here ?!

walidtlili · Accepted Answer · 2017-01-12 11:33:18Z

1

you have to create your own method at ClassARepository and add your join columns

answered Jan 12, 2017 at 11:33

walidtlili

1,2542 gold badges19 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

isom Over a year ago

public function getClassA(){ return $this->createQueryBuilder('di') ->leftJoin('di.classB','ec') ->addSelect('ec') ->getQuery()->getResult(); }

Collectives™ on Stack Overflow

Doctrine 2 Composite Primary Keys as Foreign Key

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related