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="">
</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="">
<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="">
<map:transform type="sql">
<map:prameter name="use_connection" value="DA"/>
</map:transform>
<map:transform src="" />
<map:serialize/>
</map:match>
</map:pipeline>
</map:pipelines>
</map:sitemap>