Re: [xsl] Out OF Memory Exception for Large XML data

["Pankaj Bishnoi" <pankaj.bishnoi@xxxxxxxxxxx>]

Hi Michael
                 Thanks for your help. I set the heap size to 1024 and it
was not helpful. I had also seen the serial link. Now my quesstion is how
can i convert a xsl to serialized one. My XSL is::

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet extension-element-prefixes="redirect" version="1.1"
xmlns:java="http://xml.apache.org/xslt/java";
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
    <xsl:output encoding="UTF-8" indent="yes" method="xml" version="1.0"/>
    <xsl:param name="_userName"/>
    <xsl:param name="_password"/>
    <xsl:param name="_class"/>
    <xsl:param name="_identifier"/>
    <xsl:param name="_subject"/>
    <xsl:variable name="apos">'</xsl:variable>
    <xsl:template match="/">
        <DB>
            <xsl:for-each select="DB/dbo.VW_Ref_Supplier_2_TPL_Supplier">
                <xsl:if test="Ref_Status != 'D'">
                    <dbo.TPL_Supplier>
                        <xsl:variable name="supplierRID" select="12345"/>
                        <xsl:attribute name="Action"/>
                        <xsl:attribute name="RollBackOnError">
                            <xsl:value-of select="'true'"/>
                        </xsl:attribute>
                        <RID>
                            <xsl:value-of select="$supplierRID"/>
                        </RID>
                        <xsl:if test="ST_SupplierPWID != ''">
                            <PWID>
                                <xsl:value-of select="ST_SupplierPWID"/>
                            </PWID>
                        </xsl:if>
                        <PDOPWID>
                            <xsl:value-of select="PDOPWID"/>
                        </PDOPWID>
                        <xsl:if test="Ref_SupplierCode != ST_CustomerKey">
                            <CustomerKey>
                                <xsl:value-of select="Ref_SupplierCode"/>
                            </CustomerKey>
                        </xsl:if>
                       </dbo.TPL_Supplier>
                </xsl:if>
            </xsl:for-each>
        </DB>
    </xsl:template>
</xsl:stylesheet>


Now my quesstion is can i convert this XSL to serialized one?.

Thanks
Pankaj




----- Original Message ----- 
From: "Michael Kay" <mike@xxxxxxxxxxxx>
To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Monday, January 30, 2006 4:43 PM
Subject: RE: [xsl] Out OF Memory Exception for Large XML data


> >          I am having a transformation in which the source file size is
> > large. The source xml size is around 200 MB. So my
> > transformer throws Out of
> > Memory exception after some time. I am using Xalan. This
> > issue also comes
> > when i use Saxon transformer. Is there a way by which i can set some
> > transformer parameter to overcome this problem.
>
> You can set the amount of memory allocated to java using something like
>
> java -Xms1024M -Xmx1024M net.sf.saxon.Transform ....
>
> (or similarly for Xalan, of course).
>
> I wouldn't attempt this with less than 1Gb of main memory.
>
> If the transformation is essentially serial, take a look at
>
> http://www.saxonica.com/documentation/sourcedocs/serial.html
>
> to see if it provides a way forward.
>
> Michael Kay
> http://www.saxonica.com/