Hi,
I have a problem with SQL transformer and XSL copy-of tag.
I already read something similar in the mail archive but I didn't understand
if the problem has a solution.
I set up a simple test case for the problem, this is the recipe:
you need an xml source file (copy.xml) like this:
---------------------
<myQuery>
select * from actor
</myQuery>
------------------------
and an xsl file (copy.xsl):
---------------------------------------------------
<xsl:template match="myQuery">
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
<xsl:copy-of select="."/>
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
<query isstoredprocedure="false">
<xsl:value-of select="."/>
</query>
</execute-query>
</page>
</xsl:template>
</xsl:stylesheet>
--------------------------------------------------
and the match element in sitemap.xmap:
---------------------------------------------------
<map:match pattern="copy">
<map:generate src="<path-to-copy>/copy.xml"/>
<map:transform src="<path-to-copy>/copy.xsl"/>
<map:transform type="sql">
<map:parameter name="use-connection" value="personnel"/>
</map:transform>
<map:serialize type="xml"/>
</map:match>
---------------------------------------------------
Of course you need also the correct configuration for the datasource and a
table actor on your db.
Now,
if I access the cocoon/copy url on my system
(w2k+tomcat3.3+cocoon2.0.1+mysql) I get a very long exception (you can find
it below).
If I comment out the sql transformer step in sitemap I get in the browser a
correct xml document.
If I comment out the copy-of tag in the xsl, cocoon returns me the correct
query result.
So, seems that the problem is in the some strange conflict between
copy-of/sqlt...
Can someone confirm my supposition?
Is this problem solved? (If yes sorry for the time wasted!)
Thanks,
Vittorio
----------------------------------------------------------------------------
----
Original exception : java.lang.RuntimeException:
java.lang.NullPointerException
at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1111)
at org.apache.cocoon.components.parser.JaxpParser.parse(JaxpParser.java:182)
at org.apache.cocoon.components.source.URLSource.toSAX(URLSource.java:331)
at
org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:109)
at
org.apache.cocoon.components.pipeline.AbstractEventPipeline.process(Abstract
EventPipeline.java:118)
at
org.apache.cocoon.components.pipeline.AbstractStreamPipeline.process(Abstrac
tStreamPipeline.java:149)
at org.apache.cocoon.www.sitemap_xmap.matchN104AD(sitemap_xmap.java:6282)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:3019)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2444)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:180)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:144)
at org.apache.cocoon.Cocoon.process(Cocoon.java:582)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:797)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source)
at org.apache.tomcat.core.Handler.invoke(Unknown Source)
at org.apache.tomcat.core.Handler.service(Unknown Source)
at org.apache.tomcat.facade.ServletHandler.service(Unknown Source)
at org.apache.tomcat.core.ContextManager.internalService(Unknown Source)
at org.apache.tomcat.core.ContextManager.service(Unknown Source)
at
org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Unknown
Source)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:484)
Original exception : java.lang.RuntimeException:
java.lang.NullPointerException
at
org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.java:3174)
at
org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(TransformerH
andlerImpl.java:433)
at
org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe.java:49)
at org.apache.xerces.parsers.SAXParser.endDocument(SAXParser.java:1230)
at
org.apache.xerces.validators.common.XMLValidator.callEndDocument(XMLValidato
r.java:1146)
at
org.apache.xerces.framework.XMLDocumentScanner$EndOfInputDispatcher.dispatch
(XMLDocumentScanner.java:1499)
at
org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.
java:381)
at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098)
at org.apache.cocoon.components.parser.JaxpParser.parse(JaxpParser.java:182)
at org.apache.cocoon.components.source.URLSource.toSAX(URLSource.java:331)
at
org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:109)
at
org.apache.cocoon.components.pipeline.AbstractEventPipeline.process(Abstract
EventPipeline.java:118)
at
org.apache.cocoon.components.pipeline.AbstractStreamPipeline.process(Abstrac
tStreamPipeline.java:149)
at org.apache.cocoon.www.sitemap_xmap.matchN104AD(sitemap_xmap.java:6282)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:3019)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2444)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:180)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:144)
at org.apache.cocoon.Cocoon.process(Cocoon.java:582)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:797)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source)
at org.apache.tomcat.core.Handler.invoke(Unknown Source)
at org.apache.tomcat.core.Handler.service(Unknown Source)
at org.apache.tomcat.facade.ServletHandler.service(Unknown Source)
at org.apache.tomcat.core.ContextManager.internalService(Unknown Source)
at org.apache.tomcat.core.ContextManager.service(Unknown Source)
at
org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Unknown
Source)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:484)
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
