JEDNOSTKA

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

/**
 * @ORM\Table(name="_apiKey")
 * @ORM\Entity(repositoryClass="Eve\ProfileBundle\Entity\Repository\apiKeyRepository")
 * @UniqueEntity(fields={"keyID", "vCode", "accountID"}, 
 * message="you already own this api")
 */
class apiKey
{

public function __construct()
{
    // empty
}

// relations start
// relations end

/**
 * @ORM\Column(name="entryID", type="integer")
 * @ORM\Id
 * @ORM\GeneratedValue(strategy="AUTO")
 */
private $entryID;

/**
 * @ORM\Column(name="accountID", type="integer", nullable=false, unique=true)
 */
private $accountID;

/**
 * @ORM\Column(name="keyID", type="integer", nullable=false, unique=true)
 * @Assert\NotBlank(message="keyID cannot be blank")
 */
private $keyID;

/**
 * @ORM\Column(name="vCode", type="string", nullable=false, unique=true)
 * @Assert\NotBlank(message="vCode cannot be blank")
 */
private $vCode;

w db

CREATE TABLE IF NOT EXISTS `_apiKey` (
  `entryID` int(11) NOT NULL AUTO_INCREMENT,
  `accountID` int(11) NOT NULL,
  `keyID` int(11) NOT NULL,
  `vCode` varchar(255) NOT NULL,
  PRIMARY KEY (`entryID`),
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

Kiedy próbuję dodać dublicate, mam błąd

An exception occurred while executing 'INSERT INTO _apiKey (accountID, keyID, vCode) VALUES (?, ?, ?)' with params {"1":38,"2":"1233","3":"123"}:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '38-1233-123' for key 'accountID' 

i jest w porządku, ale jak sobie z tym poradzić? „opcja wiadomości” nie działa@UniqueEntity () jak mogę pokazać ten błąd w błędach formularza (bez wyjątku)

czego chcę (prosty przykład db bez entryID)

123 123 123 - add
123 123 1234 - add
123 125 123 - add
123 123 1234 - form-error on inserting
123 123 123 - form-error on inserting
234 123 123 - add
234 123 123 - form-error on inserting