cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Annam, Sunil" <sunil.an...@eadstelecom-na.com>
Subject RE: the url cannot be null
Date Fri, 30 May 2003 15:26:17 GMT
I think you are missing
	<sql:use-connection>connection-name</sql:use-connection>
in testSQL.xml




-----Original Message-----
From: I-Lin Kuo [mailto:ikuoikuo@hotmail.com] 
Sent: Friday, May 30, 2003 10:24 AM
To: cocoon-users@xml.apache.org
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: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


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


Mime
View raw message