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-connection>connection-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]
