You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Martin Grote <gr...@pb.izm.fhg.de> on 2001/04/10 11:13:51 UTC

SQL example 

Hello!

We are planning to use Cocoon as a Html generator for an XML/XSL-based web
management system. Especially the ESQL interface of Cocoon is very interesting
for us, because we would like to set up generic XML pages that actually get
their data from an SQL database.

There was only very small documentation, so i have tried the SQL example from
the cocoon samples directory (esql.xml). Unfortunately it always results in the
following error message:


Error found handling the request.

      java.lang.RuntimeException: Error loading driver: org.postgresql.Driver
              at java.lang.Throwable.fillInStackTrace(Native Method)
              at ...
              at java.lang.RuntimeException.<init>(Compiled Code)
              at _globals._groups._train._jakarta_tomcat_3_2_1._webapps.
                   _cocoon._samples._sql._esql.populateDocument(Compiled Code)
              at org.apache.cocoon.processor.xsp.XSPPage.getDocument(Compiled
Code)
              at ...
              at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(Compiled
Code)
              at java.lang.Thread.run(Thread.java:479)


I am using Cocoon 1.8.2 on a Tomcat Webserver V3.2.1 under Solaris 8 (Unix). 

I have been looking at the XML source, but since i am no SQL expert i was not
able to determine the exact problem. Especially this question is not clear to
me: what is the esql.xml example trying to do? - does it try to establish an
internet connection to org.postgresql.Driver, where there is some kind of
database already, or do i have to first install the postgresql database system
on my machine, fill it with some data and try the esql.xml example again, then?
- please tell me how i can get it to work.

Thanks very much!


Martin Grote
--
grote@pb.izm.fhg.de			http://www.pb.izm.fhg.de/~grote/		
IZM Fraunhofer Gesellschaft                    Tel.:  0 52 51 / 5402-132
Technologiepark 34, 33100 Paderborn, Germany   Fax:   0 52 51 / 5402-105

Re: SQL example

Posted by Arnaud Vandyck <ar...@ressource-toi.org>.
Donald Ball wrote:
> 
> On Tue, 10 Apr 2001, Martin Grote wrote:
> 
> > We are planning to use Cocoon as a Html generator for an XML/XSL-based web
> > management system. Especially the ESQL interface of Cocoon is very interesting
> > for us, because we would like to set up generic XML pages that actually get
> > their data from an SQL database.
> >
> > There was only very small documentation, so i have tried the SQL
> > example from the cocoon samples directory (esql.xml). Unfortunately it
> > always results in the following error message:
> >
> >
> > Error found handling the request.
> >
> >       java.lang.RuntimeException: Error loading driver: org.postgresql.Driver
> 
> add the postgresql jdbc driver to your classpath.

Note that (on older versions of the driver) the class may be called
postgresql.Driver

--
Arnaud Vandyck <http://www.ressource-toi.org/>
"... les liégeois sont sympas"
- Ali Lukunku, La Gazette des Sports, mar. 10/04/2001, p. 5TG

---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>

Re: SQL example

Posted by Donald Ball <ba...@webslingerZ.com>.
On Tue, 10 Apr 2001, Martin Grote wrote:

> We are planning to use Cocoon as a Html generator for an XML/XSL-based web
> management system. Especially the ESQL interface of Cocoon is very interesting
> for us, because we would like to set up generic XML pages that actually get
> their data from an SQL database.
>
> There was only very small documentation, so i have tried the SQL
> example from the cocoon samples directory (esql.xml). Unfortunately it
> always results in the following error message:
>
>
> Error found handling the request.
>
>       java.lang.RuntimeException: Error loading driver: org.postgresql.Driver

add the postgresql jdbc driver to your classpath.

- donald


---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>