Re: SQLTransformer good, ESQL bad

2002-08-18 Thread Christian Haul
On 18.Aug.2002 -- 07:19 PM, Jan Willem Penterman wrote: > > Could you please try to find if your logs contain something > > like "could not acquire a Connection -- waiting" and set the > > parameter 1 in the > > declaration of the transformer in sitemap.xmap? > > No only the 'no suitable drive

RE: SQLTransformer good, ESQL bad

2002-08-18 Thread Jan Willem Penterman
> Could you please try to find if your logs contain something > like "could not acquire a Connection -- waiting" and set the > parameter 1 in the > declaration of the transformer in sitemap.xmap? No only the 'no suitable driver' error when calling the esql page.. And SQLTransformer works just

Re: SQLTransformer good, ESQL bad

2002-08-18 Thread Christian Haul
On 17.Aug.2002 -- 11:13 PM, 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 ge

RE: SQLTransformer good, ESQL bad

2002-08-17 Thread Luca Morandini
e- > 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 real

Re: SQLTransformer good, ESQL bad

2002-08-17 Thread Andrew C. Oliver
>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

SQLTransformer good, ESQL bad

2002-08-17 Thread Jan Willem Penterman
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