Help: How to create sql element for dynamic queries?

[Jin, Juping]

I am new to Apache Cocoon 2 and try to generate dynamic queries based on
user's parameters. My idea looks like this:

In sitemap.xmap, my pipeline will be:

  <map:pipeline match="cocoon/myquery">
        <map:generate type="mygenerator"/>
        <map:transform type="sql"/>
        <map:serialize type="xml"/>
  </map:pipeline>

mygenerator is a Java class following the examples in Cocoon 2:

public class SQLGenerator extends AbstractGenerator 
  implements Disposable, Configurable {

    ...
    public void generate() throws SAXException
    {

      contentHandler.startDocument();
      
      contentHandler.startElement("", "document", "document",
emptyAttr);

      contentHandler.startPrefixMapping("sql",
"http://apache.org/cocoon/SQL/2.0";);
      contentHandler.startElement("sql", "execute-query",
"sql:execute-query", emptyAttr);
      contentHandler.startElement("sql", "use-connection",
"sql:use-connection", emptyAttr);
      contentHandler.characters("mycon".toCharArray(), 0,
"mycon".length());
      contentHandler.endElement("sql", "use-connection",
"sql:use-connection");
      contentHandler.startElement("sql", "query", "sql:query",
emptyAttr);
      contentHandler.characters("SELECT * FROM
Products".toCharArray(),0,
                 "SELECT * FROM Products".length());
      contentHandler.endElement("sql", "query", "sql:query");
      contentHandler.endElement("sql", "execute-query",
"sql:execute-query");
      contentHandler.endPrefixMapping("sql");
      ...
   }
   ...
}


Open IE, point it to http://localhost:8080/cocoon/myquery, I got the
following:

  <?xml version="1.0" encoding="UTF-8" ?> 
- <document>
- <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
     <sql:use-connection>mycon</sql:use-connection> 
     <sql:query>SELECT * FROM Product</sql:query> 
   </sql:execute-query>
  </document>

My question is: Why SQL tranformer is not invoked? However, if I create
a separate pipeline for above xml file, sql tranform is invoked and
executed.

The thing I am not sure is about startElement. The way I use is:

contentHandler.startElement("sql", "execute-query", "sql:execute-query",
emptyAttr);

Is this the correct way to start an element?

Thank you for reading and your suggestion will be highly appreciated.

Juping

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]