> 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.

How does the Java code look like?

Do you close your (prepared) statement and result set object in a try
... finally block properly?



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/