RE: the url cannot be null
Maybe you're facing the same problem I've had with the SQL Transformer that is closing the connection too prematurely. * open connection * perform query * get resultset * close the connection-- I've had to move this step later * browse the resultset David -Mensaje original- De: I-Lin Kuo [mailto:[EMAIL PROTECTED] Enviado el: viernes, 30 de mayo de 2003 17:44 Para: [EMAIL PROTECTED] Asunto: RE: the url cannot be null I think you are missing sql:use-connectionconnection-name/sql:use-connection in testSQL.xml Thanks for the suggestion but that's not it. I don't need to specify that in testSQL.xml if I supply it as a parameter to the SQLTransformer in the pipeline as I've done. Besides, it's the same file in both cases, but one runs and the other doesn't. I did a little more searching and found the following on http://wiki.cocoondev.org/Wiki.jsp?page=UnderstandingCocoonMounts Components Inheritance of components have been a little problem between some versions of Cocoon, it's now solved. But after experience, it's not so bad to keep the components you need in each sitemap, especially to have your own names for generators or transformers, and be able to move your app under any other sitemap, or put it directly as root. So, maybe it's my SQLTransformer that's not being inherited in my subsitemap? 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) _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - 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]
RE: the url cannot be null
I think you are missing sql:use-connectionconnection-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 nowmay 30, 2003 10:55:37/now /row /rowset ... while the other returns: ... rowset errorThe 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; titleSQLTransformer Test with sql:/title content para sql:execute-query sql:query select to_char(sysdate, 'month DD, 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]
RE: the url cannot be null
I think you are missing sql:use-connectionconnection-name/sql:use-connection in testSQL.xml Thanks for the suggestion but that's not it. I don't need to specify that in testSQL.xml if I supply it as a parameter to the SQLTransformer in the pipeline as I've done. Besides, it's the same file in both cases, but one runs and the other doesn't. I did a little more searching and found the following on http://wiki.cocoondev.org/Wiki.jsp?page=UnderstandingCocoonMounts Components Inheritance of components have been a little problem between some versions of Cocoon, it's now solved. But after experience, it's not so bad to keep the components you need in each sitemap, especially to have your own names for generators or transformers, and be able to move your app under any other sitemap, or put it directly as root. So, maybe it's my SQLTransformer that's not being inherited in my subsitemap? 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) _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]