Re: Problem with jdbc based application

["Luther Ananda Miller" <luther.miller@xxxxxxxxxx>]

Sounds like the statements are not always being closed (even know you said
they are!).
To be 100% sure, make sure you close them in a finally clause:
stmt = connection.xxx();
try {
 ...
} finally {stmt.close(); }

----- Original Message -----
From: shahar mor <shahar_mor@yahoo.com>
To: <JAVA400-L@midrange.com>
Sent: Monday, 6 March 2000 22:21
Subject: Problem with jdbc based application


> Hi all,
>
> We developed client/server application using java on
> the client connecting with the java toolbox jdbc
> driver to data base on the as400.
>
> It work fine using stored procedures when needed and
> prepared statements for the sql request.
>
> BUT, sometimes upon heavy use of the system the
> QZDASOINIT joblog contains some 2000 odp in option 14,
> The joblog tells me that odp's are not deleted in
> order to "reuse" it later and in the end, on rare
> occasions i get 'reached maximum number of
> statements'.
>
> We are quite sure that statements are being closed by
> the application however, we cant get rid of this
> situation.
>
> Any suggestions/comments are most welcomed.
>
> TIA
>
> Shahar
>
> =====
> Shahar mor
> consultant
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to JAVA400-L@midrange.com.
> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: joe@zappie.net
> +---

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---