I think you are missing
<sql:use-connection>connection-name</sql:use-connection>
in testSQL.xml
-----Original Message-----
From: I-Lin Kuo [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 10:24 AM
To: [EMAIL PROTECTED]
Subject: the url cannot be null
cocoon 2.04:
I have a problem that's bugging the hell out of me because it must be
really
simple. I'm hoping to get a fresh pair of eyes to look at this problem.
I
have a page to test the SQL connection that works from one directory but
not
the other. By "works", I mean one returns:
...
<rowset nrofrows="1">
<row>
<now>may 30, 2003 10:55:37</now>
</row>
</rowset>
...
while the other returns:
...
<rowset>
<error>The url cannot be null</error>
</rowset>
...
My directory structure is:
cocoon/
sitemap.xmap
- myDev/
- test/
- prototype/
Minimalsitemap.xmap
- xml/
where I have a main "sitemap.xmap" which mounts a subsitemap
"Minimalsitemap.xmap" via:
<map:match pattern="NSFGProto/**">
<map:mount check-reload="yes"
src="NSFGProto/Minimalsitemap.xmap"
uri-prefix="NSFGProto"/>
</map:match>
Here are the relevant snippets from the various sitemaps and the xml
that
tests the connection.
<!-- match from Minimalsitemap.xmap under prototype -->
<map:match pattern="testSQL">
<map:generate src="xml/testSQL.xml"/>
<map:transform type="sql">
<map:parameter name="use-connection" value="SSVDPool"/>
</map:transform>
<map:serialize type="xml"/>
</map:match>
<!-- match from sitemap.xmap under myDev -->
<map:match pattern="test/SSVDPool">
<map:generate src="myDev/test/testSQL.xml"/>
<map:transform type="sql">
<map:parameter name="use-connection" value="SSVDPool"/>
<map:parameter name="show-nr-of-rows" value="true"/>
</map:transform>
<map:serialize type="xml"/>
</map:match>
<!-- contents of testSQL.xml -->
<page xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
<title>SQLTransformer Test with sql:</title>
<content>
<para>
<sql:execute-query>
<sql:query>
select to_char(sysdate, 'month DD, YYYY
HH24:MI:SS') "Now" from dual
</sql:query>
</sql:execute-query>
</para>
</content>
</page>
Am I missing something obvious, or is there a problem with specifying
the
pool once I do a sitemap mount? And what does the error "The url cannot
be
null" mean?
I-Lin Kuo, Ann Arbor, MI
Macromedia Certified ColdFusion 5.0 Advanced Developer
Sun Certified Java 2 Programmer
Ann Arbor Java Users Group (http://www.aajug.org)
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
