Hello Marco Pivetta,
when running SQL through the method $this->getSQL the query builder and
excutar in SQLDeveloper tool Oracle, consultation and returned with the
expected records.
I identified another scenario and thus can return the records, but does not
make logical sense. When used setMaxResults the query object.
The doctrine enters the oracle rownum operator in the query.
Follows the example of how I used setMaxResults.
$queryBuilder = $this->getEntityManager()->createQueryBuilder();
$strCampos = 'COUNT(' . $this->getAlias() . '.idArquivo)
qtRegistros, Transacao.coTipoSituacaoTransacao coTipoSituacaoTransacao';
$strDqlQtPagamento = $queryBuilder->select($strCampos)
->from($this->getEntityName(), $this->getAlias())
->innerJoin(
'Participante\Entity\ArquivoDetalhe',
'ArquivoDetalhe',
'with',
'ArquivoGruDetalhe.idArquivo = ' . $this->getAlias() .
'.idArquivo'
)
->innerJoin(
'Participante\Entity\Transacao',
'Transacao',
'with',
'Transacao.idArquivoGruDetalhe =
ArquivoGruDetalhe.idArquivoGruDetalhe'
)
->where($this->getAlias() . '.idArquivo = :intCoArquivo')
->setParameter('intCoArquivo', $intCoArquivo)
->groupBy('Transacao.coTipoSituacaoTransacao')
->setMaxResults(4)
->getQuery();
Thank you.
Em quinta-feira, 11 de junho de 2015 07:38:50 UTC-3, Marco Pivetta escreveu:
>
> Seems like your DB is simply not responding inside your specified time
> limits.
>
> Try generating the SQL for that query and running it by hand ;-)
>
> Marco Pivetta
>
> http://twitter.com/Ocramius
>
> http://ocramius.github.com/
>
> On 11 June 2015 at 00:18, Ualison Aguiar <[email protected]
> <javascript:>> wrote:
>
>> Hello everyone good night,
>> I have a following problem when using createQueryBuilder in Oracle
>> Database 11g.
>> Follows the assembly of the query:
>> $queryBuilder = $this->getEntityManager()->createQueryBuilder();
>> $strCampos = 'COUNT(' . $this->getAlias() . '.idArquivo)
>> qtRegistros, Transacao.coTipoSituacaoTransacao coTipoSituacaoTransacao';
>> $strDqlQtPagamento = $queryBuilder->select($strCampos)
>> ->from($this->getEntityName(), $this->getAlias())
>> ->innerJoin(
>> 'Participante\Entity\ArquivoDetalhe',
>> 'ArquivoDetalhe',
>> 'with',
>> 'ArquivoGruDetalhe.idArquivo = ' . $this->getAlias() .
>> '.idArquivo'
>> )
>> ->innerJoin(
>> 'Participante\Entity\Transacao',
>> 'Transacao',
>> 'with',
>> 'Transacao.idArquivoGruDetalhe =
>> ArquivoGruDetalhe.idArquivoGruDetalhe'
>> )
>> ->where($this->getAlias() . '.idArquivo = ' . $intCoArquivo)
>> ->groupBy('Transacao.coTipoSituacaoTransacao')
>> ->getQuery();
>> Entity in the transaction table have 88,450 records in the information
>> environment and the system does not return runtime execution occurring
>> overflow.
>> I identified that the call of the execute method of the class
>> doctrine/dbal/lib/Doctrine/DBAL/Connection.php line: 824 of the
>> executeQuery method and responsible for the delay.
>> When I run the same code in the development environment where you have no
>> more than 100 record does not present the scenario occurred in another
>> environment.
>> Could anyone help me identify the reason.
>> I performed some scenario, when do not use the bind on condition right
>> past the value, problem does not happen in the information environment.
>> Follow the composer data regarding the doctrine:
>>
>> "doctrine / annotations", "> = 1.0"
>> "doctrine / doctrine-orm-module": "dev-master"
>> thank you
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "doctrine-user" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> Visit this group at http://groups.google.com/group/doctrine-user.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
