Return-Path: 
 <cocoon-users-return-37887-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 50042 invoked by uid 500); 8 Aug 2002 12:16:31 -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 50018 invoked from network); 8 Aug 2002 12:16:29 -0000
From: "Leigh Dodds" <ldodds@ingenta.com>
To: <cocoon-users@xml.apache.org>
Subject: RE: Yet another  No suitable driver error
Date: Thu, 8 Aug 2002 13:14:47 +0100
Message-ID: <NCBBKFMJCLIMOBIGKFMJOEADIAAA.ldodds@ingenta.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
In-Reply-To: <49642.192.168.192.18.1028808911.squirrel@www.correo.sedifa.com>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Importance: Normal
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

See this page, and let me know if its of any use:

http://outerthought.net/wiki/Wiki.jsp?page=ConnectionPooling

To be honest, I've generally placed things under the Tomcat 
or Cocoon lib directory.

Cheers,

L.

> -----Original Message-----
> From: Albert Cervera Areny [mailto:informatic@sedifa.com]
> Sent: 08 August 2002 13:15
> To: cocoon-users@xml.apache.org
> Subject: Yet another No suitable driver error
> 
> 
> 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>
>   </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>
> 

---------------------------------------------------------------------
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>