Hello,
the database Mysql is on a server and the problem is not his firewall (the port 3306 is open) ! Grégory Roche www.polymorphisme.com webmas...@polymorphisme.org fixe : +33 (0)5.24.07.64.02 port : +33 (0)6.89.54.14.84Andre Juffer <andre.juf...@oulu.fi> a écrit : > 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 >> webmas...@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.juf...@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 > >