Lajos Thanks for the suggestions. In response:
1. Where do I find the mysql_comp.jar you refer to (I do not have it on my Windows test machine) and a quick scan at the mysql site did not reveal anything either... all I have is the mm.mysql driver (as seen below) which is in the Java lib. 2. I cannot run the supplied esql examples as they depend on having the postgresql database installed... <esql:driver>org.postgresql.Driver</esql:driver> <esql:dburl>jdbc:postgresql://localhost/test</esql:dburl> <esql:username>test</esql:username> <esql:password>test</esql:password> Thanks Derek >>> [EMAIL PROTECTED] 17/10/2001 05:11:43 >>> Derek: I assume that the MySQL jar is in the classpath? Depending on the version of Tomcat you're running, you'll want mysql_comp.jar in either $TOMCAT_HOME/lib or $TOMCAT_HOME/common/lib. Another idea is to run one of the supplied esql examples just to make sure that the taglib is working correctly. Lajos Derek Hohls wrote: > I have a Cocoon system which fine on a setup under Win2000 as a localhost >(Apache/Tomcat); but when I upload it to our UNIX server, also running Apache/Tomcat >(which has just been setup to handle Cocoon - so we are still in 'testing' mode) - >the app just hangs... > > The XML page is given below (altho' I do not think it is a syntax problem) - the >MySQL part works OK if I logon to the server and run tests from the command line >interface... Cocoon also handles normal XML pages fine, and the cocoon.properties >file include the esql taglib. > > Any ideas as to where the 'hangup' might be or what part of the system I should look >at it to try and see where it is getting to? My UNIX knowledge is very very basic >(at best). > > All help much appreciated! > > Derek > > ***** > > <?xml version="1.0"?> > > <?cocoon-process type="xsp"?> > <?cocoon-process type="xslt"?> > <?xml-stylesheet type="text/xsl" href="one_computer.xsl"?> > > <xsp:page > xmlns:xsp="http://www.apache.org/1999/XSP/Core"; > xmlns:esql="http://apache.org/cocoon/SQL/v2"; > xmlns:request="http://www.apache.org/1999/XSP/Request"; > > > <page> > > <esql:connection> > <esql:driver>org.gjt.mm.mysql.Driver</esql:driver> > <esql:dburl>jdbc:mysql://myhost.com/est</esql:dburl> > <esql:username>est</esql:username> > <esql:password>est</esql:password> > > <esql:execute-query> > <esql:query>SELECT * FROM computer</esql:query> > <esql:results> > <esql:row-results> > <computer> > <system><esql:get-string column="System"/></system> > </computer> > </esql:row-results> > </esql:results> > </esql:execute-query> > > </esql:connection> > > </page> > > </xsp:page> > > > --------------------------------------------------------------------- > 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: <[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/faqs.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/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
