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: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.