Persisting Entity with OneToOne relation #7142

New Issue

Open

opened 2026-01-22 15:45:30 +01:00 by admin · 1 comment

admin commented 2026-01-22 15:45:30 +01:00

Owner

Copy Link

Originally created by @jakublabno on GitHub (Apr 28, 2023).

Bug Report

Q	A
BC Break	no
Version	2.14.3

Summary

Invalid parameters binding while persisting new entity with OneToOneRelation

Current behavior

I have two entities: Invoice and InvoiceNumeration

<?php

declare(strict_types=1);

namespace Payments\Invoicing\Domain;

use Core\Database\DateTimeTrait;
use Doctrine\ORM\Mapping as ORM;
use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\HasLifecycleCallbacks;
use Doctrine\ORM\Mapping\Id;
use JMS\Serializer\Annotation as Serializer;
use OpenApi\Attributes as OA;
use Payments\Domain\PaymentId;

#[OA\Schema]
#[Entity]
#[ORM\Table(name: 'invoices')]
#[HasLifecycleCallbacks]
class Invoice
{
    use DateTimeTrait;

    #[Id]
    #[ORM\Column(type: 'InvoiceIdType')]
    #[Serializer\Exclude]
    private InvoiceId $id;

    #[ORM\Column(name: 'payment_id', type: 'PaymentIdDoctrineType')]
    #[Serializer\Exclude]
    private PaymentId $paymentId;

    #[OA\Property]
    #[ORM\Column(name: 'type')]
    private string $invoiceType;

    #[OA\Property]
    #[ORM\Embedded]
    #[Serializer\Exclude]
    private InvoiceDetails $invoiceDetails;

    #[OA\Property]
    #[ORM\Column]
    private ?string $file = null;

    #[ORM\OneToOne(targetEntity: InvoiceNumeration::class, cascade: ['DETACH'], fetch: 'EAGER')]
    #[ORM\JoinColumn(name: 'id', referencedColumnName: 'invoice_id', nullable: true)]
    private InvoiceNumeration $numeration;

    public function __construct(PaymentId $paymentId, InvoiceDetails $invoiceDetails, InvoiceType $invoiceType)
    {
        $this->id = InvoiceId::generate();
        $this->paymentId = $paymentId;
        $this->invoiceDetails = $invoiceDetails;
        $this->invoiceType = $invoiceType->getName();
    }

    public function getId(): InvoiceId
    {
        return $this->id;
    }

    public function setFile(string $file): void
    {
        $this->file = $file;
    }

    public function getDetails(): InvoiceDetails
    {
        return $this->invoiceDetails;
    }

    public function getType(): InvoiceType
    {
        return InvoiceTypeFactory::fromName($this->invoiceType);
    }
}

<?php

declare(strict_types=1);

namespace Payments\Invoicing\Domain;

use Core\Database\DateTimeTrait;
use Doctrine\ORM\Mapping as ORM;
use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\Id;
use JMS\Serializer\Annotation as Serializer;

#[Entity]
#[ORM\Table(name: 'invoice_numeration')]
#[ORM\HasLifecycleCallbacks]
class InvoiceNumeration
{
    use DateTimeTrait;

    #[Id]
    #[ORM\Column(name: 'invoice_id', type: 'InvoiceIdType')]
    #[Serializer\Exclude]
    private InvoiceId $invoiceId;

    #[ORM\Column(length: 4)]
    private int $year;

    #[ORM\Column(length: 2)]
    private string $month;

    #[ORM\Column]
    private string $type;

    #[ORM\Column(length: 6)]
    private string $number;

    #[Serializer\Accessor(getter: 'getNumber')]
    private string $fullNumber;

    public function __construct(InvoiceId $invoiceId, InvoiceNumber $invoiceNumber, InvoiceType $invoiceType)
    {
        $this->invoiceId = $invoiceId;
        $this->type = $invoiceType->shortName();
        $this->year = $invoiceNumber->getYear();
        $this->month = $invoiceNumber->getMonth();
        $this->number = $invoiceNumber->getOrdinalNumber();
    }

    public function getNumber(): InvoiceNumber
    {
        return new InvoiceNumber("$this->type/$this->year/$this->month/$this->number");
    }
}

While I'm creating Invoice entity, doctrine throws a pdo exception

START TRANSACTION
INSERT INTO invoices (id, payment_id, type, file, date_created, date_updated, invoiceDetails_seller_name, invoiceDetails_seller_country, invoiceDetails_seller_city, invoiceDetails_seller_zipcode, invoiceDetails_description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ROLLBACK
An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'id' cannot be null: #0 /app/vendor/doctrine/dbal/src/Connection.php(1907): Doctrine\\DBAL…

When checking deeper, it seems id is not being passed to PDO, I see null there.

How to reproduce

Here is DDL:

create table invoices
(
    id                            binary(16)               not null
        primary key,
    payment_id                    binary(16)               not null,
    file                          varchar(255)             null,
    date_created                  datetime                 not null,
    date_updated                  datetime                 null,
    invoiceDetails_seller_name    varchar(255)             not null,
    invoiceDetails_seller_country varchar(255)             not null,
    invoiceDetails_seller_city    varchar(255)             not null,
    invoiceDetails_seller_zipcode varchar(255)             not null,
    invoiceDetails_description    varchar(255)             not null,
    type                          enum ('proforma', 'vat') not null
);

create table invoice_numeration
(
    invoice_id   binary(16)              not null
        primary key,
    year         int                     not null,
    month        varchar(2)              not null,
    type         enum ('FV', 'PROFORMA') not null,
    number       int                     not null,
    date_created datetime                not null,
    date_updated datetime                null,
    constraint invoice_numeration_pk
        unique (year, number, month, type)
);

Of course, everything worked before adding OneToOne and JoinColumn definition.
Maybe I'm doing something wrong?

I would not use JoinColumn, because it seems not be necessary, but when I don't it throws another exception

Could not resolve type of column \"id\" of class \"Payments\\Invoicing\\Domain\\InvoiceNumeration\"

However, it's the same type as in Invoice Entity Id

Originally created by @jakublabno on GitHub (Apr 28, 2023). ### Bug Report <!-- Fill in the relevant information below to help triage your issue. --> | Q | A |------------ | ------ | BC Break | no | Version | 2.14.3 #### Summary Invalid parameters binding while persisting new entity with OneToOneRelation #### Current behavior I have two entities: `Invoice` and `InvoiceNumeration` ``` <?php declare(strict_types=1); namespace Payments\Invoicing\Domain; use Core\Database\DateTimeTrait; use Doctrine\ORM\Mapping as ORM; use Doctrine\ORM\Mapping\Entity; use Doctrine\ORM\Mapping\HasLifecycleCallbacks; use Doctrine\ORM\Mapping\Id; use JMS\Serializer\Annotation as Serializer; use OpenApi\Attributes as OA; use Payments\Domain\PaymentId; #[OA\Schema] #[Entity] #[ORM\Table(name: 'invoices')] #[HasLifecycleCallbacks] class Invoice { use DateTimeTrait; #[Id] #[ORM\Column(type: 'InvoiceIdType')] #[Serializer\Exclude] private InvoiceId $id; #[ORM\Column(name: 'payment_id', type: 'PaymentIdDoctrineType')] #[Serializer\Exclude] private PaymentId $paymentId; #[OA\Property] #[ORM\Column(name: 'type')] private string $invoiceType; #[OA\Property] #[ORM\Embedded] #[Serializer\Exclude] private InvoiceDetails $invoiceDetails; #[OA\Property] #[ORM\Column] private ?string $file = null; #[ORM\OneToOne(targetEntity: InvoiceNumeration::class, cascade: ['DETACH'], fetch: 'EAGER')] #[ORM\JoinColumn(name: 'id', referencedColumnName: 'invoice_id', nullable: true)] private InvoiceNumeration $numeration; public function __construct(PaymentId $paymentId, InvoiceDetails $invoiceDetails, InvoiceType $invoiceType) { $this->id = InvoiceId::generate(); $this->paymentId = $paymentId; $this->invoiceDetails = $invoiceDetails; $this->invoiceType = $invoiceType->getName(); } public function getId(): InvoiceId { return $this->id; } public function setFile(string $file): void { $this->file = $file; } public function getDetails(): InvoiceDetails { return $this->invoiceDetails; } public function getType(): InvoiceType { return InvoiceTypeFactory::fromName($this->invoiceType); } } ``` ``` <?php declare(strict_types=1); namespace Payments\Invoicing\Domain; use Core\Database\DateTimeTrait; use Doctrine\ORM\Mapping as ORM; use Doctrine\ORM\Mapping\Entity; use Doctrine\ORM\Mapping\Id; use JMS\Serializer\Annotation as Serializer; #[Entity] #[ORM\Table(name: 'invoice_numeration')] #[ORM\HasLifecycleCallbacks] class InvoiceNumeration { use DateTimeTrait; #[Id] #[ORM\Column(name: 'invoice_id', type: 'InvoiceIdType')] #[Serializer\Exclude] private InvoiceId $invoiceId; #[ORM\Column(length: 4)] private int $year; #[ORM\Column(length: 2)] private string $month; #[ORM\Column] private string $type; #[ORM\Column(length: 6)] private string $number; #[Serializer\Accessor(getter: 'getNumber')] private string $fullNumber; public function __construct(InvoiceId $invoiceId, InvoiceNumber $invoiceNumber, InvoiceType $invoiceType) { $this->invoiceId = $invoiceId; $this->type = $invoiceType->shortName(); $this->year = $invoiceNumber->getYear(); $this->month = $invoiceNumber->getMonth(); $this->number = $invoiceNumber->getOrdinalNumber(); } public function getNumber(): InvoiceNumber { return new InvoiceNumber("$this->type/$this->year/$this->month/$this->number"); } } ``` While I'm creating `Invoice` entity, doctrine throws a pdo exception ``` START TRANSACTION INSERT INTO invoices (id, payment_id, type, file, date_created, date_updated, invoiceDetails_seller_name, invoiceDetails_seller_country, invoiceDetails_seller_city, invoiceDetails_seller_zipcode, invoiceDetails_description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ROLLBACK An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'id' cannot be null: #0 /app/vendor/doctrine/dbal/src/Connection.php(1907): Doctrine\\DBAL… ``` When checking deeper, it seems id is not being passed to PDO, I see null there.  #### How to reproduce Here is DDL: ``` create table invoices ( id binary(16) not null primary key, payment_id binary(16) not null, file varchar(255) null, date_created datetime not null, date_updated datetime null, invoiceDetails_seller_name varchar(255) not null, invoiceDetails_seller_country varchar(255) not null, invoiceDetails_seller_city varchar(255) not null, invoiceDetails_seller_zipcode varchar(255) not null, invoiceDetails_description varchar(255) not null, type enum ('proforma', 'vat') not null ); create table invoice_numeration ( invoice_id binary(16) not null primary key, year int not null, month varchar(2) not null, type enum ('FV', 'PROFORMA') not null, number int not null, date_created datetime not null, date_updated datetime null, constraint invoice_numeration_pk unique (year, number, month, type) ); ``` <!-- What was the expected (correct) behavior? --> Of course, everything worked before adding OneToOne and JoinColumn definition. Maybe I'm doing something wrong? I would not use JoinColumn, because it seems not be necessary, but when I don't it throws another exception ``` Could not resolve type of column \"id\" of class \"Payments\\Invoicing\\Domain\\InvoiceNumeration\" ``` However, it's the same type as in `Invoice` Entity Id

admin commented 2026-01-22 15:45:31 +01:00

Author

Owner

Copy Link

@mpdude commented on GitHub (May 31, 2023):

Thank you for providing a code example! That makes it easier to understand the situation.

As a first step, could you please try to simplify the code a bit more?

• What is DateTimeTrait, and do you need it to show the problem?
• Do you need the OpenAPI stuff, Serializer and/or the lifecycle callbacks to demonstrate the problem?
• Can you remove getters/setters that are not relevant to the problem?
• You're using two (custom?) column types without showing their definition.

@mpdude commented on GitHub (May 31, 2023): Thank you for providing a code example! That makes it easier to understand the situation. As a first step, could you please try to simplify the code a bit more? * What is `DateTimeTrait`, and do you need it to show the problem? * Do you need the OpenAPI stuff, Serializer and/or the lifecycle callbacks to demonstrate the problem? * Can you remove getters/setters that are not relevant to the problem? * You're using two (custom?) column types without showing their definition.

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#7142