You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Ferran Urgell <ur...@yahoo.com> on 2001/11/08 11:28:47 UTC
RE: Trying to connect mysql to cocoon2 (more)
I'm trying to get somtehing via Mysql and not works....
This is my sitemap....
<map:match pattern="sql/prova">
<map:generate src="docs/samples/sql/sql.xml"/>
<map:transform type="sql">
<map:parameter name="use-connection" value="test"/>
</map:transform>
<map:transform src="stylesheets/sim.xsl"/>
<map:serialize/>
</map:match>
sql.xml
<?xml version="1.0"?>
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
<title>Hello</title>
<content>
<para>This is my first Cocoon2 page filled with sql data!</para>
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
<query>
select id,name from department_table
</query>
</execute-query>
</content>
</page>
sim.xsl
<?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">
<xsl:import href="page/simple-page2html.xsl"/>
<xsl:output method="html" encoding="UTF-8"/>
<xsl:template match="/">
<html>
<xsl:apply-templates/>
<h1>gogogog</h1>
</hmtl>
</xsl:template>
</xsl:stylesheet>
and not works......
org.apache.cocoon.ProcessingException: Failed to execute pipeline.: java.lang.RuntimeException: Problem in getTransformer:Error in creating Transform Handler
org.apache.cocoon.ProcessingException: Failed to execute pipeline.: java.lang.RuntimeException: Problem in getTransformer:Error in creating Transform Handler at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:379) at org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400452(sitemap_xmap.java:5861) at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2579) at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2181) at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:116) at org.apache.cocoon.Cocoon.process(Cocoon.java:495) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:534) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
---------------------------------
Do You Yahoo!?
Find a job, post your resume on Yahoo! Careers.
RE: Trying to connect mysql to cocoon2 (more)
Posted by Ferran Urgell <ur...@yahoo.com>.
I'm recieving this error in cocoon.log
EBUG (2001-11-09) 06:33.34:912 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][3]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:913 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][8]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:913 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][7]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:914 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][5]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:915 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][9]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:916 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][4]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:916 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][0]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:916 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][6]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:917 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][2]/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 0 ms to try again.
DEBUG (2001-11-09) 06:33.34:918 [cocoon ] (/cocoon/sql/sql-page) HttpProcessor[8080][1]/SQLTransform
---------------------------------
Do You Yahoo!?
Find a job, post your resume on Yahoo! Careers.
RE: Trying to connect mysql to cocoon2 (more)
Posted by David Rosenstrauch <da...@dti.net>.
I think you need to check the cocoon.log file, cause it doesn't look like the cause of the error is getting written to the screen. (FYI - it sounded from someone's post yesterday like cocoon 2 rc2 fixes that issue, i.e., writes the entire exception chain to the screen.)
DR
At 02:28 AM 11/8/01 -0800, you wrote:
>I'm trying to get somtehing via Mysql and not works....
>
>This is my sitemap....
>
><map:match pattern="sql/prova">
> <map:generate src="docs/samples/sql/sql.xml"/>
> <map:transform type="sql">
> <map:parameter name="use-connection" value="test"/>
> </map:transform>
> <map:transform src="stylesheets/sim.xsl"/>
> <map:serialize/>
> </map:match>
>
>sql.xml
>
><?xml version="1.0"?>
>
><page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
>
> <title>Hello</title>
> <content>
> <para>This is my first Cocoon2 page filled with sql data!</para>
>
> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
> <query>
> select id,name from department_table
> </query>
> </execute-query>
>
> </content>
></page>
>
>sim.xsl
>
><?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">
> <xsl:import href="page/simple-page2html.xsl"/>
><xsl:output method="html" encoding="UTF-8"/>
> <xsl:template match="/">
> <html>
> <xsl:apply-templates/>
> <h1>gogogog</h1>
></hmtl>
> </xsl:template>
>
></xsl:stylesheet>
>
>and not works......
>
>
>org.apache.cocoon.ProcessingException: Failed to execute pipeline.: java.lang.RuntimeException: Problem in getTransformer:Error in creating Transform Handler
>
>org.apache.cocoon.ProcessingException: Failed to execute pipeline.: java.lang.RuntimeException: Problem in getTransformer:Error in creating Transform Handler
> at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:379)
> at org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400452(sitemap_xmap.java:5861)
> at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2579)
> at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2181)
> at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
> at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:116)
> at org.apache.cocoon.Cocoon.process(Cocoon.java:495)
> at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:534)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
> at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
> at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
> at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
> at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
>
>
>Do You Yahoo!?
>Find a job, post your resume on <http://careers.yahoo.com/?clink=foot-fp>Yahoo! Careers.
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>