cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <>
Subject Error with SQL Transformer - nested query + Filter Transformer
Date Tue, 20 Jan 2009 09:52:50 GMT
Working with Cocoon 2.1.8, Windows XP

With reference to this thread: 
which did not seem to be resolved, I am also having
problems with the Filter Transformer.  The error I have is:

  at org.apache.xml.utils.IntStack.peek(
  at org.apache.xml.dtm.ref.sax2dtm.SAX2DTM.endElement(
  at org.apache.xalan.transformer.TransformerHandlerImpl.endElement(
  at org.apache.cocoon.xml.AbstractXMLPipe.endElement(
  at org.apache.cocoon.transformation.FilterTransformer.endElement(
  at org.apache.cocoon.xml.AbstractXMLPipe.endElement(

Attached are relevant portions of code/data.



    <sq2:query name="source-list">
      SELECT DISTINCT source.sourceID AS sourceid
      FROM source
   <!-- problem for filter transformer ??? if removed then no error...   -->
      <sq2:query name="source-viability">    
      SELECT DISTINCT ViabilityDate AS viabilitydate, ViabilityStatus AS viabilitystatus
      FROM sourceviability
      WHERE sourceID=<sq2:ancestor-value sq2:name="source.sourceID" sq2:level="1"/>
      ORDER BY ViabilityDate DESC
      LIMIT 0,1


<page xmlns:sq2="" xmlns:jx="">
<sq2:rowset nrofrows="8" name="source-list">
  <sq2:rowset nrofrows="1" name="source-viability">


 <map:match pattern="db/list-*">
   <map:generate src="SQL/list/{1}.xml" type="jx" label="debug1">
    <map:transform type="sql" label="debug2">
     <map:parameter name="use-connection" value="foo"/>
     <map:parameter name="show-nr-of-rows" value="true"/> 
     <map:parameter name="clob-encoding" value="UTF-8"/> 
   <!--     ??? not with nested query      -->  
   <map:transform type="filter" label="debug3">
     <map:parameter name="element-name" value="row"/>
     <map:parameter name="count" value="20"/>
     <map:parameter name="blocknr" value="{request-param:bl}"/>

This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice,
and implemented Open Document Format (ODF) standard. 
The full disclaimer details can be found at

This message has been scanned for viruses and dangerous content by MailScanner, 
and is believed to be clean.  MailScanner thanks Transtec Computers for their support.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message