Appreciate the response. While the attached code helps get
rid of the error msg, no data is displayed.
I've seen several other notes in the forum where folks have
had other similar "Corba" errors, but have yet to see a fix
for it. I have an easily reproducible test case - you can
simply create a "test" project, create a data source to it
allowing views, create a view to a table, create a data
object referencing that view, and then try to either do a
"view data" in the Studio, or reference the data object in a
page - the Corba error appears if you do the "view data",
and the "28" error happens if you reference in the page.
Some other pertinent information - I'm running NT version 4
service pak 4, Netdynamics 4.1.3.8, and Sybase 11.2.
Any other thoughts/ideas?
Thanks,
Keith
"Mathew, Aby" wrote:
>
> 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]
