Problems in configValidate when have multiple EM's about stofdoctrineextensionsbundle

[Koc]

Also names of connections may be not equal to names of entity managers

[stof]

Doctrine event managers are attached to the DBAL connections, not to the entity manager. So the name in the bundle config for the ORM is the name of the DBAL connection as stated in the doc.

And btw, your ORM config is bad. You should not register the same bundles for both entity managers as an entity cannot be managed by several entity managers (they would not share the changes done on the entities as they use separate UnitOfWork and so retrieving the same entity from both entity managers would give you different objects, which each one their changes and then a broken state when flushing.

[Koc]

Ok, I've understood my problem.

You should not register the same bundles for both entity managers

Whan you can advice for me? FooTerritorialBundle should have access to both connections.

[stof]

You need to separate the entities managed by both entity managers to different namespaces (as Doctrine registers the mapping by a folder). If you really need to put them in the same bundle, you will need to use different folders and register the mapping explicitly instead of relying on the auto-detection

[stof]

ah, and btw, you don't have 2 connections but 2 entity managers sharing the same DBAL connections (and so the same database). I don't really see the use case for such setup as this could be achieved using a single entity manager for the whole database, and it would probably be more efficient and easier to use.

[Koc]

you don't have 2 connections but 2 entity managers sharing the same DBAL connections

This is for dev env only. In production there are 2 different DBAL connections.

[Koc]

I've created two entity managers for replication: one connection for writing and some connection for writing. In dev env. only one connection shared between this two entity managers.

Sometimes I'm getting error message "Tree object class: UserArea must have tree metadata at this point" when getting user. When I change entity manager for getting this entity - it works correct.

AbstractArea - closure tree + STI
User has one UserArea
UserArea has one User and one child of AbstractArea.

What you can advice to me?