Symfony2 UniqueConstraint and UniqueEntity (Integrity Violation)

Question

I've got a little problem with a Doctrine entity for a few days now. I've defined it with a UniqueConstraint on two fields with a UniqueEntity Validation on these two fields after that. But after validating of my form with a adding of an entity already in base, no way to obtain my error message in my form. Just an error message from Symfony : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '339057986-00012' for key 'SIRET' Here is my entity declaration, all seems fine to me but maybe have I forgotten or misunderstood something? ``` <?php namespace Proetco\FrontBundle\Entity; use Doctrine\ORM\Mapping as ORM; use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity; use Symfony\Component\Validator\Constraints as Assert; /** * Proetco\FrontBundle\Entity\Entreprise * * @ORM\Table(name="entreprise", uniqueConstraints={@ORM\UniqueConstraint(name="SIRET", columns={"SIREN", "NIC"})}) * @ORM\Entity(repositoryClass="Proetco\FrontBundle\Entity\EntrepriseRepository") *…

Accepted Answer

It's too late to reply here, but still replying so that it can help others who are stuck with the same problem.

Two things

- UniqueConstraint is not needed unless you want to generate schema change queries from your entity.

- UniqueEntity is what you need.

Short Answer

The entity definition in the question looks fine, I think there can be either of the below two issues.

- You have added `fields={"SIREN","NIC"}` which means that they will together unique, but you might be wanting them to be unique individually

- Or you might not be validating the entity, which I think is highly unlikely but I still wanted to be checked `https://symfony.com/doc/current/validation.html#using-the-validator-service`

Detailed Explanation below

Notice that I got rid of `, uniqueConstraints={@ORM\UniqueConstraint(name="SIRET", columns={"SIREN", "NIC"})}` from `@ORM/Table` annotation (because UniqueConstraint is not needed unless you want to generate schema definition out of the entity)

```
<?php

namespace Proetco\FrontBundle\Entity;

use Doctrine\ORM\Mapping as ORM;
use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
use Symfony\Component\Validator\Constraints as Assert;

/**
 * Proetco\FrontBundle\Entity\Entreprise
 *
 * @ORM\Table(name="entreprise") 
 * @ORM\Entity(repositoryClass="Proetco\FrontBundle\Entity\EntrepriseRepository")
 * @UniqueEntity(fields={"SIREN","NIC"}, message="Cette entreprise est déjà enregistrée")
 */
class Entreprise {
    /**
     * Body of entity
     */
}
```

Also `fields={"SIREN","NIC"}` this means that you want both these columns together to be unique If you want each one of them to be inidividually unique then you'll need two `UniqueEntity`

Something like below

```
/**
 * @ORM\Table(name="entreprise") 
 * @ORM\Entity(repositoryClass="Proetco\FrontBundle\Entity\EntrepriseRepository")
 * @UniqueEntity(fields={"SIREN"}, message="Cette entreprise est déjà enregistrée")
 * @UniqueEntity(fields={"NIC"}, message="Cette entreprise est déjà enregistrée")
 */
```

After you have the above setup you'll need validate entity and handle errors in your form

Symfony2 UniqueConstraint and UniqueEntity (Integrity Violation)

Solution

Problem