How to create a Second database connection with Symfony2?

Question

I'm trying to connect a second database to my project in Symfony2. First, I added into parameters.yml some parameters to create the connection.

Then, I edited my config.yml, and now looks like:

doctrine:
    dbal:
        default_connection:   default
        connections:
            default:
                driver:   pdo_mysql
                host:     "%database_host%"
                port:     "%database_port%"
                dbname:   "%database_name%"
                user:     "%database_user%"
                password: "%database_password%"
                charset:  UTF8
            circutor3:
                driver:   pdo_sqlsrv
                host:     "%database_host_circutor3%"
                port:     "%database_port_circutor%"
                dbname:   "%database_name_circutor%"
                user:     "%database_user_circutor3%"
                password: "%database_password_circutor3%"
                charset:  UTF8
orm:
        auto_generate_proxy_classes: "%kernel.debug%"
        naming_strategy: doctrine.orm.naming_strategy.underscore
        auto_mapping: true

Finally, I tried to get connected, using the following code in my controller:

$em = $this->getDoctrine()->getManager('circutor3');

And, the error returned by Symfony2:

Doctrine ORM Manager named "circutor3" does not exist.

The circutor3 makes connection to a database, external to my system, so I don't need to create entities or objects. I only need to execute some SELECT to get information and store it using an array.

Is creating a typical mysqli connection the best way to solve my problem? I don't know how to solve this with Symfony. Thank you in advance.

Matteo · Accepted Answer · 2016-07-05 16:27:57Z

4

you could access to the database connection in the controller as follow:

    $connection = $this->getDoctrine()->getConnection('circutor3');

then use the connection as:

$stmt = $connection->prepare($sql);
$stmt->execute();
return $stmt->fetchAll();

Some help here and here

Hope this help

answered Jul 5, 2016 at 16:27

Matteo

39.8k11 gold badges110 silver badges129 bronze badges

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

Comments

Alsatian · Accepted Answer · 2016-07-05 16:06:04Z

2

According to Symfony documentation (http://symfony.com/doc/current/cookbook/doctrine/multiple_entity_managers.html), you only defined a connection, not an entity manager :

You have to create an entity_manager for each connection.

orm:
    default_entity_manager: default
    entity_managers:
        default:
            ...
        circutor3:
            connection: circutor3
            mappings:
                AppBundle: ~

answered Jul 5, 2016 at 16:06

Alsatian

3,1554 gold badges27 silver badges42 bronze badges

1 Comment

Isaac Bosca Over a year ago

Thank you for your answer, but I only need to execute some queries, so I only need to create the connection, not an entuty manager. I appreciate your reply anyway :)

Collectives™ on Stack Overflow

How to create a Second database connection with Symfony2?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related