I tried to access a Oracle database with SQL transformer. Then, I modified cocoon.xconf
<jdbc logger="core.datasources.hub_annuaire" name="hub_annuaire"> <pool-controller min="1" max="2" keep-alive="true"/> <dburl>jdbc:oracle:thin:@****:1521:HUB0</dburl> <user>****</user> <password>***</password> </jdbc> I have add a .xml file with <?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 field1 from myTable </query> </execute-query> </content> </page> I verified if data exist in my database, but the result gives: <page> <title>Hello</title> <content> <para>This is my first Cocoon2 page filled with sql data!</para> <sql:rowset xmlns:sql="http://apache.org/cocoon/SQL/2.0"> <sql:row> <sql:field1/> </sql:row> </sql:rowset> </content> </page> How avoid this problem ? And add value in <sql:field1/> ? Thank you Didier Rano Serv'N Data --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>