How to manage Doctrine queries with multiple db schemas

Question

I have an entity A with a relation ManyToOne with B but A and B doesn't belong to the same DB schema. Entity 'A' belongs to MyBundle bundle, and entity 'B' belongs to MyOtherBundle bundle. The official documentation explain how to work with different connections : multiple schemas = multiple entity manager. But in my case I would like to join both entities. By doing : ``` $this->objEm->getRepository('MyBundle:MyEntity')->find($id); ``` or ``` $this->objEm->getRepository('MyBundle:MyEntity')->getMyResult($id); ``` I only call one of my repository, and I guess he's not able to get the other because in my config.yml I can chose only one connection. ``` doctrine: dbal: connections: connection1: driver: "%database_driver%" host: "%database_host%" port: "%database_port%" dbname: "%database_name%" user: "%database_schema1_user%" password: "%database_schema1_password%" service: "%database_service%" charset: "Windows-1252" connection2: driver: "%database_driver%" host: "%database_host%" port:…

Accepted Answer

Problem solved ! It had absolutely nothing to do with databases schema nor annotations.

In entity A, one of my personnal setter was forcing type in parameter :

```
public function setB(B $objB) { //... }
```

... and I forgot to use B's FQCN ! That's why it was using A's one.

Next time I won't declare FQCN in the annotation to oblige me to use it at the beginning of my class ! :)

How to manage Doctrine queries with multiple db schemas

Solution

Problem