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
>
>

Reply via email to