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
code.java
