Return-Path: 
 <cocoon-users-return-34251-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 93787 invoked by uid 500); 29 May 2002 21:48:06 -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 93776 invoked from network); 29 May 2002 21:48:05 -0000
Reply-To: <bloritsch@apache.org>
From: "Berin Loritsch" <bloritsch@apache.org>
To: <cocoon-users@xml.apache.org>, <dan@drob.org>
Subject: RE: hsqldb - how do I get rid of this error message (and turn off
  hsqldb)
Date: Wed, 29 May 2002 17:47:59 -0400
Message-ID: <007e01c2075a$8083d650$ac00a8c0@Gabriel>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
In-Reply-To: <3CF54B6D.F6275BF6@dnai.com>
Importance: Normal
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

> From: daniel robinson [mailto:drob@dnai.com]=20
>=20
> Ok,
>=20
> I commented out the hsqldb stuff and this error has gone away=20
> - but I can't get PostgreSQL to work correctly.
>=20
> I've created the sample DB and modified cocoon.xconf:
>=20
>   <datasources>
>     <jdbc name=3D"personnel">
>       <pool-controller min=3D"5" max=3D"10"/>
>       <auto-commit>true</auto-commit>
>       <dburl>jdbc:postgresql:testdb</dburl>
>       <user>unknown</user>
>       <password></password>
>     </jdbc>
>   </datasources>
>=20
> and Web.xml contains:
>=20
>  <init-param>
>       <param-name>load-class</param-name>
>       <param-value>
>         org.postgresql.Driver
>       </param-value>
>     </init-param>
>=20
> and pgjdbc1.jar (containing org.postresql.Driver) is in=20
> Tomcat/common/lib and I have created the sample tables in=20
> testdb within PostgreSQL.

What you have *should* work, however there are a couple of things
to try.

* Add a <driver>org.postgresql.Driver</driver> element into your <jdbc/>
config (under the <dburl/> element is good).

* Move the library to ${webapp}/WEB-INF/libs

When you look at the logs, what do you see (usually you will see a
stacktrace
as to why something in the load-class initial parameter did not get
loaded).


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

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