Suresh,
No proper solution ever reached us from anywhere.
The workaround we did was to override the onDataBaseErrorEvent of the
concerned DataObject, check for the vendor error code. If it is 28,
return SUCCESS (to tell ND that it is okay, whatever happened has
happened, life has to go on).
Unfortunately, I don't have the sample code with me anymroe. I remember
posting it in the forum.
In fact we ended up subclassing CSpDataObject and make it the superclass
for all our data objects.
Regards,
Aby
-----Original Message-----
From: Suresh Meher [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 10, 1999 8:18 AM
To: [EMAIL PROTECTED]
Subject: Re: [ND] ND4: Sybase CUR_KEYSET >1000 rows workaround?
did you get the solution?
i am also facing the same problem. could you please send the workaround
if you
have any.
thanks
suresh
"Mathew, Aby" wrote:
>
> > Hi Les (and Isabel, Jayadev and Suryanarayana) and others -
> >
> >
> > Back to an old thread. Thanks for your suggestions.
> >
> > Unfortunately none of the things have worked so far. (even the ND
3.1
> > method :
> > protected int onBeforeExecuteEvent (CSpDBRequest request)
> >
> >
> > What we have done is :
> > public int this_onBeforeExecuteEvent(CSpDataObjectEvent event)
> > { event.getDBRequest().getDBExecuteControl().setFetchMethod
> > (CSpDBExecuteControl.MEMORY_TABLE_FETCH_METHOD);
> > return (PROCEED);
> > }
> >
> > With the help of log messages, we have made sure that this code is
being
> > executed. Also confirmed it using getFetchMethod in the
> > onAfterExecuteEvent(CSpDataObjectEvent event).
> > The observations are :
> > No matter what method we set (MEMORY_TABLE_FETCH_METHOD,
> > SEQUENTIAL_CURSOR_FETCH_METHOD etc), we invariably get the
following
> > messages from the DSRdbmsService:
> > ===============================================================
> > DSRdbmsService: fetching result table using MemoryTable method
> > DSRdbmsService: fetching all rows -- 1965
> > DSRdbmsService: end-of-fetch: 1965 rows retrieved out of the
-1
> > requested
> > DSRdbmsService: end-of-fetch: bounced into first or last row
during
> > fetch
> > Error 286 DSRdbmsService: SYBASE CUR_KEYSET cursors are limited
to
> > 1000 rows of data.
> > DSRdbmsService: memoryTableFetch: Sybase cursor limit exceeded
> > ==============================================================
> > The last line clearly says: memoryTableFetch: Sybase cursor limit
> > exceed!
> > Any suggestions?
> > Thanks,
> >
> > Aby Mathew
> > (BTW, I am working with Robert Wells on this.)
> >
> >
> >
________________________________________________________________________
_
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]
