Hello Derek - I had a similar problem once when I moved an application to Linux - and tried to run it before all the appropriate jars were in place. Then after putting the jars in the lib - the app still failed. I finally realized the problem was that tomcat had generated code for the xsp pages the first time I tried to run the app - and did not regenerate after I added the jars.
The generated code is stored in the repository directory for tomcat. I deleted the generated code for the xsp page - then tried to execute it again - THEN it worked! I can't tell from your description of the problem if this could be the cause - but thought I'd pass this along just in case... marty > -----Original Message----- > From: Derek Hohls [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 2:38 AM > To: [EMAIL PROTECTED] > Subject: Re: Cocoon 1.8.2 and mySQL/ ESQL - hanging? > > > 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]> > > --------------------------------------------------------------------- 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]>
