Re: Sever pulling a bazillion rows from IBMi via JDBC (I think)
Jim Franz <[email protected]> Tue, 2 Sep 2025 13:35:37 -0400
| Newsgroups | gmane.comp.lang.as400.java |
|---|---|
| Message-ID | <CAEVZ15NEvR91a8JN0PA0tQ4JbAQ61oir4jh_vfR75xkpy2SY1w@mail.gmail.com> |
aSBjYW4gdW5kZXJzdGFuZCBub3QgcG9zdGluZyB0aGUgamF2YSBjb2RlIC0gbG90cyBvZiBydWxl cyBjb21wYW55J3MKaGF2ZS4uLiBidXQgdGhlIGlBQ1MgRXhwbGFpbiBhbmQgaW5kZXggYWR2aXNv ciBzaG91bGQgaGF2ZSB0aGUgZXhlY3V0aW5nCnNxbCAod2hpY2ggd291bGQgYmUgbW9zdCBoZWxw ZnVsIHRvIHNlZSkuIEEgc29sdXRpb24gbWF5IGJlIGZvdW5kIHdpdGhvdXQKd2FpdGluZyBmb3Ig dGhlIHJld3JpdGUuCklmIHlvdSBoYXZlIGFueSB2aWV3IG9mIHRoZSB0aW1pbmcgb2Ygc3RhZ2Vz IG9mIHRoaXMgdG8gc2VlIHdoZXJlIHRoZSB0aW1lCnNwZW50IChyZXF1ZXN0IHJjdmQsIHRlbXAg aW5kZXhlcyBidWlsdCwgYWN0dWFsIHNlbGVjdGlvbiwgYW55IHBhY2thZ2luZyBvcgphbHRlcmlu ZyByZXN1bHQgc2V0LCB0cmFuc21pdCByZXN1bHRzIHRvIFdpbiwgZXRjLgoKSmltIEZyYW56CgpP biBUdWUsIFNlcCAyLCAyMDI1IGF0IDEyOjMx4oCvUE0gRGFuaWVsIEdyb3NzIDxkYW5pZWxAcXBn bXIuZGU+IHdyb3RlOgoKPiBJIHdvdWxkIGdvIHdpdGggbm8gT1JERVIgQlkgc2hvdWxkIGJlIGZh c3RlciAtIGJlY2F1c2UgT1JERVIgQlkgaXMgYXBwbGllZAo+IHRvIHRoZSByZXN1bHQgc2V0ICh0 aGluayBvbmx5IGluIE9SREVSIEJZIHlvdSBjYW4gdXNlIGNvbHVtbiBudW1iZXIgYW5kCj4gIkFT IiBuYW1lcykgLSBpZiB0aGUgcmVzdWx0IHNldCBoYXMgbm8gb3JkZXJpbmcsIGl0IGNhbiBiZSBz ZW50IHRvIHRoZQo+IGNsaWVudCBhcy1pcy4KPgo+IEpEQkMgY29ubmVjdGlvbiBwYXJhbWV0ZXJz IGNhbiBtYWtlIGEgZGlmZmVyZW5jZS4KPgo+IEZPUiBGRVRDSCBPTkxZIG1pZ2h0IGhlbHAgLSBh bmQgaWYgeW91IGRvbid0IHdhbnQgdG8gZ28gdGhlIFdJVEggTkMgcm91dGUsCj4gdHJ5IFVTRSBD VVJSRU5UTFkgQ09NTUlUVEVEIGluc3RlYWQgLSB0aGlzIHN1cHByZXNzZXMgcmVjb3JkIGxvY2sg dGltZXMsIGFzCj4gaXQgc2ltcGx5IHRha2UgdGhlIGltYWdlIG9mIHRoZSByb3cgYmVmb3JlIHRo ZSBwZW5kaW5nIHRyYW5zYWN0aW9uLgo+Cj4gT2YgY291cnNlIC0gdGhpcyBwcm9jZXNzIHNob3Vs ZCBiZSBmaXhlZCAtIG1heWJlIGJ5IGEgcnVubmluZyBJRCBvciBhCj4gdGltZXN0YW1wIHRoYXQg aXMgc3RvcmVkIHNvbWV3aGVyZSwgYW5kIHdoZXJlIHRoZSBTRUxFQ1QgaXMgZmV0Y2hpbmcgb25s eQo+IG5ldyBvciB1cGRhdGVkIHJlY29yZHMuCj4KPiBFdmVuIGJldHRlciB3b3VsZCBiZSwgbm90 IHRvIHRyYW5zZmVyIGF0IGFsbCwgYnV0IGhhdmUgdGhlIGRhdGFiYXNlCj4gcnVubmluZyBvbiBJ Qk0gaSBhbmQgYWNjZXNzIHRoZSBkYXRhIGRpcmVjdGx5Lgo+Cj4gSFRICj4gRGFuaWVsCj4KPgo+ ID4gQW0gMDIuMDkuMjAyNSB1bSAxNjo0NCBzY2hyaWViIENoYXJsZXMgV2lsdCA8Y2hhcmxlcy53 aWx0QGdtYWlsLmNvbT46Cj4gPgo+ID4g77u/V291bGQgYmUgaGVscGZ1bCB0byBzZWUgdGhlIEph dmEgY29kZSBiZWluZyB1c2VkLgo+ID4gUG9zc2libGUgdGhhdCB0aGUgd2F5IGl0J3Mgd3JpdHRl biBoYXMgYSBsb3QgdG8gZG8gd2l0aCB0aGUgc2xvd25lc3MuCj4gPgo+ID4gTm90IGluY2x1ZGlu ZyBhbiBPUkRFUiBCWSBpcyBhbHdheXMgZ29pbmcgdG8gYmUgZmFzdGVyLi4uCj4gPiBBbHNvIG1h a2Ugc3VyZSB0aGF0IEZPUiBGRVRDSCBPTkxZIFdJVEggTkMgaXMgc3BlY2lmaWVkLgo+ID4KPiA+ IFNvbWUgSkRCQyBwcm9wZXJ0aWVzIHRvIGNvbnNpZGVyCj4gPgo+IGh0dHBzOi8vamF2YWRvYy5p by9zdGF0aWMvbmV0LnNmLmp0NDAwL2p0NDAwLzIxLjAuMC9jb20vaWJtL2FzNDAwL2FjY2Vzcy9k b2MtZmlsZXMvSkRCQ1Byb3BlcnRpZXMuaHRtbAo+ID4gImJsb2NrIGNyaXRlcmlhIgo+ID4gImJs b2NrIHNpemUiCj4gPiAiZGF0YSBjb21wcmVzc2lvbiIKPiA+ICJyZWNlaXZlIGJ1ZmZlciBzaXpl Igo+ID4gInRjcCBubyBkZWxheSIKPiA+Cj4gPiBBbiBhbHRlcm5hdGl2ZSB0byB1c2luZyBibG9j ayBzaXplLCBpcyB0byB1c2Ugc2V0RmV0Y2hTaXplCj4gPgo+IGh0dHBzOi8vamF2YWRvYy5pby9z dGF0aWMvbmV0LnNmLmp0NDAwL2p0NDAwLzIxLjAuMC9jb20vaWJtL2FzNDAwL2FjY2Vzcy9BUzQw MEpEQkNTdGF0ZW1lbnQuaHRtbCNzZXRGZXRjaFNpemUtaW50LQo+ID4KPiA+IE5vdCBzdXJlIG9m ZiB0aGUgdG9wIG9mIG15IGhlYWQgaWYgdGhhdCB3b3VsZCBnaXZlIHlvdSBhIGxhcmdlciBzZXQg b2YKPiA+IHJlY29yZHMgdGhhbiBhIDUxMiBibG9jayBzaXplLgo+ID4gTm90ZSB0aGF0IHRvIHVz ZSBpdCwgYmxvY2sgc2l6ZSBtdXN0IGJlIDAuCj4gPgo+ID4gSFRILAo+ID4gQ2hhcmxlcwo+ID4K PiA+IC0tLS0tLS0tLS0gRm9yd2FyZGVkIG1lc3NhZ2UgLS0tLS0tLS0tCj4gPiBGcm9tOiA8c21p dGg1NjQ2bWlkcmFuZ2VAZ21haWwuY29tPgo+ID4gRGF0ZTogVHVlLCBTZXAgMiwgMjAyNSBhdCA3 OjUy4oCvQU0KPiA+IFN1YmplY3Q6IFNldmVyIHB1bGxpbmcgYSBiYXppbGxpb24gcm93cyBmcm9t IElCTWkgdmlhIEpEQkMgKEkgdGhpbmspCj4gPiBUbzogTWlkcmFuZ2UgU3lzdGVtcyBUZWNobmlj YWwgRGlzY3Vzc2lvbiA8bWlkcmFuZ2UtbEBsaXN0cy5taWRyYW5nZS5jb20KPiA+Cj4gPgo+ID4K PiA+IFdlIGhhdmUgYSBzZXJ2ZXIgdGhhdCBpcyBwdWxsaW5nIGEgYmF6aWxsaW9uIHJvd3Mgdmlh IEpEQkMgKEkgdGhpbmspCj4gZGFpbHkuCj4gPiBVbmZvcnR1bmF0ZWx5LCB3ZSBhcmUgc3R1Y2sg d2l0aCB0aGlzIHByb2Nlc3MgYXMgaXMgZm9yIGEgd2hpbGUgdW50aWwgd2UKPiBjYW4KPiA+IGdl dCBhIHByb2plY3Qgb24gdGhlIHBsYW4gdG8gcHVsbCBvbmx5IG5ldCBjaGFuZ2VzLiAgSXQgY3Vy cmVudGx5IHJ1bnMKPiBmb3IKPiA+IDItMyBob3VycyBlYWNoIGRheS4KPiA+Cj4gPgo+ID4KPiA+ IFdoYXQgaXMgdGhlIGZhc3Rlc3Qgd2F5IHRvIHB1bGwgdGhpcyBkYXRhPyAgV2lsbCBpdCBiZSBm YXN0ZXIgdG8gb21pdCB0aGUKPiA+IG9yZGVyIGJ5IGNsYXVzZSBhbmQganVzdCBsZXQgU1FMIGhh bmQgYmFjayBkYXRhIGluIHdoYXRldmVyIG9yZGVyIHRoYXQgaXQKPiA+IHdhbnRzIG9yIHdvdWxk IGl0IGJlIHF1aWNrZXIgdG8gYWRkIGFuIG9yZGVyIGJ5IGNsYXVzZS4gIEl0IHNlZW1zIGxpa2UK PiA+IGhhdmluZyBhbiBvcmRlciBieSBjbGF1c2Ugd291bGQgc2xvdyBpdCBkb3duIGJlY2F1c2Ug dGhlIGZpbGUgaXMgbm90IGluCj4gYW55Cj4gPiBwYXJ0aWN1bGFyIHNlcXVlbmNlIGJ1dCBJIGFs c28gZGlkbid0IGtub3cgaWYgYW4gb3JkZXIgYnkgUlJOIHdvdWxkIGhlbHAuCj4gPgo+ID4KPiA+ Cj4gPiBBbnkgdGhvdWdodHMgKG90aGVyIHRoYW4gcmV3cml0aW5nIHRoZSBwcm9jZXNzIHdoaWNo IGlzIGluIHRoZSBwbGFucyBidXQKPiA+IHByb2JhYmx5IG5vdCBmb3IgdGhpcyB5ZWFyKT8KPiA+ Cj4gPiAtLQo+ID4gVGhpcyBpcyB0aGUgTWlkcmFuZ2UgU3lzdGVtcyBUZWNobmljYWwgRGlzY3Vz c2lvbiAoTUlEUkFOR0UtTCkgbWFpbGluZwo+IGxpc3QKPiA+IFRvIHBvc3QgYSBtZXNzYWdlIGVt YWlsOiBNSURSQU5HRS1MQGxpc3RzLm1pZHJhbmdlLmNvbQo+ID4gVG8gc3Vic2NyaWJlLCB1bnN1 YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKPiA+IHZpc2l0OiBodHRwczovL2xpc3Rz Lm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL21pZHJhbmdlLWwKPiA+IG9yIGVtYWlsOiBN SURSQU5HRS1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCj4gPiBCZWZvcmUgcG9zdGluZywg cGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwo+ID4gYXQgaHR0cHM6 Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9taWRyYW5nZS1sLgo+ID4KPiA+IFBsZWFzZSBjb250YWN0 IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24gcmVsYXRl ZAo+ID4gcXVlc3Rpb25zLgo+ID4gLS0KPiA+IFRoaXMgaXMgdGhlIEphdmEgUHJvZ3JhbW1pbmcg b24gYW5kIGFyb3VuZCB0aGUgSUJNIGkgKEpBVkE0MDAtTCkgbWFpbGluZwo+IGxpc3QKPiA+IFRv IHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBKQVZBNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4gPiBU byBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAo+ID4gdmlz aXQ6IGh0dHBzOi8vbGlzdHMubWlkcmFuZ2UuY29tL21haWxtYW4vbGlzdGluZm8vamF2YTQwMC1s Cj4gPiBvciBlbWFpbDogSkFWQTQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCj4gPiBC ZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZl cwo+ID4gYXQgaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9qYXZhNDAwLWwuCj4gLS0KPiBU aGlzIGlzIHRoZSBKYXZhIFByb2dyYW1taW5nIG9uIGFuZCBhcm91bmQgdGhlIElCTSBpIChKQVZB NDAwLUwpIG1haWxpbmcKPiBsaXN0Cj4gVG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6IEpBVkE0MDAt TEBsaXN0cy5taWRyYW5nZS5jb20KPiBUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFu Z2UgbGlzdCBvcHRpb25zLAo+IHZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWls bWFuL2xpc3RpbmZvL2phdmE0MDAtbAo+IG9yIGVtYWlsOiBKQVZBNDAwLUwtcmVxdWVzdEBsaXN0 cy5taWRyYW5nZS5jb20KPiBCZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8g cmV2aWV3IHRoZSBhcmNoaXZlcwo+IGF0IGh0dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vamF2 YTQwMC1sLgo+Ci0tIApUaGlzIGlzIHRoZSBKYXZhIFByb2dyYW1taW5nIG9uIGFuZCBhcm91bmQg dGhlIElCTSBpIChKQVZBNDAwLUwpIG1haWxpbmcgbGlzdApUbyBwb3N0IGEgbWVzc2FnZSBlbWFp bDogSkFWQTQwMC1MQGxpc3RzLm1pZHJhbmdlLmNvbQpUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJl LCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAp2aXNpdDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5j b20vbWFpbG1hbi9saXN0aW5mby9qYXZhNDAwLWwKb3IgZW1haWw6IEpBVkE0MDAtTC1yZXF1ZXN0 QGxpc3RzLm1pZHJhbmdlLmNvbQpCZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQg dG8gcmV2aWV3IHRoZSBhcmNoaXZlcwphdCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29tL2ph dmE0MDAtbC4K