RE: Informix configuration

[Carmona Perez, David]

I have successfully used Cocoon with Informix, but I use other methods of connecting to the database, I do it through Java code.  Here is an excerpt of my pipeline:         <map:components>       <map:transformers default="xslt">                   <map:transformer name="sql" src="">"org.apache.cocoon.transformation.SQLTransformer"/>       </map:transformers>       </map:components>       <map:pipelines>             <map:transform type="sql" label="transf1">                   <map:parameter name="dburl" value="{session:databaseUrl}"/>             </map:transform>       </map:pipelines>   Through an input module and JXDom, I access a function call getUrl() that returns a string that contains the URL to the database connection, of the following type:   jdbc:informix-sqli://server:1526/database:INFORMIXSERVER=server;user=myuser;password=mypassword   I do so, because each user session may have a connection to a different database.   -------- David   -----Mensaje original----- De: Galia Angelova [mailto:[EMAIL PROTECTED] Enviado el: martes, 17 de junio de 2003 16:44 Para: [EMAIL PROTECTED] Asunto: Informix configuration   Hi! Does anybody know how to configure cocoon in order to work with Informix? Ihe informix data base is on a remote PC- "profisrv",Informix server name - "ol_profisrv", database name "eisppbase" I've done the folowing configuration:       in cocoon.xconf:     <datasources>     <jdbc name="eispp">       <pool-controller min="5" max="10"/>       <dburl>jdbc:informix-sqli://profisrv:1526/eisppbase:INFORMIXSERVER=ol_profisrv</dburl>       <user>usr</user>       <password/>       <DBDATE>DMY4/<DBDATE>     </jdbc>   </datasources>   in web.xml:   <init-param>   <param-name>load-class</param-name>   <param-value>  com.informix.jdbcx.IfxConnectionPoolDataSource   </param-value> </init-param>   page.xml:   <page xmlns:sql="http://apache.org/cocoon/SQL/2.0">     <title>My App page</title>     <content>         <para>Just a static contents</para>         <execute-query xmlns="http://apache.org/cocoon/SQL/2.0">           <query>           select title from sm_State where ID_State='12'           <!-- here comes the SQL statement or stored procedure -->           </query>         </execute-query>          </content> </page> sitemap.xmap:                 <map:match pattern="*.xml">                         <map:generate src="">                         <map:transform type="sql">                                <map:parameter name="use-connection" value="eispp"/>                                <map:parameter name="show-nr-of-rows" value="true"/>                           </map:transform>                         <map:transform src="">                         <map:serialize/>                 </map:match>              After running the application I get this message:     My App page Just a static contents Failed to obtain connection. Made 5 attempts with 5000ms interval     Is there something that I've missed? Thank you in advance!   Galia Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!