SunnyDay, the information you provided are too scarce... could you be more specic ? BTW, which DBMS are you using ?
P.S. Out of sheer curiosity: why don't you use your real name (I guess you have one) ? --------------------------------------------- Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html --------------------------------------------- > -----Original Message----- > From: SunnyDay [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 22, 2002 7:10 PM > To: [EMAIL PROTECTED] > Subject: Re: [C2] Bug in SQL transformer? > > > Hi, > > I had a little fight with the transformer on sunday. I tried to use a SP > and it always faild. So I inserted some debug-statements and it did not > realy looked like a SQLTransformer - Problem! > > What I did (after hourless banging my head against the wall): > > I ... > > (1) downloaded the most actual dev-distrib > (2) inserted some log-statements > (3) took the provided example 'sql-page' and inserted my SP-Call > (4) requested /cocoon/sql/sql-page => Exception > (5) requested /cocoon/sql/sql-page.source => Well, there was my data > > The Logfile showed me that the SQL stuff had finished. The Exception > came from a FileTransformer (if I remember correctly). > > That was the point where I stopped because I had some other things to do. > > Anyway, my data had empty tags around! > > I'll continue on saturday but maybe someone could verify this???? > > CuAll > Harald > > > -----Original Message----- > > From: Luca Morandini [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 22, 2002 1:09 PM > > To: [EMAIL PROTECTED] > > Subject: RE: [C2] Bug in SQL transformer? > > > > > > Grant, > > > > I'd suggest to take a look at the cocoon.log, which contains a lot of > > information about errors. > > > > Aanyway, I've used SQLTransformer after XSLT stages have been > performed (I > > generate tags embedding SP calls from stylesheets) and found no anomaly. > > > > Best regards, > > > > --------------------------------------------- > > Luca Morandini > > GIS Consultant > > [EMAIL PROTECTED] > > http://utenti.tripod.it/lmorandini/index.html > > --------------------------------------------- > > > > > > > >>-----Original Message----- > >>From: Miller, Grant [mailto:[EMAIL PROTECTED]] > >>Sent: Tuesday, January 22, 2002 1:15 PM > >>To: '[EMAIL PROTECTED]' > >>Subject: [C2] Bug in SQL transformer? > >> > >> > >>Hello, > >>I've been trying to use the SQL transformer. However, if it > comes after an > >>XSLT transformer in the pipeline it always throws an error. If I use the > >>output of the XSLT step as the hardcoded input from a generate > step (e.g. > >>file generator) then it works fine. The crash happens whether or > >>not the XML > >>input to the sql transformer contains sql transform tags. > >>The example below is the simplest case I can find to illustrate > >>the problem. > >> > >>The pipeline: > >><map:pipeline> > >> <map:match pattern="testPage"> > >> <map:generate type="serverpages" src="test.xsp"/> > >> <map:transform src="test/copy.xsl"/> > >> <map:transform type="sql"> > >> <map:parameter name="use-connection" > >>value="kpidbpool"/> > >> </map:transform> > >> <map:serialize type="xml"/> > >> </map:match> > >></map:pipeline> > >> > >>Copy xsl: > >> > >><?xml version="1.0"?> > >><xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" > >> version="1.0"> > >> > >> <xsl:template match="@*|node()" priority="-1"> > >> <xsl:copy> > >> <xsl:apply-templates select="@*|node()"/> > >> </xsl:copy> > >> </xsl:template> > >> > >></xsl:stylesheet> > >> > >>Error info: > >> > >>org.apache.cocoon.ProcessingException: Exception in > >>ServerPagesGenerator.generate(): java.lang.RuntimeException: > >>java.lang.NullPointerException > >> at > >>org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP > >>agesGenera > >>tor.java:212) > >> at > >>org.apache.cocoon.components.pipeline.CachingEventPipeline.process > >>(CachingEv > >>entPipeline.java:210) > >> at > >>org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces > >>s(CachingS > >>treamPipeline.java:359) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.wildcardMatchN400032(s > >>itemap_xma > >>p.java:528) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.process(sitemap_xmap.j > >>ava:373) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.process(sitemap_xmap.j > >>ava:331) > >> at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > >> at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > >> at > >>org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400235(sitemap_xm > >>ap.java:33 > >>94) > >> at > >>org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2620) > >> at > >>org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2511) > >> at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > >> at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > >> at org.apache.cocoon.Cocoon.process(Cocoon.java:514) > >> at > >>org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > >> at > >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A > >>pplication > >>FilterChain.java:247) > >> at > >>org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > >>onFilterCh > >>ain.java:193) > >> at > >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > >>erValve.ja > >>va:243) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardContextValve.invoke(StandardConte > >>xtValve.ja > >>va:201) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa > >>lve.java:2 > >>46) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardContext.invoke(StandardContext.ja > >>va:2344) > >> at > >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv > >>e.java:164 > >>) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat > >>cherValve. > >>java:170) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv > >>e.java:170 > >>) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve. > java:462) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > >>Valve.java > >>:163) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.connector.http.HttpProcessor.process(HttpProce > >>ssor.java: > >>1011) > >> at > >>org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor > >>.java:1106 > >>) > >> at java.lang.Thread.run(Thread.java:484) > >>java.lang.RuntimeException: java.lang.NullPointerException > >> at > >>org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.j > >>ava:3174) > >> at > >>org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(Tr > >>ansformerH > >>andlerImpl.java:433) > >> at > >>org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe. > >>java:48) > >> at > >>org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe. > >>java:48) > >> at > >>org.apache.cocoon.generation.ServerPagesGenerator.endDocument(Serv > >>erPagesGen > >>erator.java:270) > >> at > >>org.apache.cocoon.www.renderer.test.test_xsp.generate(test_xsp.java:149) > >> at > >>org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP > >>agesGenera > >>tor.java:200) > >> at > >>org.apache.cocoon.components.pipeline.CachingEventPipeline.process > >>(CachingEv > >>entPipeline.java:210) > >> at > >>org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces > >>s(CachingS > >>treamPipeline.java:359) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.wildcardMatchN400032(s > >>itemap_xma > >>p.java:528) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.process(sitemap_xmap.j > >>ava:373) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.process(sitemap_xmap.j > >>ava:331) > >> at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > >> at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > >> at > >>org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400235(sitemap_xm > >>ap.java:33 > >>94) > >> at > >>org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2620) > >> at > >>org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2511) > >> at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > >> at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > >> at org.apache.cocoon.Cocoon.process(Cocoon.java:514) > >> at > >>org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > >> at > >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A > >>pplication > >>FilterChain.java:247) > >> at > >>org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > >>onFilterCh > >>ain.java:193) > >> at > >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > >>erValve.ja > >>va:243) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardContextValve.invoke(StandardConte > >>xtValve.ja > >>va:201) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa > >>lve.java:2 > >>46) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardContext.invoke(StandardContext.ja > >>va:2344) > >> at > >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv > >>e.java:164 > >>) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat > >>cherValve. > >>java:170) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv > >>e.java:170 > >>) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve. > java:462) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > >>Valve.java > >>:163) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.connector.http.HttpProcessor.process(HttpProce > >>ssor.java: > >>1011) > >> at > >>org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor > >>.java:1106 > >>) > >> at java.lang.Thread.run(Thread.java:484) > >> > >>Original exception : java.lang.RuntimeException: > >>java.lang.NullPointerException > >> at > >>org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.j > >>ava:3174) > >> at > >>org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(Tr > >>ansformerH > >>andlerImpl.java:433) > >> at > >>org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe. > >>java:48) > >> at > >>org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe. > >>java:48) > >> at > >>org.apache.cocoon.generation.ServerPagesGenerator.endDocument(Serv > >>erPagesGen > >>erator.java:270) > >> at > >>org.apache.cocoon.www.renderer.test.test_xsp.generate(test_xsp.java:149) > >> at > >>org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP > >>agesGenera > >>tor.java:200) > >> at > >>org.apache.cocoon.components.pipeline.CachingEventPipeline.process > >>(CachingEv > >>entPipeline.java:210) > >> at > >>org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces > >>s(CachingS > >>treamPipeline.java:359) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.wildcardMatchN400032(s > >>itemap_xma > >>p.java:528) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.process(sitemap_xmap.j > >>ava:373) > >> at > >>org.apache.cocoon.www.renderer.sitemap_xmap.process(sitemap_xmap.j > >>ava:331) > >> at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > >> at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > >> at > >>org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400235(sitemap_xm > >>ap.java:33 > >>94) > >> at > >>org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2620) > >> at > >>org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2511) > >> at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > >> at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > >> at org.apache.cocoon.Cocoon.process(Cocoon.java:514) > >> at > >>org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > >> at > >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A > >>pplication > >>FilterChain.java:247) > >> at > >>org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > >>onFilterCh > >>ain.java:193) > >> at > >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > >>erValve.ja > >>va:243) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardContextValve.invoke(StandardConte > >>xtValve.ja > >>va:201) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa > >>lve.java:2 > >>46) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardContext.invoke(StandardContext.ja > >>va:2344) > >> at > >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv > >>e.java:164 > >>) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat > >>cherValve. > >>java:170) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv > >>e.java:170 > >>) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve. > java:462) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>64) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > >>Valve.java > >>:163) > >> at > >>org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > >>ine.java:5 > >>66) > >> at > >>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > >>java:472) > >> at > >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > >> at > >>org.apache.catalina.connector.http.HttpProcessor.process(HttpProce > >>ssor.java: > >>1011) > >> at > >>org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor > >>.java:1106 > >>) > >> at java.lang.Thread.run(Thread.java:484) > >> > >>Thanks for any help, > >> > >>Grant Miller > >> > >>This message may contain privileged and/or confidential > >>information. If you > >>have received this e-mail in error or are not the intended > recipient, you > >>may not use, copy, disseminate or distribute it; do not open any > >>attachments, delete it immediately from your system and notify > the sender > >>promptly by e-mail that you have done so. Thank you. > >> > >>--------------------------------------------------------------------- > >>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]> > >> > > > > > > --------------------------------------------------------------------- > > 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]> > > > > This message may contain privileged and/or confidential > information. If you > > have received this e-mail in error or are not the intended > recipient, you > > may not use, copy, disseminate or distribute it; do not open any > > attachments, delete it immediately from your system and notify > the sender > > promptly by e-mail that you have done so. Thank you. > > > > --------------------------------------------------------------------- > > 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]> > > > > > > > > --------------------------------------------------------------------- > 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]> > --------------------------------------------------------------------- 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]>