Return-Path: Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 6795 invoked from network); 30 Nov 2000 21:31:54 -0000 Received: from lafontaine.cybercable.fr (212.198.0.202) by locus.apache.org with SMTP; 30 Nov 2000 21:31:54 -0000 Received: (qmail 2683609 invoked from network); 30 Nov 2000 21:31:42 -0000 Received: from d023.dhcp212-89.cybercable.fr (HELO pikachu.levesinet.net) ([212.198.89.23]) (envelope-sender ) by lafontaine.cybercable.fr (qmail-ldap-1.03) with SMTP for ; 30 Nov 2000 21:31:41 -0000 Message-Id: <5.0.0.25.2.20001130222302.02710bf0@pop3.levesinet.net> X-Sender: laurent@pop3.levesinet.net X-Mailer: QUALCOMM Windows Eudora Version 5.0 Date: Thu, 30 Nov 2000 22:25:07 +0100 To: cocoon-users@xml.apache.org From: Laurent Subject: Re: cocoon postgresql help needed In-Reply-To: <383077495.975615661050.JavaMail.root@web575-ec.mail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N try org.postgresql.Driver instead of postgresql.Driver. and make sure your CLASSPATH contains the jdbc postgres driver file (.jar file) laurent At 15:21 30/11/00 -0500, you wrote: >Please can you help I have got the a postgresql database I would like to >access. I have managed to >get cocoon to output html when XML is requested from the browser. I have >carefully followed the example of "esql.xml" in the samples directory, but >when I try to access the database I keep getting the following message: > >"http://www.w3.org/TR/REC-html40/strict.dtd"> > > >postgresql.Driverjava.lang.ClassNotFoundException: >postgresql.Driver >at java.net.URLClassLoader$1.run(URLClassLoader.java:200) >at java.security.AccessController.doPrivileged(Native Method) >at java.net.URLClassLoader.findClass(URLClassLoader.java:188) >at java.lang.ClassLoader.loadClass(ClassLoader.java:297) >at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286) >at java.lang.ClassLoader.loadClass(ClassLoader.java:253) >at org.apache.cocoon.processor.xsp.language.java.XSPClassLoader.loadClass >(XSPClassLoader.java:87) >at java.lang.ClassLoader.loadClass(ClassLoader.java:253) >at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313) >at java.lang.Class.forName0(Native Method) >at java.lang.Class.forName(Class.java:120) >at >_home._apache._htdocs._cocoon_1_8._samples._sql._test._esql_execute_query_N63bbd7 >(_test.java:85) >at >_home._apache._htdocs._cocoon_1_8._samples._sql._test.populateDocument(_test.java:273) >at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96) >at >org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:494) >at org.apache.cocoon.Engine.handle(Engine.java:359) >at org.apache.cocoon.Cocoon.service(Cocoon.java:167) >at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) >at org.apache.jserv.JServConnection.processRequest(JServConnection.java:317) >at org.apache.jserv.JServConnection.run(JServConnection.java:188) >at java.lang.Thread.run(Thread.java:484) > > > > >Here is my XML: > > > >href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?> >language="java" >xmlns:esql="http://apache.org/cocoon/SQL/v2" >xmlns:xsp="http://www.apache.org/1999/XSP/Core" > > > > >postgresql.Driver >jdbc:postgresql://localhost/forms >mattr > >select * from groups > > >

> > > >no results were found > > >

> > > > > >(I have not set a password on my database, and have tried it without the > line) but I have a feeling that it not finding the database. >I have gone through the instalation and added the necessary lines to the >.properties files. > >Please can you tell me what I am doing wrong. > > >----------------------------------------------- >FREE! The World's Best Email Address @email.com >Reserve your name now at http://www.email.com > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org >For additional commands, e-mail: cocoon-users-help@xml.apache.org