>From the information provided it is not immediately apparent to me what your problem is. But from crude benchmarking I've done.. ESQL is SIGNIFICANTLY faster than the SQLTransformer.. To experience this, use apbench on the http://localhost:8080/cocoon/samples/poi/statetax.xls and statetax2.xls (filenames are approximate) examples that come with cocoon. The statetax2 example is more complicated and has groupings and stuff, but its STILL several times faster than the SQLTransformer version. I found my results to be consistent when used other ways as well.
SQLTransformer is slow. -Andy On Sat, 2002-08-17 at 17:13, Jan Willem Penterman wrote: > 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]> > -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh --------------------------------------------------------------------- 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]>