Return-Path: 
 <cocoon-users-return-37951-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 34771 invoked by uid 500); 9 Aug 2002 10:29:39 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 34760 invoked from network); 9 Aug 2002 10:29:38 -0000
Message-ID: <52035.192.168.192.18.1028889316.squirrel@www.correo.sedifa.com>
Date: Fri, 9 Aug 2002 12:35:16 +0200 (CEST)
Subject: Re: Yet another No suitable driver error
From: "Albert Cervera Areny" <informatic@sedifa.com>
To: <cocoon-users@xml.apache.org>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
X-Mailer: SquirrelMail (version 1.2.7)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Thanks! It worked without problems!

But of  course I couldn't wait until having another problem ;-)
The thing is that I'm trying to make this work:

sitemap.xmap:

<map:generate src="docs/usuaris.xml"/>
<map:transform src="stylesheets/usuaris.xsl">
    <map:parameter name="use-request-parameters" value="true"/>
</map:transform>
<map:transform type="sql">
    <map:parameter name="use-connection" value="cocoon"/>
</map:transform>
<map:transform src="stylesheets/usuaris.xsl"/>
<map:serialize type="xml"/>

While debugging I commented the last transform and data arrives as I expect.
In fact, I save the xml generated file with the browser and process it
with xalan using the usuaris.xsl and it works! But if I use this transform
in the sitemap I get all the fields returned but without any XML tags. (It
should return as xalan all the authentication XML structure)

Yes I know I'm using the same stylesheet twice but its for an
authentication process and It should work :-)

The strange thing is that last step <map:transform
src="stylesheets/usuaris.xsl"/>. Any clue?

Thanks, once again!

PS: I believe, after so many problems, some day I will be able to answer
all the questions in this list ;-) May be a new Trivial Pursuit about
cocoon? That


On Thursday 08 August 2002 14:33, Vadim Gritsenko wrote:
> > From: Albert Cervera Areny [mailto:informatic@sedifa.com]
> >
> > I get the following error while trying to connect to a postgresql
>
> database
>
> > throw the SQLTransformer:
> >
> > java.sql.SQLException: No suitable driver
> >
> > I've seen in the list archives that it's been reported various times
>
> but
>
> > none of the solutions seems to correct my problem.
> >
> > web.xml:
> >
> >   <init-param>
> >     <param-name>load-class</param-name>
> >     <param-value>
> >       org.postgresql.Driver
> >     </param-value>
> >   </init-param>
> >   <init-param>
> >     <param-name>extra-classpath</param-name>
> >     <param-value>/usr/share/java/postgresql.jar</param-value>
>
> AFAIR, this will not work and has different purpose.
>
> Please jar under WEB-INF/lib.
>
> Vadim
>
>    </init-param>
>
> > cocoon.xconf:
> >
> > <datasources>
> >      <jdbc logger="core.datasources.postgres" name="cocoon">
> >             <pool-controller max="10" min="5"/>
> >             <driver>org.postgresql.Driver</driver>
> >             <dburl>jdbc:postgresql://localhost/cocoon:5432</dburl>
> >             <user>cocoon</user>
> >             <password>password</password>
> >      </jdbc>
> > </datasources>
> >
> > I don't know if org.postgresql.Driver is necessari in both files but I
> > started I've tried it in just one of them and doesn't work neighter.
> > Of course access to the database is enabled correctly, the port is
>
> 5432 as
>
> > NMAP says ;) and I can connect from psql. All connection data seems to
>
> be
>
> > correct... Any other ideas??
> >
> >
> > Thanks!
> >
> > Albert Cervera Areny
>
> ---------------------------------------------------------------------
> Please check that your question  has not already been answered in the
> FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>

-- 
Albert Cervera Areny
Dept. Inform�tica Sedifa, S.L.




---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

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