• Subject: Problem with jdbc based application
  • From: shahar mor <shahar_mor@xxxxxxxxx>
  • Date: Mon, 6 Mar 2000 13:21:46 -0800 (PST)

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.