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