Hi Dan,
You are correct in there is currently somewhat of a limitation in
non-streaming mode on the
number of records that can be handled. This is because of the segmented
DTM mechanism
internal to Xalan. Currently the SQL extensions only can handle one
segment so eventually
you run out of DTMID's. The project to overcome this limitation is on my
list but there have
been almost no inquiries so its priority has been fairly low. As a work
around, you can enable
streaming mode then create a variable that is a "copy-of" of your query.
How are your Java skills, if you have the time I would be willing to
walk you through the
problem, then review the code once you come up with a fix. Its not a
particularly hard
problem but the devil is in the details..
Regards
John Gentilin
Dan Feather wrote:
Hello,
I am using the SQL-Extension and I running into a problem that I
think is related to the number of records in a result set and I am not
using streaming mode. I need to make recursive stylesheet calls and
access previous rows, so I cannot use streaming mode.
My table has 10 columns, and 3,183 rows in this case. When I run
my stylesheet over this table I immediately get a NullPointerException.
However, if I delete around 80 rows and run it, everything works fine. I
can delete a different 80 rows (to eliminate it being a problem in the
data contained in one of the rows) and it works fine. It seems to happen
right around 3100 rows. I haven't gone and deleted one row at a time yet
to determine the exact number of rows in this case.
Anyway, my question is has anyone experienced similar behavior?
Are there any known changes or work arounds for this problem? Is this a
known issue? If you would like more information I would be happy to
provide it, but I figured I would just see if this rang any bells with
anyone before we dove to far into the code. I appreciate your help.
-Dan
--
--------------------------------------
John Gentilin
Eye Catching Solutions Inc.
18314 Carlwyn Drive
Castro Valley CA 94546
Contact Info
[EMAIL PROTECTED]
Ca Office 1-510-881-4821
NJ Office 1-732-422-4917
