cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Galia Angelova <galb...@yahoo.com>
Subject RE: Informix configuration
Date Wed, 18 Jun 2003 11:58:23 GMT

Thank you, David!
 
It's a good idea.
 
The problem is that i can't get a cannection with thw data base. Something with my configuration
or driver is not proper.
 
Galia
 

"Carmona Perez, David" <DPerezCar@fcc.es> wrote:


v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}.shape
{behavior:url(#default#VML);}
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:galbulg@yahoo.com]
Enviado el: martes, 17 de junio de 2003 16:44
Para: cocoon-users@xml.apache.org
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="xml/{1}.xml"/>
                        <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="xsl/style.xsl"/>
                        <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!



---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
Mime
View raw message