Doctrine multiple databases mapping not working

Here is my config :

doctrine:
    dbal:
        default_connection: default
        connections:
            default:
                url: '%env(resolve:DATABASE_URL)%'
            sqlite:
                driver: 'pdo_sqlite'
                path: '%kernel.project_dir%/src/data.db'

    orm:
        auto_generate_proxy_classes: true
        enable_lazy_ghost_objects: true
        default_entity_manager: default
        entity_managers:
            default:
                connection: default
                naming_strategy: doctrine.orm.naming_strategy.underscore_number_aware
                auto_mapping: true
                mappings:
                    App:
                        is_bundle: false
                        type: annotation
                        dir: '%kernel.project_dir%/src/Entity'
                        prefix: 'App\Entity'
                        alias: App
            sqlite:
                connection: sqlite
                mappings:
                    SQLite:
                        is_bundle: false
                        type: annotation
                        dir: /application/src/EntitySqlLite
                        prefix: App\Entity\EntitySqlLite
                        mapping: true


when@test:
    doctrine:
        dbal:
            # "TEST_TOKEN" is typically set by ParaTest
            dbname_suffix: '_test%env(default::TEST_TOKEN)%'

when@prod:
    doctrine:
        orm:
            auto_generate_proxy_classes: false
            proxy_dir: '%kernel.build_dir%/doctrine/orm/Proxies'
            query_cache_driver:
                type: pool
                pool: doctrine.system_cache_pool
            result_cache_driver:
                type: pool
                pool: doctrine.result_cache_pool

    framework:
        cache:
            pools:
                doctrine.result_cache_pool:
                    adapter: cache.app
                doctrine.system_cache_pool:
                    adapter: cache.system

I have entites :

itbcode@2dc31f2b7529:/application$ php bin/console doctrine:schema:update --dump-sql --em=sqlite

                                                                                                                        
 [OK] No Metadata Classes to process.                                                                                   
                                                                                                                        

itbcode@2dc31f2b7529:/application$ ls -la src/EntitySqlLite/
total 16
drwxrwxr-x  2 itbcode itbcode 4096 Oct  6 10:54 .
drwxrwxr-x 16 itbcode itbcode 4096 Oct  6 11:00 ..
-rw-rw-r--  1 itbcode itbcode  739 Oct  6 10:47 ItbHelp.php
-rw-rw-r--  1 itbcode itbcode  254 Oct  6 10:54 Test.php

ItbHelp :

<?php

namespace App\EntitySqlLite;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity()
 */
class ItbHelp
{

    /**
     * @ORM\Id()
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected ?int $id = null;

Leave a Comment