You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Grégory Roche <we...@polymorphisme.org> on 2011/05/12 16:21:20 UTC
Cocoon 2.2 and Mysql 5.0
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
Re: Cocoon 2.2 and Mysql 5.0
Posted by Jeroen Reijn <j....@onehippo.com>.
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 <we...@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
Re: Cocoon 2.2 and Mysql 5.0
Posted by Andre Juffer <an...@oulu.fi>.
Is possibly related to a firewall rule. The database is located on
another server?
On 12/05/11 17:21, Grégory Roche wrote:
>
> 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
>
--
Andre H. Juffer | Phone: +358-8-553 1161
Biocenter Oulu and | Fax: +358-8-553-1141
Department of Biochemistry | Email: andre.juffer@oulu.fi
University of Oulu, Finland | WWW: www.biochem.oulu.fi/Biocomputing/
StrucBioCat | WWW: www.strucbiocat.oulu.fi
Triacle Biocomputing | WWW: www.triacle-bc.com