DatagridBundle entity not in default entity_manager

Hello,
I’m using two orm connection, the default one and another one called pim.

From a controller, the following code works fine :

$produits = $this->getDoctrine()->getRepository('CLPimBundle:Produit', 'pim')->findAll();

1	$produits = $this->getDoctrine()->getRepository('CLPimBundle:Produit', 'pim')->findAll();

But in the datagrid.yml, I got the following error :

Unknown Entity namespace alias 'CLPimBundle'

1	Unknown Entity namespace alias 'CLPimBundle'

with the following configuration :

datagrid: cl-pim-produit-datagrid: source: type: orm query: select: - p.id - p.created from: - { table: CLPimBundle:Produit, alias: p } columns: created: label: "date de création"

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

datagrid:           cl-pim-produit-datagrid:         source:             type: orm             query:                   select:                     - p.id                     - p.created                 from:                     - { table: CLPimBundle:Produit, alias:  p }         columns:             created:                 label: "date de création"

Is there a way to specify the entity_manager name in datagrid.yml ?
Thank you.

Topic

[Yevhen ShyshkinParticipant]

Hello, scivray.

Yes, this is an issue, we’ll need to fix it.

As a temporary solution you can create your own datasource similar to default one, inject there custom entity manager and use your new datasource.

[scivrayParticipant]

Hello,
Ok, thank you.

[Tamas.PalecianParticipant]

Hello,
Could you please tell me how you done a different database connection?
I mean how I would use 2 databases in the same orocrm application

I tried to use the:
http://symfony.com/doc/current/cookbook/doctrine/multiple_entity_managers.html
And I got some errors with the namespaces.

Thank you,
Tamas

[scivrayParticipant]

Hi,
In config.yml, I got the following in order to use the default connection and my custom pim connection:

doctrine:
dbal:
default_connection: default
connections:
default:
driver: “%database_driver%”
host: “%database_host%”
port: “%database_port%”
dbname: “%database_name%”
user: “%database_user%”
password: “%database_password%”
charset: UTF8
pim:
driver: “%database_driver_pim%”
host: “%database_host_pim%”
port: “%database_port_pim%”
dbname: “%database_name_pim%”
user: “%database_user_pim%”
password: “%database_password_pim%”
charset: UTF8

orm:
default_entity_manager: default
entity_managers:
default:
connection: default
class_metadata_factory_name: Oro\Bundle\EntityExtendBundle\Mapping\ExtendClassMetadataFactory

mappings:
OroActivityBundle: ~
OroActivityListBundle: ~
OroAddressBundle: ~
OroAsseticBundle: ~
OroAttachmentBundle: ~
OroBatchBundle: ~
OroBusinessEntitiesBundle: ~
OroCacheBundle: ~
OroCalendarBundle: ~
OroChartBundle: ~
OroCommentBundle: ~
OroConfigBundle: ~
OroCronBundle: ~
OroDashboardBundle: ~
OroDataAuditBundle: ~
OroDataGridBundle: ~
OroDistributionBundle:
mapping: false
is_bundle: true
OroEmailBundle: ~
OroEmbeddedFormBundle: ~
OroEntityBundle: ~
OroEntityConfigBundle: ~
OroEntityExtendBundle: ~
OroEntityMergeBundle: ~
OroEntityPaginationBundle: ~
OroFilterBundle: ~
OroFormBundle: ~
OroHelpBundle: ~
OroImapBundle: ~
OroImportExportBundle: ~
OroInstallerBundle: ~
OroIntegrationBundle: ~
OroLocaleBundle: ~
OroMigrationBundle: ~
OroNavigationBundle: ~
OroNoteBundle: ~
OroNotificationBundle: ~
OroOrganizationBundle: ~
OroPlatformBundle: ~
OroQueryDesignerBundle: ~
OroReminderBundle: ~
OroReportBundle: ~
OroRequireJSBundle: ~
OroSearchBundle: ~
OroSecurityBundle: ~
OroSegmentBundle: ~
OroSidebarBundle: ~
OroSoapBundle: ~
OroSyncBundle: ~
OroTagBundle: ~

OroThemeBundle: ~
OroTrackingBundle: ~
OroTranslationBundle: ~
OroUIBundle: ~
OroUserBundle: ~
OroWindowsBundle: ~
OroWorkflowBundle: ~
JMSJobQueueBundle: ~
CLPocBundle: ~
CLUIBundle: ~

metadata_cache_driver:
type: service
id: doctrine.metadata.cache
pim:
connection: pim
mappings:
CLPimBundle: ~

resolve_target_entities:
Symfony\Component\Security\Core\User\UserInterface: Oro\Bundle\UserBundle\Entity\User

For argument in service, you have to prefixe entity_manager with the connection name like this :

cl_pim.datasource.variant:
class: %cl_pim.datasource.variant.class%
arguments:
– @doctrine.orm.pim_entity_manager
– @oro_datagrid.event.dispatcher
– @oro_datagrid.datasource.orm.parameter_binder
tags:
– {name: oro_datagrid.datasource, type: cl.datasource.variant}

HTH

[Tamas.PalecianParticipant]

Great, thank you for support,

Best regards,
Tamas

[scivrayParticipant]

Hi,
Is this issue fixed now ?

Regards.

[Dima SorokaKeymaster]

It is not fixed yet, feel free to submit contribution to https://github.com/orocrm/platform

[Author]

Replies