You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by John Bresnik <jb...@auditintegrity.com> on 2003/05/06 20:53:56 UTC
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
RE: SQLTransformer?
Posted by Askild Aaberg Olsen <as...@xangeli.com>.
John Bresnik wrote:
> Is anyone using this to query an SQL DB? I am having a few problems
getting it to work - thanks.
Have you read http://wiki.cocoondev.org/Wiki.jsp?page=MsSQL ?
I set up the SQLTransformer with MS SQL by following this How-To, and I'm
still using it.
Askild Aaberg Olsen
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: AW: SQLTransformer?
Posted by John Bresnik <jb...@auditintegrity.com>.
Yea the <jdbc> tag is there. I tried replacing the JARs / reading the doc
but still haven't had any luck in getting it to work. any other ideas?
thanks
----- Original Message -----
From: "e nio" <en...@yahoo.com>
To: <co...@xml.apache.org>; <as...@s-und-n.de>
Sent: Wednesday, May 07, 2003 11:09 AM
Subject: Re: AW: SQLTransformer?
> Isn't he missing the <jdbc name="personnel"> in
> cocoon.xconf or he just did not type that in?
>
> enio
> --- Andreas Schilling <as...@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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: AW: SQLTransformer?
Posted by e nio <en...@yahoo.com>.
Isn't he missing the <jdbc name="personnel"> in
cocoon.xconf or he just did not type that in?
enio
--- Andreas Schilling <as...@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
AW: SQLTransformer?
Posted by Andreas Schilling <as...@s-und-n.de>.
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