System error code 28 is that notorious error:
>>>SYBASE CUR_KEYSET cursors are limited to 1000 rows of data<<<
For which there is no known cause or cure.
What we do is force ND to ignore this error by overriding
_onDatabaseErrorEvent of the DataObject as follows:
=======================================================
public int this_onDatabaseErrorEvent(CSpDataObjectEvent event) {
CSpDBResultStatus status =
event.getDBResults().getResultStatus ();
if (status.getErrorCode() == 28 &&
status.getVendorErrorCode1() == 0 && status.getVendorErrorCode2() == 0) {
event.getDBResults().setResultStatus(new
CSpDBResultStatus(
END_OF_FETCH, "[ENDOFFETCH] End of Fetch",
0,0, "",""));
CSpLog.send(this, CSpLog.USER_DEBUG, "DEBUG SYBASE:
Replacing spurious error "+status.getErrorCode()+
" with END_OF_FETCH
success!");
}
return (PROCEED);
}
=======================================================
Regards,
Aby
> -----Original Message-----
> From: Keith West [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 26, 1999 12:13 PM
> To: [EMAIL PROTECTED]
> Subject: [ND] Corba Error Accessing Sybase View...
>
> I'm getting the following error when I try to perform a "view data" on a
> data object created using a Sybase view:
>
> CORBA::UNKNOWN:0 1 :IDL:omg.org/CORBA/UNKNOWN:1.0
>
> I can execute the view and get the results using ISQL with the same
> username/password as that created for the datasource. When creating the
> data object, Studio can see the view fine, and allows me to create the
> data object, but the "view data" doesn't work.
>
> Trying to use the data object off of a page also doesn't work - get
> error msg back: "System error code is 28 (Data Source execute
> exception)".
>
> All other data objects accessing regular tables work fine.
>
> Any ideas or help would be appreciated.
>
> Thanks,
> Keith
> _________________________________________________________________________
>
> 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]
_________________________________________________________________________
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]
