cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jsex...@odshp.com
Subject Simple esql problem, I think
Date Tue, 23 Apr 2002 20:20:01 GMT

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
jsexton@odshp.com



---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message