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 get some
Could you please try to find if your logs contain something
like could not acquire a Connection -- waiting and set the
parameter connect-attempts1/connect-attempts in the
declaration of the transformer in sitemap.xmap?
No only the 'no suitable driver' error when calling the esql page..
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 connect-attempts1/connect-attempts in the
declaration of the transformer in sitemap.xmap?
No only
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
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