I reported this bug and posted a fix many months ago, but nothing has
been done with it. It seems to only affect certain databases. I'd be
glad to forward you the code.
Brian
On Wednesday, May 28, 2003, at 09:36 AM, Carmona Perez, David wrote:
Dear Cocooners,
I've think I found a bug in the
PROTECTED]
Sent: Thursday, May 29, 2003 10:30 PM
Subject: Re: SQLTransformer bug
I reported this bug and posted a fix many months ago, but nothing has
been done with it. It seems to only affect certain databases. I'd be
glad to forward you the code.
Brian
On Wednesday, May 28, 2003, at 09:36 AM
connection
causing
NullPointerException when accessing ResultSet
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12173
Andreas
- Original Message -
From: Brian Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 10:30 PM
Subject: Re: SQLTransformer bug
I reported
Thanks Brian!
David
-Mensaje original-
De: Brian Johnson [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 29 de mayo de 2003 22:30
Para: [EMAIL PROTECTED]
Asunto: Re: SQLTransformer bug
I reported this bug and posted a fix many months ago, but nothing has
been done
-Original Message-
From: Irv Salisbury III [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 6:38 PM
To: [EMAIL PROTECTED]
Subject: SQLTransformer stored procedure question
I call an existing stored procedure with:
sql:execute-query
sql:query
On Wednesday, March 5, 2003, at 05:15 PM, Irv Salisbury III wrote:
We'd like to use paging in our application from the result sets
returned from the SQLTransformer. However, with a number of our
queries returning 20,000+ rows, it seems like the current Paginator
will not cut it for us. This
I have also started to look into this, but have not come up with
anything yet. I'd be very interested in anything you come up with, and
will certainly pass along any ideas I have.
Brian
On Wednesday, March 5, 2003, at 12:15 PM, Irv Salisbury III wrote:
We'd like to use paging in our
I-Lin Kuo [EMAIL PROTECTED] writes:
I've been working with Cocoon for a week. I have a simple xml page to
be run through an SQLTransformer
page xmlns:sql=http://apache.org/cocoon/SQL/2.0;
titleSQLTransformer Test/title
content
para
execute-query
I-Lin,
yes, there are a number of strange things about XML namespaces in SQL Transformer: one
of those I ironed out myself... the others I
left to Carsten ;)
What I usually do is mention the namespace in the root element and then prefix all
elements with the sql prefix.
I think it is clearer
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
This is _really_ strange.
Erm, _I_ am really strange...
I had my esql:pool tag within the esql:query...
Aargh!
JW
-
Please check that your question has not already been answered in the
FAQ before posting.
On 18.Aug.2002 -- 09:14 PM, Jan Willem Penterman wrote:
This is _really_ strange.
Erm, _I_ am really strange...
I had my esql:pool tag within the esql:query...
Aargh!
Glad to hear this is not esql related :-)
Mind you, no-one else spotted it either.
Chris.
--
C h r i s t i a n
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
Hi Joshua,
Did you perform the same test outside of cocoon? You should check how
long it actually takes for MySql to answer your query. If this is much
faster than those 130 ms, there might be a problem.
Also note that turning of debugging in Cocoon has given me a 10 times
speedup once.
The queries are definitely not taking 130ms outside of
cocoon.
What do you mean by turning off debugging? I've
changed the logging status to ERROR, and saw some
improvement. What did you turn off, and how did you do
so?
Thanks! :)
- Josh
--- Tom Klaasen [EMAIL PROTECTED] wrote:
Hi Joshua,
Joshua McCulloch wrote:
The queries are definitely not taking 130ms outside of
cocoon.
Can you put numbers on this? How much does it take to do the same
queries in a simple java program? (setup connections, start timer,
execute queries, stop timer)
And on another note: does it also takes
On Mon, 2002-07-08 at 17:40, Joshua McCulloch wrote:
Hello,
I've been looking at page generating times with the
profiler. I am finding that SQLTransoformer is taking
a huge amount of time to do what I consider simple
queries. For example, a page that has two minor
queries takes about
jdbc name=myhms-datasource
logger=core.datasources.myhms-datasource
pool-controller min=5 max=10/
dburljdbc:mysql://localhost/ccc/dburl
useraaa/user
passwordbbb/password
/jdbc
According to the datasource configuration in
cocoon.xconf, it should be pooling. The logs
(core.log) seem to say its
Joshua,
have you profiled the same queries using ESQL ?
It could be useful having such a benchmark.
Best regards,
-
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
it doesn't support two nested queries on the same level of nesting, as far
as I remember after looking at C2.0.1 sources. I don't think it's fixed.
Workaround is:
1. modify source codes
2. use XSP
I use XSP with ESQL
Can someone confirm this, and is there a workaround other
than chaining
:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 10:28 AM
To: '[EMAIL PROTECTED]'
Subject: RE: SQLTransformer, multiple execute-query siblings?
it doesn't support two nested queries on the same level of
nesting, as far as I remember after looking at C2.0.1
sources. I don't think it's
- Original Message -
From: Argyn Kuketayev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 4:27 PM
Subject: RE: SQLTransformer, multiple execute-query siblings?
it doesn't support two nested queries on the same level of nesting, as
far
as I remember after looking
the stack. I don't remember all the details though
-Original Message-
From: Jens Lorenz [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: Re: SQLTransformer, multiple execute-query siblings?
The problem is, that it's not that easy. Transformer
Bertrand,
could, just possibly, a sub-select fit the bill ?
something like:
SELECT Name
FROM Employee
WHERE Ssn IN (
SELECT DISTINCT PMSsn
FROM Projects
WHERE Status = 'open'
)
Best regards,
- Original Message -
From: Jens Lorenz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 4:40 PM
Subject: Re: SQLTransformer, multiple execute-query siblings?
From: Argyn Kuketayev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 4:27 PM
Subject
-
-Original Message-
From: Jens Lorenz [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 6:19 PM
To: [EMAIL PROTECTED]
Subject: Re: SQLTransformer, multiple execute-query siblings?
- Original Message -
From: Jens Lorenz [EMAIL PROTECTED
Your example shows that it's possible to have one nested query inside
another one. But it doesn't show that you may have sibling nested queries.
as far as I remember, you can have only one child (nested query), but that
child can have one child too and so on. you can't have this:
page
: Friday, June 21, 2002 12:49 PM
To: [EMAIL PROTECTED]
Subject: RE: SQLTransformer, multiple execute-query siblings?
Jens,
I beg your pardon, but, what's the use of having such nested queries ?
-
Please check that your
/lmorandini/index.html
-
-Original Message-
From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 6:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: SQLTransformer, multiple execute-query siblings?
suppose you want to have
A Dangerous fix. But if I had to speculate: I imagine conn.close() is
synchronized. Secondly, I imagine its logged. Cause this to be a
warning (not be logged) and there should be a performance increase..
Cause conn.close() to not be synchronized (haven't looked...just a
guess) and there
33 matches
Mail list logo