richard,
once again my advice: take a look at the logs (here access.log):
DEBUG (2003-02-03) 13:18.51:614 [access]
(/cocoon/soundpool/database.html)
HttpProcessor[8080][4]/AbstractEnvironment: Reset context to
file:/C:/tomcat/webapps/cocoon/
WARN (2003-02-03) 13:18.51:614 [access]
(/cocoon/soundpool/database.html) HttpProcessor[8080][4]/CocoonServlet: The
resource was not found
org.apache.cocoon.ResourceNotFoundException: Resource not found
file:/C:/tomcat/webapps/cocoon/soundpool/database.xml:
java.io.FileNotFoundException:
C:\tomcat\webapps\cocoon\soundpool\database.xml (The system cannot find the
path specified)
at
org.apache.cocoon.components.source.FileSource.getInputStream(FileSource.jav
a:145)
at
org.apache.cocoon.components.source.AbstractStreamSource.getInputSource(Abst
ractStreamSource.java:161)
at
org.apache.cocoon.components.source.AbstractStreamSource.toSAX(AbstractStrea
mSource.java:206)
at
org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:143)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:250)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:395)
...
> -----Ursprungliche Nachricht-----
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]Im
> Auftrag von Richard Cunliffe
> Gesendet: Montag, 3. Februar 2003 15:29
> An: [EMAIL PROTECTED]
> Betreff: RE: Cocoon and MySQL
>
>
> Martin,
>
> I have made your suggested changes and the web page still comes up
> completely blank. Is there anything else I should be looking at?
>
> Thanks,
>
> Richard.
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 03 February 2003 14:02
> To: [EMAIL PROTECTED]
> Subject: Re: Cocoon and MySQL
>
> Hello Richard,
>
>
> "Richard Cunliffe" <[EMAIL PROTECTED]> writes:
>
> > (logs attached)
> >
> > Hi,
> >
> > I have now got cocoon to start, and I have now put my pipeline in, but
> > the page is coming up blank, when viewed through IE6.
> >
> > My pipeline in the sitemap looks like this:
> >
> >
> > <!-- soundpool Database (SQL) -->
> >
> > <map:pipeline>
> > <map:match pattern="soundpool/database.html">
> > <map:generate src="soundpool/database.xml"/>
> > <map:transform type="sql">
> > <map:parameter name="RICHARD"
> > value="soundpool"/>
> > </map:transform>
> > <map:transform src="databasepc.xsl"/>
> Do one step after the other -- disable the transformer
> for testing or use labels.
>
> > <map:serialize/>
> > </map:match>
> > </map:pipeline>
> >
> >
> >
> > I am unsure what should go under name="". I have assumed it's the
> local
> > host name given in mysql?
>
> No, it is the name of the connection as defined in your cocoon.xconf.
> My entry looks like this:
>
> <!-- Datasources: -->
> <datasources>
> <jdbc name="slide" logger="vsc.sql" >
> <pool-controller min="2" max="6" />
> <auto-commit>true</auto-commit>
> <dburl>jdbc:postgresql://bog.fiz-chemie.de/slidestore</dburl>
> <user>slide</user>
> <password>geheim</password>
> </jdbc>
> </datasources>
>
> So the parameter to the SQL Transformer is:
> <map:transform type="sql">
> <map:parameter name="use-connection" value="slide"/>
> </map:transform>
> Remember to restart your servlet engine after changes to cocoon.xconf.
>
> >
> > My web.xml looks like so:
> Looks okay.
>
> >
> > My database.xml looks like this:
> >
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <document>
> > <text>soundpool</text>
> > <title>the databse</title>
> > <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
>
> > <sql:use-connection>localhost/soundpool</sql:use-connection>
> You don't need this line.
>
> > <sql:query>
> > SELECT generalMusicTitle FROM album
> > </sql:query>
> > </sql:execute-query>
> > </document>
>
>
> --
> Martin Holz FIZ CHEMIE Berlin
> <[EMAIL PROTECTED]>
>
>
>
> ---------------------------------------------------------------------
> 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: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
>
>
> ---------------------------------------------------------------------
> 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: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
