Symfony2 Error: Object of class Doctrine\ORM\EntityManager could not be converted to string

Question

I have 2 non related entities: External and Internal. I need to union select all results from entities. I am using ResultSetMapping and Native SQL to do this:

 $em = $this->getDoctrine()
        ->getManager()->getConnection();
 $rsm = new \Doctrine\ORM\Query\ResultSetMapping();
    $rsm->addEntityResult('ExternalBundle:External', 'e');
    $rsm->addFieldResult('e', 'id', 'id');
    $rsm->addFieldResult('e', 'status', 'status');
    $rsm->addFieldResult('e', 'name', 'name');
    $rsm->addEntityResult('InternalBundle:Internal', 'i');
    $rsm->addFieldResult('i', 'id', 'id');
    $rsm->addFieldResult('i', 'status', 'status');
    $rsm->addFieldResult('i', 'name', 'name');
    $sql = "SELECT e.*
FROM external_print e
UNION
SELECT i.*
FROM internal_print i";
    $objects = $this->$em->createNativeQuery($sql, $rsm)->getResult();

I keep getting this error: Catchable Fatal Error: Object of class Doctrine\ORM\EntityManager could not be converted to string.

What needs to be fixed?

Try this : $em = $this->container->get('doctrine')->getManager(); — Reformat Code, Oct 13 '15 at 11:31

score 1 · Accepted Answer · answered Oct 13 '15 at 13:24

1

You have a code error instead of

$objects = $this->$em->createNativeQuery($sql, $rsm)->getResult();

use just

$objects = $em->createNativeQuery($sql, $rsm)->getResult();

answered Oct 13 '15 at 13:24

Alexandru Olaru

6,842
6
27
53

Symfony2 Error: Object of class Doctrine\ORM\EntityManager could not be converted to string

1 Answers1

Linked