the url cannot be null

I-Lin Kuo Sat, 31 May 2003 01:31:18 -0700

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]

the url cannot be null

Reply via email to