cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From e nio <enio...@yahoo.com>
Subject Re: AW: SQLTransformer?
Date Wed, 07 May 2003 18:09:05 GMT
      Isn't he missing the <jdbc name="personnel"> in
cocoon.xconf or he just did not type that in?

enio
--- Andreas Schilling <aschilling@s-und-n.de> wrote:
> John,
> 
> I recently had a similar problem with a connection to a MySQL
> Database.
> The problem was that the Jdbc3Connection.class was missing in
> the
> excalibur-datasource.jar in WEB-INF/lib.
> I got it working by replacing the jar with the current one
> from the
> Jakarta-Homepage.
> 
> regards,
> Andreas
> 
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: John Bresnik [mailto:jbresnik@auditintegrity.com]
> Gesendet: Dienstag, 6. Mai 2003 20:54
> An: cocoon-users@xml.apache.org
> Betreff: SQLTransformer?
> 
> 
> Is anyone using this to query an SQL DB? I am having a few
> problems getting
> it to work - thanks.
> 
> IN cocoon.xconf:
> 
>      
> <driver>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver>
> 
>
<dburl>jdbc:microsoft:sqlserver://192.168.0.100:1433;DatabaseName=ai_load_de
> v_1</dburl>
>       <user>sa</user>
>       <password>omitted</password>
> 
> 
> IN sitemap.xconf
> 
>     <map:match pattern="dbTest.xml">
>       <map:generate src="testing/dbTest.xml"/>
>        <map:transform type="sql">
>      <map:parameter name="use-connection" value="personnel"/>
>      <map:parameter name="show-nr-of-rows" value="true"/>
>        </map:transform>
>     <map:serialize type="xml"/>
>    </map:match>
> 
> 
> 
> ACTUAL xml that I am calling:
> 
>       <page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
> 
>        <title>Hello</title>
>        <content>
>         <para>This is my first Cocoon page filled with sql
> data!</para>
> 
>         <execute-query
> xmlns="http://apache.org/cocoon/SQL/2.0">
>          <query name="department">
>   select top 2 company_id, company_legal_name, id_cik_number,
> id_multex_internal from company
> 
>          </query>
>         </execute-query>
>        </content>
>       </page>
> 
> 
> Error:
> 
> <error>Failed to obtain connection. Made 5 attempts with
> 5000ms
> interval</error>
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail:
> cocoon-users-help@xml.apache.org
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail:
> cocoon-users-help@xml.apache.org
> 


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message