Re: Sever pulling a bazillion rows from IBMi via JDBC (I think)
Daniel Gross <[email protected]> Tue, 2 Sep 2025 18:30:51 +0200
| Newsgroups | gmane.comp.lang.as400.java |
|---|---|
| Message-ID | <[email protected]> |
SSB3b3VsZCBnbyB3aXRoIG5vIE9SREVSIEJZIHNob3VsZCBiZSBmYXN0ZXIgLSBiZWNhdXNlIE9S REVSIEJZIGlzIGFwcGxpZWQgdG8gdGhlIHJlc3VsdCBzZXQgKHRoaW5rIG9ubHkgaW4gT1JERVIg QlkgeW91IGNhbiB1c2UgY29sdW1uIG51bWJlciBhbmQgIkFTIiBuYW1lcykgLSBpZiB0aGUgcmVz dWx0IHNldCBoYXMgbm8gb3JkZXJpbmcsIGl0IGNhbiBiZSBzZW50IHRvIHRoZSBjbGllbnQgYXMt aXMuCgpKREJDIGNvbm5lY3Rpb24gcGFyYW1ldGVycyBjYW4gbWFrZSBhIGRpZmZlcmVuY2UuCgpG T1IgRkVUQ0ggT05MWSBtaWdodCBoZWxwIC0gYW5kIGlmIHlvdSBkb24ndCB3YW50IHRvIGdvIHRo ZSBXSVRIIE5DIHJvdXRlLCB0cnkgVVNFIENVUlJFTlRMWSBDT01NSVRURUQgaW5zdGVhZCAtIHRo aXMgc3VwcHJlc3NlcyByZWNvcmQgbG9jayB0aW1lcywgYXMgaXQgc2ltcGx5IHRha2UgdGhlIGlt YWdlIG9mIHRoZSByb3cgYmVmb3JlIHRoZSBwZW5kaW5nIHRyYW5zYWN0aW9uLgoKT2YgY291cnNl IC0gdGhpcyBwcm9jZXNzIHNob3VsZCBiZSBmaXhlZCAtIG1heWJlIGJ5IGEgcnVubmluZyBJRCBv ciBhIHRpbWVzdGFtcCB0aGF0IGlzIHN0b3JlZCBzb21ld2hlcmUsIGFuZCB3aGVyZSB0aGUgU0VM RUNUIGlzIGZldGNoaW5nIG9ubHkgbmV3IG9yIHVwZGF0ZWQgcmVjb3Jkcy4KCkV2ZW4gYmV0dGVy IHdvdWxkIGJlLCBub3QgdG8gdHJhbnNmZXIgYXQgYWxsLCBidXQgaGF2ZSB0aGUgZGF0YWJhc2Ug cnVubmluZyBvbiBJQk0gaSBhbmQgYWNjZXNzIHRoZSBkYXRhIGRpcmVjdGx5LiAKCkhUSApEYW5p ZWwKCgo+IEFtIDAyLjA5LjIwMjUgdW0gMTY6NDQgc2NocmllYiBDaGFybGVzIFdpbHQgPGNoYXJs ZXMud2lsdEBnbWFpbC5jb20+Ogo+IAo+IO+7v1dvdWxkIGJlIGhlbHBmdWwgdG8gc2VlIHRoZSBK YXZhIGNvZGUgYmVpbmcgdXNlZC4KPiBQb3NzaWJsZSB0aGF0IHRoZSB3YXkgaXQncyB3cml0dGVu IGhhcyBhIGxvdCB0byBkbyB3aXRoIHRoZSBzbG93bmVzcy4KPiAKPiBOb3QgaW5jbHVkaW5nIGFu IE9SREVSIEJZIGlzIGFsd2F5cyBnb2luZyB0byBiZSBmYXN0ZXIuLi4KPiBBbHNvIG1ha2Ugc3Vy ZSB0aGF0IEZPUiBGRVRDSCBPTkxZIFdJVEggTkMgaXMgc3BlY2lmaWVkLgo+IAo+IFNvbWUgSkRC QyBwcm9wZXJ0aWVzIHRvIGNvbnNpZGVyCj4gaHR0cHM6Ly9qYXZhZG9jLmlvL3N0YXRpYy9uZXQu c2YuanQ0MDAvanQ0MDAvMjEuMC4wL2NvbS9pYm0vYXM0MDAvYWNjZXNzL2RvYy1maWxlcy9KREJD UHJvcGVydGllcy5odG1sCj4gImJsb2NrIGNyaXRlcmlhIgo+ICJibG9jayBzaXplIgo+ICJkYXRh IGNvbXByZXNzaW9uIgo+ICJyZWNlaXZlIGJ1ZmZlciBzaXplIgo+ICJ0Y3Agbm8gZGVsYXkiCj4g Cj4gQW4gYWx0ZXJuYXRpdmUgdG8gdXNpbmcgYmxvY2sgc2l6ZSwgaXMgdG8gdXNlIHNldEZldGNo U2l6ZQo+IGh0dHBzOi8vamF2YWRvYy5pby9zdGF0aWMvbmV0LnNmLmp0NDAwL2p0NDAwLzIxLjAu MC9jb20vaWJtL2FzNDAwL2FjY2Vzcy9BUzQwMEpEQkNTdGF0ZW1lbnQuaHRtbCNzZXRGZXRjaFNp emUtaW50LQo+IAo+IE5vdCBzdXJlIG9mZiB0aGUgdG9wIG9mIG15IGhlYWQgaWYgdGhhdCB3b3Vs ZCBnaXZlIHlvdSBhIGxhcmdlciBzZXQgb2YKPiByZWNvcmRzIHRoYW4gYSA1MTIgYmxvY2sgc2l6 ZS4KPiBOb3RlIHRoYXQgdG8gdXNlIGl0LCBibG9jayBzaXplIG11c3QgYmUgMC4KPiAKPiBIVEgs Cj4gQ2hhcmxlcwo+IAo+IC0tLS0tLS0tLS0gRm9yd2FyZGVkIG1lc3NhZ2UgLS0tLS0tLS0tCj4g RnJvbTogPHNtaXRoNTY0Nm1pZHJhbmdlQGdtYWlsLmNvbT4KPiBEYXRlOiBUdWUsIFNlcCAyLCAy MDI1IGF0IDc6NTLigK9BTQo+IFN1YmplY3Q6IFNldmVyIHB1bGxpbmcgYSBiYXppbGxpb24gcm93 cyBmcm9tIElCTWkgdmlhIEpEQkMgKEkgdGhpbmspCj4gVG86IE1pZHJhbmdlIFN5c3RlbXMgVGVj aG5pY2FsIERpc2N1c3Npb24gPG1pZHJhbmdlLWxAbGlzdHMubWlkcmFuZ2UuY29tPgo+IAo+IAo+ IFdlIGhhdmUgYSBzZXJ2ZXIgdGhhdCBpcyBwdWxsaW5nIGEgYmF6aWxsaW9uIHJvd3MgdmlhIEpE QkMgKEkgdGhpbmspIGRhaWx5Lgo+IFVuZm9ydHVuYXRlbHksIHdlIGFyZSBzdHVjayB3aXRoIHRo aXMgcHJvY2VzcyBhcyBpcyBmb3IgYSB3aGlsZSB1bnRpbCB3ZSBjYW4KPiBnZXQgYSBwcm9qZWN0 IG9uIHRoZSBwbGFuIHRvIHB1bGwgb25seSBuZXQgY2hhbmdlcy4gIEl0IGN1cnJlbnRseSBydW5z IGZvcgo+IDItMyBob3VycyBlYWNoIGRheS4KPiAKPiAKPiAKPiBXaGF0IGlzIHRoZSBmYXN0ZXN0 IHdheSB0byBwdWxsIHRoaXMgZGF0YT8gIFdpbGwgaXQgYmUgZmFzdGVyIHRvIG9taXQgdGhlCj4g b3JkZXIgYnkgY2xhdXNlIGFuZCBqdXN0IGxldCBTUUwgaGFuZCBiYWNrIGRhdGEgaW4gd2hhdGV2 ZXIgb3JkZXIgdGhhdCBpdAo+IHdhbnRzIG9yIHdvdWxkIGl0IGJlIHF1aWNrZXIgdG8gYWRkIGFu IG9yZGVyIGJ5IGNsYXVzZS4gIEl0IHNlZW1zIGxpa2UKPiBoYXZpbmcgYW4gb3JkZXIgYnkgY2xh dXNlIHdvdWxkIHNsb3cgaXQgZG93biBiZWNhdXNlIHRoZSBmaWxlIGlzIG5vdCBpbiBhbnkKPiBw YXJ0aWN1bGFyIHNlcXVlbmNlIGJ1dCBJIGFsc28gZGlkbid0IGtub3cgaWYgYW4gb3JkZXIgYnkg UlJOIHdvdWxkIGhlbHAuCj4gCj4gCj4gCj4gQW55IHRob3VnaHRzIChvdGhlciB0aGFuIHJld3Jp dGluZyB0aGUgcHJvY2VzcyB3aGljaCBpcyBpbiB0aGUgcGxhbnMgYnV0Cj4gcHJvYmFibHkgbm90 IGZvciB0aGlzIHllYXIpPwo+IAo+IC0tCj4gVGhpcyBpcyB0aGUgTWlkcmFuZ2UgU3lzdGVtcyBU ZWNobmljYWwgRGlzY3Vzc2lvbiAoTUlEUkFOR0UtTCkgbWFpbGluZyBsaXN0Cj4gVG8gcG9zdCBh IG1lc3NhZ2UgZW1haWw6IE1JRFJBTkdFLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4gVG8gc3Vic2Ny aWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKPiB2aXNpdDogaHR0cHM6 Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9taWRyYW5nZS1sCj4gb3IgZW1h aWw6IE1JRFJBTkdFLUwtcmVxdWVzdEBsaXN0cy5taWRyYW5nZS5jb20KPiBCZWZvcmUgcG9zdGlu ZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwo+IGF0IGh0dHBz Oi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vbWlkcmFuZ2UtbC4KPiAKPiBQbGVhc2UgY29udGFjdCBz dXBwb3J0QHN1cHBvcnQubWlkcmFuZ2UuY29tIGZvciBhbnkgc3Vic2NyaXB0aW9uIHJlbGF0ZWQK PiBxdWVzdGlvbnMuCj4gLS0KPiBUaGlzIGlzIHRoZSBKYXZhIFByb2dyYW1taW5nIG9uIGFuZCBh cm91bmQgdGhlIElCTSBpIChKQVZBNDAwLUwpIG1haWxpbmcgbGlzdAo+IFRvIHBvc3QgYSBtZXNz YWdlIGVtYWlsOiBKQVZBNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4gVG8gc3Vic2NyaWJlLCB1 bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKPiB2aXNpdDogaHR0cHM6Ly9saXN0 cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9qYXZhNDAwLWwKPiBvciBlbWFpbDogSkFW QTQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCj4gQmVmb3JlIHBvc3RpbmcsIHBsZWFz ZSB0YWtlIGEgbW9tZW50IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKPiBhdCBodHRwczovL2FyY2hp dmUubWlkcmFuZ2UuY29tL2phdmE0MDAtbC4KLS0gClRoaXMgaXMgdGhlIEphdmEgUHJvZ3JhbW1p bmcgb24gYW5kIGFyb3VuZCB0aGUgSUJNIGkgKEpBVkE0MDAtTCkgbWFpbGluZyBsaXN0ClRvIHBv c3QgYSBtZXNzYWdlIGVtYWlsOiBKQVZBNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tClRvIHN1YnNj cmliZSwgdW5zdWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMsCnZpc2l0OiBodHRwczov L2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL2phdmE0MDAtbApvciBlbWFpbDog SkFWQTQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCkJlZm9yZSBwb3N0aW5nLCBwbGVh c2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVzCmF0IGh0dHBzOi8vYXJjaGl2 ZS5taWRyYW5nZS5jb20vamF2YTQwMC1sLgo=