Jan,
well, I use SQLTranformer and not ESQL, for two basic reasons:
1) it does Stored Procedures just fine (and a year before ESQL did)
2) I don't like to be restricted to the generation step when it comes to SQL (as
happens using XSP)... though I have to admit I
dislike XSP all the way
On the other hand:
1) SQLTransformer is slower than EQSL (I didn't test it myself, though)
2) Some Cocoon developers think it worth deprecating (though this idea was rejected as
late as a few weeks ago). Hence, don't expect
SQLTranaformer to be upgraded anytime soon (though I might get on this job... hmmm...)
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Jan Willem Penterman [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 17, 2002 11:14 PM
> To: [EMAIL PROTECTED]
> Subject: SQLTransformer good, ESQL bad
>
>
> I'm sorry to the spam the list like this, but now I've got the feeling
> I'm really getting somewhere:
>
> I've set up cocoon-2.0.3 binary release for j2sdk1.4 and added a pool
> for MySQL Connector/J .
>
> Now I've actually managed to get some row data from a MySQL database
> using SQLTransformer!
>
> But with ESQL it still fails in:
>
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
> opening connection to dburl: : No suitable driver
>
> Now besides being curious about solving this error, I'd like to know why
> or why not I should stickt with SQLTransformer. In other words, why
> should I care about ESQL?
>
> JW
>
> P.s. I'm not going to post the pool setup, since SQLTransformer clearly
> got a connection from it so it works.
>
> query.xsp:
> ----------
>
> <?xml version="1.0"?>
> <xsp:page
> language="java"
> xmlns:xsp="http://apache.org/xsp";
> xmlns:esql="http://apache.org/cocoon/SQL/v2";>
> <root>
> <esql:connection>
> <esql:execute-query>
> <!-- connection information -->
> <esql:pool>mysql</esql:pool>
>
> <!-- SQL query -->
> <esql:query>
> select something from that
> </esql:query>
> <!-- result processing elements -->
> <esql:results>
> <esql:row-results>
> <that>
>
> <esql:get-columns/>
> </that>
> </esql:row-results>
> </esql:results>
> <esql:update-results/>
> <esql:no-results/>
> <esql:error-results/>
> </esql:execute-query>
>
> </esql:connection>
> </root>
> </xsp:page>
>
> sitemap.xmap: (this is a subsitemap of cocoon/sitemap.xmap)
> -------------
>
> <?xml version="1.0"?>
>
> <!-- sitemap for mysqltest -->
>
> <map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0";>
>
> <!-- ======= Components ======= -->
> <map:components>
> <map:generators default="file">
> <map:generator label="content,data"
> logger="sitemap.generator.serverpages" name="serverpages" pool-grow="2"
> pool-max="32" pool-min="4"
> src="org.apache.cocoon.generation.ServerPagesGenerator"/>
> </map:generators>
> <map:transformers default="xslt"/>
> <map:readers default="resource"/>
> <map:serializers default="html"/>
> <map:selectors default="browser"/>
> <map:matchers default="wildcard">
> <map:matcher name="wildcard"
> src="org.apache.cocoon.matching.WildcardURIMatcherFactory"/>
> </map:matchers>
> </map:components>
>
> <!-- ======= Pipelines ======= -->
> <map:pipelines>
> <map:pipeline>
> <map:match pattern="index.html">
> <map:read src="documents/static/index.html"
> mime-type="text/html"/>
> </map:match>
> <map:match pattern="esqltest.xml">
> <map:generate src="logic/query.xsp"
> type="serverpages"/>
> <map:serialize type="xml"/>
> </map:match>
>
> <map:match pattern="sqlttest.xml">
> <map:generate src="documents/mysqltest.xml"/>
> <map:transform type="sql">
> <map:parameter name="use-connection"
> value="mysql"/>
> </map:transform>
> <map:serialize type="xml"/>
> </map:match>
> </map:pipeline>
> </map:pipelines>
>
> </map:sitemap>
>
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
