Hi,

No the query itself. But the usage of the connection components.
I don't have knowledge about java. I think the problem source is a
dynamically created but not closed connection. In example: query
component freed but connection not closed and the query result sit on
the server. Next time a new query component created... etc.

Gabor

Olaf Kluge írta:

> Hello,
>
> is perhaps this query the problem?
>
> SELECT AUFTRAGSNR, COUNT(PID) AS AnzahlPaletten,
> COUNT(DISTINCT(AUFTRAG_POS)) AS AnzahlAuftrPos FROM AA_AUFTRAG_2 AA2 WHERE
> STATUS = 'RQ' AND AA2.AUFTRAGSNR = (SELECT FIRST 1 AUFTRAGSNR FROM
> AA_AUFTRAG_2 WHERE STATUS = 'RQ' ORDER BY AUSL_ORT) GROUP BY AUFTRAGSNR
>
> Every 10 seconds the java applications runs it to show for new orders.
>
> Thank you.