cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <dho...@csir.co.za>
Subject Re: Cocoon 1.8.2 and mySQL/ ESQL - hanging?
Date Thu, 18 Oct 2001 06:37:49 GMT
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

>>> lmocz@galatea.com 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> 
> 



---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>



---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message