cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeroen Reijn <j.re...@onehippo.com>
Subject Re: Cocoon 2.2 and Mysql 5.0
Date Tue, 17 May 2011 20:02:21 GMT
Hi,

have you tried to connect with a mysql client from you local machine
to the mysql server?

It seems to me a connection related problem.

Cheers,

Jeroen

2011/5/12 Grégory Roche <webmaster@polymorphisme.org>:
>  Hi,
>
> after the mail, I'm trying to do a test with a database Mysql 5.0 and a
> block of Cocoon 2.2. At this moment, it's a catastrophe, my browser return :
>
> http://locahost:8888/test/sql-page
>
> "Hello This is my first Cocoon2 page filled with SQL data!  Failed to obtain
> connection from datasource 'dbMySQL5'. Made 5 attempts with 5000ms interval"
>
> Mysql server is ok, and I have create my database with phpMyAdmin.
>
> For my Cocoon, I have :
>
> -- in the file META-INF/cocoon/spring/datasource.xml :
>
>     <bean
> name="org.apache.avalon.excalibur.datasource.DataSourceComponent/dbMySQL5"
>
> class="org.apache.cocoon.databases.bridge.spring.avalon.SpringToAvalonDataSourceWrapper">
>         <property name="wrappedBean">
>             <bean
> class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
>               <property name="driverClassName"
> value="com.mysql.jdbc.Driver"/>
>               <property name="url"
> value="jdbc:mysql://188.165.XX.XX:3306/db?autoReconnect=true"/>
>               <property name="username" value="XXX"/>
>               <property name="password" value="XXX"/>
>             </bean>
>         </property>
>     </bean>
>
> -- In my sitemap.xmap, I have my SQLTransformer and the pipeline for my
> sql-page.xml :
>
>   <map:transformer logger="sitemap.transformer.sql"
>       name="sql" src="org.apache.cocoon.transformation.SQLTransformer"/>
>
>     <map:match pattern="*">
>         <map:generate src="xdocs/{1}.xml" />
>         <map:transform type="sql">
>           <map:parameter name="use-connection" value="dbMySQL5" />
>         </map:transform>
>         <map:transform src="stylesheets/sql2html.xsl" />
>         <map:transform type="servletLinkRewriter" />
>         <map:serialize type="html" />
>       </map:match>
>
> -- My file sql-page.xml is very simple, it contains just one request SQL :
>
> <page>
>   <title>Hello</title>
>
>   <content>
>     <para>This is my first Cocoon2 page filled with SQL data!</para>
>
>     <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
>       <sql:query>
>         select id, name, description from department
>       </sql:query>
>     </sql:execute-query>
>   </content>
> </page>
>
> Have you an idea ? Thanks.
>
> Grégory Roche
>
> www.polymorphisme.com
> webmaster@polymorphisme.org
> fixe : +33 (0)5.24.07.64.02
> port : +33 (0)6.89.54.14.84

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message