I working with on a simple database query with cocoon 2. I've done this with the older cocoon, but here I'm having a processing problem of some sort with the taglib.
The connection pool is fine, that's working, however something goes wrong with the esql. It just sents the client back the xml without an attempt to do the query. I can even add an xsl and that works too, but the database action never happens. Again, I know the connection pool is active because I can see it's logins in the database (I'm using Sybase ASE). Details.... I created an xml file as follows: <?xml version="1.0"?> <xsp:page language="java" xmlns:xsp="http://www.apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2"; > <page> <esql:connection> <esql:pool>my_pool</esql:pool> <transactions> <esql:execute-query> <esql:query>select 123450</esql:query> <esql:results> <header>header info</header> <esql:row-results> <n> <id><esql:get-int column="Number"/></id> </nr> </esql:row-results> <footer>footer info</footer> </esql:results> </esql:execute-query> </transactions> </esql:connection> </page> </xsp:page> And a sitemap entry as follows: <map:pipeline> <map:match pattern="**myfile.xml"> <map:generate type="file" src="docs/myfile.xml"/> <map:serialize type="xml"/> </map:match> </map:pipeline> This all works, except that the raw xml (the file as-is) is all that is sent to the browser, as type xml as expected. But it's as though the esql tag were just any tag. Nothing is executed. The cocoon error file contains the following lines: ERROR (2002-04-23) 13:03.48:207 [sitemap.generator.velocity] (/cocoon/myfile.xml) HttpProcessor[8080][0]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. ERROR (2002-04-23) 13:03.48:239 [sitemap.generator.velocity] (/cocoon/myfile.xml) HttpProcessor[8080][0]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. ERROR (2002-04-23) 13:03.48:266 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:03.48:266 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:03.48:272 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:03.48:273 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:03.48:296 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:03.48:296 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:03.48:301 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:03.48:301 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:04.04:087 [sitemap.generator.velocity] (/cocoon/myfile.xml) HttpProcessor[8080][0]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. ERROR (2002-04-23) 13:04.04:121 [sitemap.generator.velocity] (/cocoon/myfile.xml) HttpProcessor[8080][0]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. ERROR (2002-04-23) 13:04.04:129 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:04.04:129 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:04.04:133 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:04.04:134 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:04.04:138 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:04.04:139 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:04.04:142 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:04.04:143 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:04.04:472 [sitemap.generator.velocity] (/cocoon/myfile.xml) HttpProcessor[8080][0]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. ERROR (2002-04-23) 13:04.04:506 [sitemap.generator.velocity] (/cocoon/myfile.xml) HttpProcessor[8080][0]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. ERROR (2002-04-23) 13:04.04:531 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:04.04:531 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:04.04:535 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:04.04:535 [sitemap.generator.xmldb] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:04.04:540 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:04.04:540 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: Make sure that your driver is available ERROR (2002-04-23) 13:04.04:544 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: There was a problem setting up the connection ERROR (2002-04-23) 13:04.04:544 [sitemap.generator.xmldbcollection] (/cocoon/myfile.xml) HttpProcessor[8080][0]/XMLDBCollectionGenerator: Make sure that your driver is available What is wrong? Thanks! --- Jeff Sexton ODS Health Plans [EMAIL PROTECTED] --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
