DDC-962: Using createNativeQuery with DELETE FROM throws an exception

[doctrinebot]

Jira issue originally created by user ccapndave:

When creating a NativeQuery through the EntityManager, and running SQL that returns no result (i.e. DELETE FROM) Doctrine still attempts to hydrate an entity which throws a HY000 General Exception.

An easy workaround is to use DBAL directly to execute the query.

  $sql = 'DELETE FROM media';
  $rsm = new \Doctrine\ORM\Query\ResultSetMapping();
  $query = $this->getEntityManager()->createNativeQuery($sql, $rsm);

  $query->execute();

  /*
  THIS GIVES:

  #0 D:\Projects\BizBap\svn\Server\lib\Doctrine\DBAL\Statement.php(189): PDOStatement->fetch(2)
  #1 D:\Projects\BizBap\svn\Server\lib\Doctrine\ORM\Internal\Hydration\ObjectHydrator.php(126): Doctrine\DBAL\Statement->fetch(2)
  #2 D:\Projects\BizBap\svn\Server\lib\Doctrine\ORM\Internal\Hydration\AbstractHydrator.php(99): Doctrine\ORM\Internal\Hydration\ObjectHydrator->_hydrateAll()
  #3 D:\Projects\BizBap\svn\Server\lib\Doctrine\ORM\AbstractQuery.php(527): Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll(Object(Doctrine\DBAL\Statement), Object(Doctrine\ORM\Query\ResultSetMapping), Array)
  #4 D:\Projects\MyProject\Media.php(210): Doctrine\ORM\AbstractQuery->execute()
  */

[doctrinebot]

Comment created by @beberlei:

createNativeQuery() is only for SELECT statements.

Use $em->getConnection()->executeUpdate() for UPDATE, DELETE or INSERT statements.

This is a documentation issue.

[doctrinebot]

Issue was closed with resolution "Invalid"