Try a small Java program that doesn’t
use Cocoon, that connects to Informix
--------
David
-----Mensaje
original-----
De: Galia Angelova
[mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 18 de junio
de 2003 13:58
Para: [EMAIL PROTECTED]
Asunto: RE: Informix configuration
<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!
Do you Yahoo!?
SBC Yahoo! DSL - Now
only $29.95 per month!
