I think the default max rows for executeImmediate is 999.
This is from an ND doc:
The max number of rows retrieved using this method is DEFAULT_MAX_NUMBER_OF_ROWS
(999).
Use executeImmediate(java.lang.String, java.lang.String, int) if you need to retrieve
more..
Suyoto Tandio
"Damian O'Connor" <[EMAIL PROTECTED]> wrote:
>This is a multi-part message in MIME format.
>
>---=_forums.netdynamics.com384547d3
>Content-Type: text/plain
>Content-Transfer-Encoding: 7bit
>
>
>Hi folks,
>
>We have a confusing problem with SYBASE under ND4. Our ND machine is NT with
>the ND 4.1.3.8 installed. We've just recently moved our project from ND3 to ND4. In
>production we have a dataobject being executed and a executeImmediate call. Both
>work but when the getNumOfRows() method is called the dataobject returns the
>correct number for the SQL passed, while the result from the executeImmediate call
>returns 999?
>
>If we recycle the RDBMS service this clears the problem..for a while. We are using
>SYBASE native drivers. I've attached the code incase anybody can help us. Maybe we're
>missing something obvious. This code WORKED under ND3.
>
>One other thing, not all our dataobjects use the MEMORY_FETCH_TABLE_METHOD,
>as described throughout these forums, therefore we do see the 'scrolling cursor' and
>'sequential cursor' errors in the log. Can these errors confuse the RDBMS service? and
>should the MEMORY_FETCH_TABLE_METHOD be used on ALL CSpDataObject types,
>i.e., CSpSelect, CSpMultiSQL etc.
>
>Cheers,
>Damian
>Hewlett Packard
>Ireland
>
>---=_forums.netdynamics.com384547d3
>Content-Type: application/x-unknown-content-type-Spider.Java; name="C:\TEMP\code.java"
>Content-Transfer-Encoding: base64
>Content-Disposition: attachment; filename="code.java"
>
>CXByaXZhdGUgdm9pZCBnZXRDb252ZXJzaW9uUmF0ZXMoIENTcFNlbGVjdCBv
>cmlnRGF0YU9iamVjdCwgVmVjdG9yIGN1cnJlbmNpZXMgKSB0aHJvd3MgQ0hw
>SW52YWxpZEV4Y2hhbmdlUmF0ZUV4Y2VwdGlvbiwgRXhjZXB0aW9uDQoJew0K
>CQlDU3BIYXNoVGFibGUgcmF0ZXNUYWJsZSA9IG5ldyBDU3BIYXNoVGFibGUo
>KTsJCQkJCQkJCQkJLy8gU3RvcmVzIHRoZSBjb252ZXJzaW9uIHJhdGVzDQoJ
>CVN0cmluZyBiYXNlQ3VycmVuY3kgPSBDSHBlRmluYW5jZVV0aWwuSFBfU1RS
>X0NVUlJFTkNZX0NPTlZfQkFTRV9DVVJSRU5DWTsJLy8gQmFzZSBjdXJyZW5j
>eSBmb3IgY29udmVyc2lvbnMNCgkJDQoJCS8vIENoZWNrIHRoYXQgdGhlcmUg
>YXJlIG5vdCB0b28gbWFueSBjdXJyZW5jaWVzDQoJCWlmICggY3VycmVuY2ll
>cy5zaXplKCkgPiBDSHBSZXBvcnRzUGFnZS5IUF9SRVBPUlRTX01BWF9DVVJS
>RU5DSUVTICkNCgkJew0KCQkJdGhyb3cgbmV3IEV4Y2VwdGlvbigJIlRvbyBt
>YW55IGN1cnJlbmNpZXMgcGFzc2VkIHRvIGdldENvbnZlcnNpb25SYXRlcygp
>IC0gIg0KCQkJCQkJCQkJCSsgIk1heCA9ICIgKyBDSHBSZXBvcnRzUGFnZS5I
>UF9SRVBPUlRTX01BWF9DVVJSRU5DSUVTDQoJCQkJCQkJCQkJKyAiOyBjdXJy
>ZW5jaWVzID0gIiArIGN1cnJlbmNpZXMgKTsNCgkJfQ0KCQkNCgkJLy8gRXN0
>YWJsaXNoIHdoZXRoZXIgdGhlcmUgYXJlIGFueSBkeW5hbWljIG9yIGZpbHRl
>ciBjcml0ZXJpYSBzcGVjaWZpZWQgZm9yIHRoZSBvcmlnaW5hbCBzZWFyY2gg
>ZGF0YSBvYmplY3QgLSANCgkJLy8gaWYgdGhlcmUgYXJlIG5vbmUsIHdlIGRv
>bid0IHdhbnQgdG8gYWRkIHRoZW0gdG8gdGhlIHF1ZXJ5IGJlbG93LCBzbyB1
>c2UgYW4gZW1wdHkgc3RyaW5nDQoJCVN0cmluZyBzZWxlY3RKb2luCQkJPSAo
>CW9yaWdEYXRhT2JqZWN0LmdldFNlbGVjdEpvaW5TdHIoKS5sZW5ndGgoKSA+
>IDAgPw0KCQkJCQkJCQkJCQkJb3JpZ0RhdGFPYmplY3QuZ2V0U2VsZWN0Sm9p
>blN0cigpICsgIiBBTkQgIiA6ICIiICk7DQoJCVN0cmluZyBkeW5hbWljQ3Jp
>dGVyYQk9ICgJb3JpZ0RhdGFPYmplY3QuZ2V0RHluYW1pY0NyaXRlcmlhKCku
>bGVuZ3RoKCkgPiAwID8NCgkJCQkJCQkJCQkJCW9yaWdEYXRhT2JqZWN0Lmdl
>dER5bmFtaWNDcml0ZXJpYSgpICsgIiBBTkQgIiA6ICIiICk7DQoJCVN0cmlu
>ZyBmaWx0ZXJDcml0ZXJpYQk9ICgJb3JpZ0RhdGFPYmplY3QuZ2V0RmlsdGVy
>U3RyKCkubGVuZ3RoKCkgPiAwID8NCgkJCQkJCQkJCQkJCW9yaWdEYXRhT2Jq
>ZWN0LmdldEZpbHRlclN0cigpICsgIiBBTkQgIiA6ICIiICk7DQoJCQ0KCQkv
>LyBCdWlsZCB0aGUgU1FMIHF1ZXJ5LCBzdGFydGluZyB3aXRoIHRoZSB0YWJs
>ZXMgYW5kIGNyaXRlcmlhIHVzZWQgYnkgdGhlIHJlcG9ydCdzIG9yaWdpbmFs
>IHNlYXJjaCBkYXRhIG9iamVjdCwNCgkJLy8gdXNpbmcgdGhlIGZvbGxvd2lu
>ZyBtZXRob2RzIG9mIHRoZSBvcmlnaW5hbCBkYXRhIG9iamVjdDoNCgkJLy8g
>CWdldFRhYmxlc0xpc3RTdHIoKToJCXJldHVybnMgYWxsIHRhYmxlcyBzcGVj
>aWZpZWQgaW4gdGhlIHN0dWRpbw0KCQkvLyAJZ2V0U2VsZWN0Sm9pblN0cigp
>OgkJcmV0dXJucyBhbGwgam9pbnMgc3BlY2lmaWVkIGluIHRoZSBzdHVkaW8N
>CgkJLy8gCWdldEZpbHRlclN0cigpOgkJCXJldHVybnMgYWxsICdXSEVSRScg
>Y3JpdGVyaWEgc3BlY2lmaWVkIGluIHRoZSBzdHVkaW8NCgkJLy8gCWdldER5
>bmFtaWNDcml0ZXJpYSgpOglyZXR1cm5zIGFsbCAnV0hFUkUnIGNyaXRlcmlh
>IGFkZGVkIGluIHRoZSBjb2RlDQoJCVN0cmluZ0J1ZmZlciBjb2x1bW5zID0g
>bmV3IFN0cmluZ0J1ZmZlciggIlNFTEVDVCBkYm8ucHJvcG9zYWwucHJvcG9z
>YWxfaWQsIGRiby5wcm9wb3NhbC5wcm9wb3NhbF92ZXJzaW9uIiApOw0KCQlT
>dHJpbmdCdWZmZXIgdGFibGVzID0gbmV3IFN0cmluZ0J1ZmZlciggIiBGUk9N
>ICIgKyBvcmlnRGF0YU9iamVjdC5nZXRUYWJsZXNMaXN0U3RyKCkgKyAiLCBk
>Ym8uY3VycmVuY3lfY29udiBhIiApOw0KCQlTdHJpbmdCdWZmZXIgY3JpdGVy
>aWEgPSBuZXcgU3RyaW5nQnVmZmVyKCAiIFdIRVJFICIgKyBzZWxlY3RKb2lu
>ICsgZHluYW1pY0NyaXRlcmEgKyBmaWx0ZXJDcml0ZXJpYSArDQoJCQkJCQkJ
>CQkJCQkJCQkJIiBhLmZyb21fY3VycmVuY3lfY29kZSA9ICciICsgYmFzZUN1
>cnJlbmN5ICsgIiciICsNCgkJCQkJCQkJCQkJCQkJCQkiIEFORCBhLnRvX2N1
>cnJlbmN5X2NvZGUgPSBkYm8ucHJvcG9zYWwuY3VycmVuY3lfY29kZSIgKw0K
>CQkJCQkJCQkJCQkJCQkJCSIgQU5EIElTTlVMTCggYS5hY3RpdmVfZGF0ZSwg
>JzE5MDAvMDEvMDEnICkiICsNCgkJCQkJCQkJCQkJCQkJCQkiIDw9IGRiby5w
>cm9wb3NhbC5sYXN0X3ByaWNpbmdfZGF0ZSIgKw0KCQkJCQkJCQkJCQkJCQkJ
>CSIgQU5EIElTTlVMTCggYS5pbmFjdGl2ZV9kYXRlLCAnMjEwMC8wMS8wMScg
>KSIgKw0KCQkJCQkJCQkJCQkJCQkJCSIgPiBkYm8ucHJvcG9zYWwubGFzdF9w
>cmljaW5nX2RhdGUiICk7DQoNCgkJREVCVUdfVEhJU19NU0coICJnZXRDb252
>ZXJzaW9uUmF0ZXM6IGdldFRhYmxlc0xpc3RTdHIgPSAiICsgb3JpZ0RhdGFP
>YmplY3QuZ2V0VGFibGVzTGlzdFN0cigpICk7DQoJCURFQlVHX1RISVNfTVNH
>KCAiZ2V0Q29udmVyc2lvblJhdGVzOiBnZXRTZWxlY3RKb2luU3RyID0gIiAr
>IG9yaWdEYXRhT2JqZWN0LmdldFNlbGVjdEpvaW5TdHIoKSApOw0KCQlERUJV
>R19USElTX01TRyggImdldENvbnZlcnNpb25SYXRlczogZ2V0RHluYW1pY0Ny
>aXRlcmlhID0gIiArIG9yaWdEYXRhT2JqZWN0LmdldER5bmFtaWNDcml0ZXJp
>YSgpICk7DQoJCURFQlVHX1RISVNfTVNHKCAiZ2V0Q29udmVyc2lvblJhdGVz
>OiBnZXRGaWx0ZXJTdHIgPSAiICsgb3JpZ0RhdGFPYmplY3QuZ2V0RmlsdGVy
>U3RyKCkgKTsNCgkJDQoJCS8vIExvb3AgdGhyb3VnaCB0aGUgY3VycmVuY2ll
>cyB0byBiZSBkaXNwbGF5ZWQgaW4gdGhlIHJlcG9ydCwgYW5kIGFkZCBkZXRh
>aWxzIG9mIHRoZSBjb2x1bW5zLCB0YWJsZXMNCgkJLy8gYW5kIGNyaXRlcmlh
>IG5lZWRlZCB0byBidWlsZCB0aGUgU1FMIHN0YXRlbWVudCB0byByZXRyaWV2
>ZSByYXRlcyBmb3IgYWxsIHJlcG9ydCBjdXJyZW5jaWVzLg0KCQlmb3IgKCBp
>bnQgaSA9IDA7IGkgPCBjdXJyZW5jaWVzLnNpemUoKTsgaSsrICkNCgkJew0K
>CQkJLy8gTXVsdGlwbGUgam9pbnMgdG8gdGhlIGN1cnJlbmN5X2NvbnYgdGFi
>bGUgYXJlIG5lZWRlZCwgc28gY3JlYXRlIGEgdW5pcXVlIGFsaWFzIGZvciB0
>aGlzIGN1cnJlbmN5DQoJCQljaGFyIHRhYmxlQWxpYXMgPSAoY2hhcikgKCAn
>YicgKyBpICk7DQoJCQkNCgkJCS8vIFBvcHVsYXRlIHRoZSBhcnJheXMNCgkJ
>CWNvbHVtbnMuYXBwZW5kKCAiLCBJU05VTEwoKCAiICsgdGFibGVBbGlhcyAr
>ICIuY29udl9yYXRlIC8gYS5jb252X3JhdGUgKSwgMCApIiApOw0KCQkJdGFi
>bGVzLmFwcGVuZCggIiwgY3VycmVuY3lfY29udiAiICsgdGFibGVBbGlhcyAp
>Ow0KCQkJY3JpdGVyaWEuYXBwZW5kKAkiIEFORCAiICsgdGFibGVBbGlhcyAr
>ICIuZnJvbV9jdXJyZW5jeV9jb2RlID0gJyIgKyBiYXNlQ3VycmVuY3kgKyAi
>JyIgKw0KCQkJCQkJCQkJIiBBTkQgIiArIHRhYmxlQWxpYXMgKyAiLnRvX2N1
>cnJlbmN5X2NvZGUgPSAnIiArIGN1cnJlbmNpZXMuZWxlbWVudEF0KCBpICkg
>KyAiJyIgKw0KCQkJCQkJCQkJIiBBTkQgSVNOVUxMKCAiICsgdGFibGVBbGlh
>cyArICIuYWN0aXZlX2RhdGUsICcxOTAwLzAxLzAxJyApIDw9IHByb3Bvc2Fs
>Lmxhc3RfcHJpY2luZ19kYXRlIiArDQoJCQkJCQkJCQkiIEFORCBJU05VTEwo
>ICIgKyB0YWJsZUFsaWFzICsgIi5pbmFjdGl2ZV9kYXRlLCAnMjEwMC8wMS8w
>MScgKSA+IHByb3Bvc2FsLmxhc3RfcHJpY2luZ19kYXRlIiApOw0KCQl9DQoJ
>CQ0KCQlTdHJpbmdCdWZmZXIgcXVlcnkgPSBjb2x1bW5zLmFwcGVuZCggdGFi
>bGVzICkuYXBwZW5kKCBjcml0ZXJpYSApOw0KCQkNCgkJREVCVUdfVEhJU19N
>U0coICJnZXRDb252ZXJzaW9uUmF0ZXMgOiBTUUwgcXVlcnkgPSAiICsgcXVl
>cnkgKTsNCgkNCgkJLy8gRXhlY3V0ZSB0aGUgcXVlcnkNCgkJQ1NwREJSZXN1
>bHQgcmVzdWx0ID0gQ1NwRGF0YU9iamVjdC5leGVjdXRlSW1tZWRpYXRlICgg
>ImRzX2VmaW5hbmNlZGIiLCBxdWVyeS50b1N0cmluZygpICk7DQoJCQ0KCQkv
>LyBHZXQgdGhlIHN0YXR1cyBvYmplY3QgZnJvbSB0aGUgcXVlcnkNCgkJQ1Nw
>REJSZXN1bHRTdGF0dXMgc3RhdHVzID0gcmVzdWx0LmdldFJlc3VsdFN0YXR1
>cygpOw0KCQkNCgkJaWYgKCBzdGF0dXMuZ2V0RXJyb3JDb2RlKCkgIT0gQ1Nw
>RGF0YU9iamVjdC5TVUNDRVNTICYmIHN0YXR1cy5nZXRFcnJvckNvZGUoKSAh
>PSBDU3BEYXRhT2JqZWN0LkVORF9PRl9GRVRDSCApDQoJCXsNCgkJCXRocm93
>IG5ldyBDSHBJbnZhbGlkRXhjaGFuZ2VSYXRlRXhjZXB0aW9uKAkiRGF0YWJh
>c2UgZXJyb3I6ICIgKyBzdGF0dXMuZ2V0RXJyb3JDb2RlKCkgKyAiIC0gIg0K
>CQkJCQkJCQkJCQkJCQkJCQkJKyBzdGF0dXMuZ2V0RXJyb3JNZXNzYWdlKCkg
>KTsNCgkJfQ0KCQkNCgkJLy8gR2V0IHRoZSByZXN1bHQgdGFibGUgZnJvbSB0
>aGUgcXVlcnkNCgkJQ1NwREJSZXN1bHRUYWJsZSByZXN1bHRUYWJsZSA9IHJl
>c3VsdC5nZXRSZXN1bHRUYWJsZSgpOw0KCQkNCgkJLy8gSWYgYWxsIGhhcyBn
>b25lIHdlbGwsIHRoZXJlIHNob3VsZCBiZSBvbmUgcm93IHJldHVybmVkIGZv
>ciBlYWNoIGRlYWwgaW4gdGhlIHJlcG9ydA0KCQlpZiAoIHJlc3VsdFRhYmxl
>LmdldE51bU9mUm93cygpICE9IG9yaWdEYXRhT2JqZWN0LmdldE51bU9mUm93
>cygpICkNCgkJew0KCQkJLy8gVGhlcmUgYXJlIGVpdGhlciBkdXBsaWNhdGUg
>b3IgbWlzc2luZyByb3dzDQoJCQl0aHJvdyBuZXcgQ0hwSW52YWxpZEV4Y2hh
>bmdlUmF0ZUV4Y2VwdGlvbiggIkR1cGxpY2F0ZSBvciBtaXNzaW5nIGNvbnZl
>cnNpb24gcmF0ZSByb3dzIiApOw0KCQl9DQoNCg==
>
>---=_forums.netdynamics.com384547d3--
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
