cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From beyaRecords - The home Urban music <>
Subject database issuses - (cocoon + mysql)
Date Sun, 28 Dec 2003 11:18:18 GMT
I am having an issue connecting to a MySQL database. Basically, any 
esql tags with data between them is being written to the screen instead 
of being processed and no connection to the database is being made. For 
example instead of <esql:pool>mysql</esql:pool> being processed, 
'mysql' is being printed to the screen. What am i not doing correctly? 
The process I followed to try and ensure database connectivity was 

1. Copy JDBC driver for MySQL into CATALINA_HOME/common/lib
2. Define a MySQL datasource:

     <jdbc logger="core.datasources.mysql" name="mysql">
       <pool-controller max="10" min="5"/>

3. edit CATALINA_HOME/webapps/cocoon/web-inf/web.xml
       	<!-- MySQL -->
       	<!-- PostgreSQL -->


4. xsp code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page language="java" xmlns:xsp="" 
	<title>trouble tickets</title>
					<esql:query>select * from TroubleTickets</esql:query>
        						<p>Sorry, no results!</p>

5. xsl snippet:

		<xsl:template  match="tickets">
			<table border="1"  width="100%">
		<xsl:template match="ticket">
				<xsl:for-each select="*">


On 28 Dec 2003, at 10:40, Luca Morandini wrote:

> joakim verona wrote:
>> So I guess my basic question is: how do I make a pipeline that can 
>> take both request parameters and
>> "bizdata" parameters at the same time? Or is it the other way around? 
>> Should the pipeline
>> be made to accept "bizdata" parameters only?
> Well, let's put it this way: if I had to send two parameters ("x" and 
> "y") to pipeline "foo.xml", I'd do the following ("os" being the 
> pipeline's output and "x" and "y2 the Javascript variables holding 
> request parameters' values):
> cocoon.processPipelineTo('foo.xml', {'x' : x, 'y' : y}, os);
> Regards,
> -----------------------------------
> Luca Morandini   -   GIS Consultant
> -----------------------------------
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message