You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by Stephan Coboos <cr...@gmx.net> on 2004/08/21 17:00:09 UTC
[HELP!] HSSFSerializer and XSLTransformer doesn't work together (2nd)
Hello,
I have a problem using XSLTTransformer and HSSFSerializer together. If I do
so, I got a NullPointerException. Vladim talked to me that I have to look
into the xalan sources and to get the original exception but I can't compile
xalan (TransformerImpl) (The source version doesn't macht with the compiled
one?).
NOTE: Using the XSLTTransformer together with XMLSerializer works well but
not with HSSFSerializer.
Can somebody help me please to solve this problem because my company want's
to using Cocoon but only if this basic feature does work in the next days.
It would be great if we are able to use Cocoon in our server park.
This is the file I want to transform:
<?xml version="1.0" encoding="ISO-8859-1"?>
<search-result>
<!-- The result of the search goes here... -->
<content>
<rowset>
<row>
<foo>bar1</foo>
</row>
<row>
<foo>bar2</foo>
</row>
</rowset>
</content>
</search-result>
This is the stylesheet to transform the file above:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:sql="http://apache.org/cocoon/SQL/2.0"
xmlns:gmr="http://www.gnome.org/gnumeric/v7">
<xsl:template match="sql:rowset">
<gmr:Workbook>
<gmr:SheetNameIndex>
<gmr:SheetName>Sheet1</gmr:SheetName>
</gmr:SheetNameIndex>
<gmr:Sheets>
<gmr:Sheet>
<gmr:Name>Sheet1</gmr:Name>
<gmr:MaxCol>-1</gmr:MaxCol>
<gmr:MaxRow>-1</gmr:MaxRow>
<gmr:Cells>
<xsl:for-each select="./sql:row">
<xsl:variable name="rowNum" select="position()-1"/>
<xsl:for-each select="node()">
<xsl:variable name="colNum" select="position()-1"/>
<gmr:Cell Row="{$rowNum}" Col="{$colNum}"
ValueType="60"><xsl:value-of select="."/></gmr:Cell>
</xsl:for-each>
</xsl:for-each>
</gmr:Cells>
</gmr:Sheet>
</gmr:Sheets>
</gmr:Workbook>
</xsl:template>
</xsl:stylesheet>
This is the sitemap entry for this:
<map:match pattern="search/*.xls">
<map:generate type="file" src="test.xml"/>
<map:transform type="xslt" src="stylesheets/searchResult2XLS.xsl"/>
<map:serialize type="xls"/>
</map:match>
And what I get is the following error:
Original Exception: java.lang.RuntimeException:
java.lang.NullPointerException
at
org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.java:3407)
at
org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(TransformerH
andlerImpl.java:433)
at
org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe.java:56)
at
org.apache.cocoon.transformation.TraxTransformer.endDocument(TraxTransformer
.java:562)
at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source)
at
org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatc
h(Unknown Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.excalibur.xml.impl.JaxpParser.parse(JaxpParser.java:296)
.....
Thank you so much!
Regards
Stephan
Re: [HELP!] HSSFSerializer and XSLTransformer doesn't work together (2nd)
Posted by bernhard huber <be...@gmx.at>.
hi,
playing around using:
<?xml version="1.0" encoding="ISO-8859-1"?>
<search-result
xmlns:sql="http://apache.org/cocoon/SQL/2.0"
>
<!-- The result of the search goes here... -->
<content>
<sql:rowset>
<sql:row>
<foo>bar1</foo>
</sql:row>
<sql:row>
<foo>bar2</foo>
</sql:row>
</sql:rowset>
</content>
</search-result>
and xsl
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:gmr="http://www.gnome.org/gnumeric/v7"
xmlns:sql="http://apache.org/cocoon/SQL/2.0"
>
<xsl:template match="search-result">
<gmr:Workbook >
<xsl:apply-templates/>
</gmr:Workbook>
</xsl:template>
<xsl:template match="content">
<gmr:SheetNameIndex>
<gmr:SheetName>Sheet1</gmr:SheetName>
</gmr:SheetNameIndex>
<gmr:Sheets>
<gmr:Sheet>
<gmr:Name>Sheet1</gmr:Name>
<gmr:MaxCol>-1</gmr:MaxCol>
<gmr:MaxRow>-1</gmr:MaxRow>
<gmr:Cells>
<xsl:apply-templates/>
</gmr:Cells>
</gmr:Sheet>
</gmr:Sheets>
</xsl:template>
<xsl:template match="sql:row">
<xsl:variable name="rowNum" select="position()-1"/>
<xsl:for-each select="node()">
<xsl:variable name="colNum" select="position()-1"/>
<gmr:Cell Row="{$rowNum}" Col="{$colNum}" ValueType="60">
<gmr:Content><xsl:value-of select="."/></gmr:Content>
</gmr:Cell>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
there is no npe anymore,
i experienced that it is very important using
<xsl:template match="search-result">
<gmr:Workbook >
<xsl:apply-templates/>
</gmr:Workbook>
</xsl:template>
otherwise npe are thrown
i did'nt delve into trying to understand we the npe are thrown.
but you may want to check hello-world/xsl/page2xls.xsl.
and http://127.0.0.1:8888/samples/blocks/poi/hello.xls
as in this sample the sitemap definition uses
generator-transformer-serializer, too, as in your "npe-example"
regards bernhard
> Hello,
>
> I have a problem using XSLTTransformer and HSSFSerializer together. If I
> do
> so, I got a NullPointerException. Vladim talked to me that I have to look
> into the xalan sources and to get the original exception but I can't
> compile
> xalan (TransformerImpl) (The source version doesn't macht with the
> compiled
> one?).
>
> NOTE: Using the XSLTTransformer together with XMLSerializer works well but
> not with HSSFSerializer.
>
> Can somebody help me please to solve this problem because my company
> want's
> to using Cocoon but only if this basic feature does work in the next days.
> It would be great if we are able to use Cocoon in our server park.
>
> This is the file I want to transform:
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <search-result>
> <!-- The result of the search goes here... -->
> <content>
> <rowset>
> <row>
> <foo>bar1</foo>
> </row>
> <row>
> <foo>bar2</foo>
> </row>
> </rowset>
> </content>
> </search-result>
>
> This is the stylesheet to transform the file above:
>
> <?xml version="1.0"?>
>
> <xsl:stylesheet version="1.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> xmlns:sql="http://apache.org/cocoon/SQL/2.0"
>
> xmlns:gmr="http://www.gnome.org/gnumeric/v7">
>
> <xsl:template match="sql:rowset">
> <gmr:Workbook>
> <gmr:SheetNameIndex>
> <gmr:SheetName>Sheet1</gmr:SheetName>
> </gmr:SheetNameIndex>
> <gmr:Sheets>
> <gmr:Sheet>
> <gmr:Name>Sheet1</gmr:Name>
> <gmr:MaxCol>-1</gmr:MaxCol>
> <gmr:MaxRow>-1</gmr:MaxRow>
> <gmr:Cells>
> <xsl:for-each select="./sql:row">
> <xsl:variable name="rowNum" select="position()-1"/>
> <xsl:for-each select="node()">
> <xsl:variable name="colNum" select="position()-1"/>
> <gmr:Cell Row="{$rowNum}" Col="{$colNum}"
> ValueType="60"><xsl:value-of select="."/></gmr:Cell>
> </xsl:for-each>
> </xsl:for-each>
> </gmr:Cells>
> </gmr:Sheet>
> </gmr:Sheets>
> </gmr:Workbook>
> </xsl:template>
>
> </xsl:stylesheet>
>
> This is the sitemap entry for this:
>
> <map:match pattern="search/*.xls">
> <map:generate type="file" src="test.xml"/>
> <map:transform type="xslt"
> src="stylesheets/searchResult2XLS.xsl"/>
> <map:serialize type="xls"/>
> </map:match>
>
> And what I get is the following error:
>
> Original Exception: java.lang.RuntimeException:
> java.lang.NullPointerException
> at
>
org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.java:3407)
> at
>
org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(TransformerH
> andlerImpl.java:433)
> at
> org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe.java:56)
> at
>
org.apache.cocoon.transformation.TraxTransformer.endDocument(TraxTransformer
> .java:562)
> at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown
> Source)
> at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown
> Source)
> at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
> at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
> at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source)
> at
>
org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatc
> h(Unknown Source)
> at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
> at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
> at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
> at org.apache.excalibur.xml.impl.JaxpParser.parse(JaxpParser.java:296)
> .....
>
> Thank you so much!
>
> Regards
> Stephan
>
>
>
>
--
NEU: Bis zu 10 GB Speicher f�r e-mails & Dateien!
1 GB bereits bei GMX FreeMail http://www.gmx.net/de/go/mail