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]>