Return-Path: 
 <users-return-60374-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 58058 invoked from network); 28 Dec 2003 11:18:43 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 28 Dec 2003 11:18:43 -0000
Received: (qmail 81056 invoked by uid 500); 28 Dec 2003 11:18:07 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 81026 invoked by uid 500); 28 Dec 2003 11:18:07 -0000
Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:users-help@cocoon.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@cocoon.apache.org>
list-post: <mailto:users@cocoon.apache.org>
Reply-To: users@cocoon.apache.org
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 81013 invoked from network); 28 Dec 2003 11:18:07 -0000
Received: from unknown (HELO mta02-svc.ntlworld.com) (62.253.162.42)
  by daedalus.apache.org with SMTP; 28 Dec 2003 11:18:07 -0000
Received: from [81.98.165.178] by mta02-svc.ntlworld.com
          (InterMail vM.4.01.03.37 201-229-121-137-20020806) with ESMTP
          id <20031228111813.OYWT29762.mta02-svc.ntlworld.com@[81.98.165.178]>
          for <users@cocoon.apache.org>; Sun, 28 Dec 2003 11:18:13 +0000
Mime-Version: 1.0 (Apple Message framework v609)
In-Reply-To: <bsmbve$n3d$1@sea.gmane.org>
References: <3FEE434F.8070100@verona.se> <bsmbve$n3d$1@sea.gmane.org>
Content-Type: text/plain; charset=US-ASCII; format=flowed
Message-Id: <89BC8B75-3927-11D8-916D-0003938366A4@beya-records.com>
Content-Transfer-Encoding: 7bit
From: beyaRecords - The home Urban music <uzo@beya-records.com>
Subject: database issuses - (cocoon + mysql)
Date: Sun, 28 Dec 2003 11:18:18 +0000
To: users@cocoon.apache.org
X-Mailer: Apple Mail (2.609)
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi,
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 
this:

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

<datasources>
     <jdbc logger="core.datasources.mysql" name="mysql">
       <pool-controller max="10" min="5"/>
       <auto-commit>false</auto-commit>
       <dburl>jdbc:mysql://localhost/test</dburl>
       <user>user</user>
       <password>password</password>
     </jdbc>
</datasources>

3. edit CATALINA_HOME/webapps/cocoon/web-inf/web.xml
     <init-param>
       <param-name>load-class</param-name>
       <param-value>
       	<!-- MySQL -->
       	 org.gjt.mm.mysql.Driver
       	
       	<!-- PostgreSQL -->
       	org.postgresql.Driver

       </param-value>
     </init-param>

4. xsp code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp" 
xmlns:esql="htp://apache.org/cocoon/SQL/v2" 
xmlns:xsp-session="http://apache.org/xsp/session/2.0">
<page>
	<title>trouble tickets</title>
	<content>
		<esql:connection>
			<esql:pool>mysql</esql:pool>
				<esql:execute-query>
					<esql:query>select * from TroubleTickets</esql:query>
						<esql:results>
							<tickets>
								<esql:row-results>
									<ticket>
										<esql:get-columns/>
									</ticket>
								</esql:row-results>
							</tickets>
						</esql:results>
						<esql:no-results>
        						<p>Sorry, no results!</p>
     					</esql:no-results>
				</esql:execute-query>
		</esql:connection>
	</content>
</page>
</xsp:page>

5. xsl snippet:

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

regards


Uzo
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
> lmorandini@ieee.org
> http://xoomer.virgilio.it/ukmorand/
> -----------------------------------
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org