How to create 2 connections (mysql and postgresql) with Doctrine2 in Symfony2

Question

I'm new to Symfony2. And my question quite simple. I would use 2 connections to DB at different host and driver in one bundle.

Could you help me with this?

Herzult · Accepted Answer · 2011-12-09 08:42:03Z

8

You can do something like:

doctrine:
    dbal:
        default_connection: alpha
        connections:
            alpha:
                driver:     pdo_mysql
                host:       localhost
                dbname:     alpha
                user:       root
                charset:    UTF8
            beta:
                driver:     pdo_pgsql
                host:       localhost
                dbname:     beta
                user:       root
                charset:    UTF8
    orm:
        auto_generate_proxy_classes: %kernel.debug%
        entity_managers:
            alpha:
                connection: alpha
            beta:
                connection: beta

You see, we declare two connections in the dbal section and two entity managers in the orm one.

After that, you can use both:

$emAlpha = $this->getDoctrine()->getEntityManager('alpha');
$emBeta  = $this->getDoctrine()->getEntityManager('beta');

As the alpha one was defined as the default one, you can access it without specifying its name:

$emAlpha = $this->getDoctrine()->getEntityManager();

answered Dec 9, 2011 at 8:42

Herzult

3,41925 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Neka Over a year ago

Thanks! But if i will use some database only in read mode, setter methods in entity classes are necessary to use?

Neka Over a year ago

Need I to specify field types in entity classes for existing database (which in read only mode)?

Herzult Over a year ago

Yes because Doctrine need this informations to correctly hydrate your entities...

Collectives™ on Stack Overflow

How to create 2 connections (mysql and postgresql) with Doctrine2 in Symfony2

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related