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