Check your spelling
<map:prameter name="use_connection" value="DA"/>
It should be
<map:parameter name=“use_connection" value="DA"/>
Regards
Scott Warren
Ocom Software
... Exceeding Quality.....
web | ocom.com.au
-----Original Message-----
From: Fabio Duo [mailto:[EMAIL PROTECTED]
Sent: Friday, 18 June 2004 1:05 AM
To: [EMAIL PROTECTED]
Subject: The url cannot be null
Hello,
I know that it is a newby question. But i didn't found a solution on the
Internet.
I want to establish a connection to a MySQL DB. But i recive the following
Error in the Brower Window: The url cannot be null.
I modyfied the DB example from the samples "shipped" with cocoon.
I tried a couple of possibilities without a solution or a idea what the
problem is.
I use jetty to run cocoon.
Please excuse my poor english and i hope somebody has a hint for me.
Thank you
Fabio
Entry in web.xml(Newest Driver from the Mysql Homepage):
org.gij.mm.mysql.Driver
Enrty in cocoon.xconf in the datasources:
<jdbc name="DA">
<pool-controller min="5" max="10"/>
<dburl>jdbc:mysql://localhost/DA</dburl>
<User>root</User>
<password>alta</password>
</jdbc>
Sitemap:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- CVS $Id: sitemap.xmap,v 1.13 2003/11/18 07:12:10 tony Exp $ -->
<map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0";>
<map:components>
<map:transformer name="sql" logger="sitemap.transformer.sql"
src="org.apache.cocoon.transformation.SQLTransformer"/>
</map:components>
<!-- =========================== Views
=================================== -->
<map:views>
<map:view from-label="content" name="content">
<map:serialize type="xml"/>
</map:view>
<map:view from-label="content" name="pretty-content">
<map:transform
src="context://stylesheets/system/xml2html.xslt"/>
<map:serialize type="html"/>
</map:view>
<map:view from-position="last" name="links">
<map:serialize type="links"/>
</map:view>
</map:views>
<!-- =========================== Pipelines
================================= -->
<map:pipelines>
<map:pipeline>
<map:match pattern="test">
<map:generate src="sql-page.xml"/>
<map:transform type="sql">
<map:prameter name="use_connection" value="DA"/>
</map:transform>
<map:transform src="sql2html.xsl" />
<map:serialize/>
</map:match>
</map:pipeline>
</map:pipelines>
</map:sitemap>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
