I just skimmed through the mailing list to find ideas of how to cache a
pipeline starting with a request generator and later on passing data
through the SQLTransformer.
Did you or anybody else follow up on this idea?
NB: Caching of the request generator would probably also need to cache
request
/
/map:otherwise
/map:select
/map:act
/map:match
David
Christian Kurz wrote:
I just skimmed through the mailing list to find ideas of how to cache a
pipeline starting with a request generator and later on passing data
through the SQLTransformer.
Did you
in the SQLTransformer in Cocoon 2.0.4, at
least under Informix.
I use a simple query (select * from table) and it fails. After having
investigated a bit, I've come to the conclusion that it tries to do
the following
open connection
create prepared statement
get resultset
close connection
navigate
That seems to be this one:
[PATCH] SQLTransformer Query object prematurely closes 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
According to bugzilla, It looks like the patch was applied back in
January, but I don't see that anything has changed. Am I missing
something?
On Thursday, May 29, 2003, at 04:52 PM, Andreas Kuckartz wrote:
That seems to be this one:
[PATCH] SQLTransformer Query object prematurely closes
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
Dear Cocooners,
I've think I found a bug in the SQLTransformer in Cocoon 2.0.4, at least under
Informix.
I use a simple query (select * from table) and it fails. After having investigated a
bit, I've come to the conclusion that it tries to do the following
open connection
create prepared
I'm using the SQLTransformer to insert somewhat large data sets into an
Oracle database. I generate XML from a spreadsheet input. Each row gets
its own execute-queryqueryblah, blah.../query/execute-query block.
I am hitting the database over an SSH port-mapped link, so it is kind of
slow
=oracle.jdbc.driver.OracleTypes.CURSOR/
/sql:execute-query
However, I get an ORA-08103: object no longer exists error at
SQLTransformer:1250. This line looks like it is simply calling
getObject on the CallableStatement. Any reason why I might be getting
this ?
Thanks,
Irv
-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
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 is mainly because it looks like the Paginator expects
all
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 is mainly because it looks like the
Paginator expects all of the data to be there, which we don't want
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 xmlns=http://apache.org
Running Cocoon 2.04 on Tomcat 4 on Apache 2 on Windows XP with JDK 1.4
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 xmlns
: I-Lin Kuo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 10:03 PM
To: [EMAIL PROTECTED]
Subject: SQLtransformer repeats namespace
Running Cocoon 2.04 on Tomcat 4 on Apache 2 on Windows XP with JDK 1.4
I've been working with Cocoon for a week. I have a simple xml page
On Wed, 8 Jan 2003 22:40:37 -, Renaud Bruyeron [EMAIL PROTECTED]
wrote:
I am facing a weird problem with the SQLTransformer.
This happens with cocoon 2.0.4 on jdk1.3.1 running in Tomcat 4.1.12
Tomcat doesn't contains the required librariesfor J2EE datasources by
default. Check
your
Sebastian Gil [EMAIL PROTECTED] wrote in message
opriqa1bv0m7k2hg@localhost">news:opriqa1bv0m7k2hg@localhost...
On Wed, 8 Jan 2003 22:40:37 -, Renaud Bruyeron [EMAIL PROTECTED]
wrote:
I am facing a weird problem with the SQLTransformer.
This happens with cocoon 2.0.4 on
.
The problem therefore is with the SQLTransformer.Query inner class which
closes the Connection at the end of execute(), but the SQLTransformer still
tries to access the resultset to read the rows.
This does not work with DBCP because the ResultSet.close() is called when
Connection.close() is called
I am facing a weird problem with the SQLTransformer.
This happens with cocoon 2.0.4 on jdk1.3.1 running in Tomcat 4.1.12
I have a J2EE Datasource defined via Tomcat's JNDI (the db is MySQL) bound
at java:comp/env/jdbc/Publisher
I am trying to get cocoon to use that datasource via
Hi,
I use SQLTransformer to access my database (no problems). But the data
stored in my DB are XML data (well formed). When the transformer get the
data, it replaces all the with lt ,etc
For example if my database contains titleSomeText/title the output
Stream of my pipeline contains rowlt
Hello,
With Cocoon 2.0.3, on windows NT, and tomcat 4.1.12
I have a problem with SQLTransformer (with Oracle JDBC driver). Cocoon returns
all records normally without data !!
Example:
rowset
row
rpb_id/
rpb_id/
/row
/rowset
How solve this problem ?
Thank you
Didier Rano
Serv'N Data
]
http://utenti.tripod.it/lmorandini/index.html
-
-Original Message-
From: Rano, Didier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 10:37 AM
To: [EMAIL PROTECTED]
Subject: Problem SQLTransformer
Hello,
With Cocoon
Rano, Didier a écrit :
I verified, and values in column rpb_id are not null.
Columns names are the same, because it is a test with SQL: select rpb_id,
rpb_id from hia_rp_bml. But with SQL: select rpb_id from hia_rp_bml the
result has the same problem.
Thank you for your help
Didier
messages
Objet : Re: Réf:RE: Problem SQLTransformer
Auteur :[EMAIL PROTECTED]
Date : 05/12/2002 14:10
Rano, Didier a écrit :
I verified, and values in column rpb_id are not null.
Columns names are the same, because it is a test with SQL: select rpb_id,
rpb_id from hia_rp_bml. But with SQL
:
|
| Subject: Problem SQLTransformer
Hi,
When I execute a query like select wfID as ID, wfName as Name from Workflowlist
In the browser (I used the default xml2html stylesheet) I get something like this :
-4=4name=name
-
1/
Max_pkg1/
/
-
2/
Max_pkg2/
/
...
/
But how can I get the tags like :
Hi!
You can use another xsl or a generator to get this job done. For example,
using XSP:
esql:connection
esql:poolmp_pool/esql:pool
esql:execute-query
esql:query
SELECT usr_id, usr_name, FROM users
WHERE usr_enable=1
/esql:query
esql:results
tags with SQLTransformer
Hi,
When I execute a query like select wfID as ID, wfName as Name from Workflowlist
In the browser (I used the default xml2html stylesheet) I get something like this :
-4=4name=name
-
1/
Max_pkg1/
/
-
2/
Max_pkg2
Maybe it's only the transformer. I heard of some infrequently problems
with the stylesheet. Try to view the XML directly (e.g. in Internet
Explorer, which has its own xml2html stylesheet).
Regards,
Joerg
[EMAIL PROTECTED] wrote:
Hi,
When I execute a query like select wfID as ID, wfName as
esql:connection is not bound.
-Original Message-
From: Antonio Gallardo [mailto:[EMAIL PROTECTED]] Sent:
Tuesday, December 03, 2002 8:34 PM
To: [EMAIL PROTECTED]
Subject: Re: Don't get XML tags with SQLTransformer
Hi!
You can use another xsl or a generator to get this job done
On Tuesday 12 November 2002 12:31, Jeremy Quinn wrote:
On Monday, Nov 11, 2002, at 19:41 Europe/London, Kjetil Kjernsmo
wrote:
I have problems with the SQLTransformer in a recent 2.1-dev, more
specifically, I can't get the substitute-value element to work.
Sorry, but this works fine for me
On Monday, Nov 11, 2002, at 19:41 Europe/London, Kjetil Kjernsmo wrote:
I have problems with the SQLTransformer in a recent 2.1-dev, more
specifically, I can't get the substitute-value element to work.
Sorry, but this works fine for me in 2.1dev
(I have different problems ;)
regards Jeremy
Hi list!
I have problems with the SQLTransformer in a recent 2.1-dev, more
specifically, I can't get the substitute-value element to work.
This is a pipeline from my sitemap:
map:pipeline
map:match pattern=artikler/*/*
map:generate src=resources/articlessql.xml
Dear All,
Christian Haul wrote:
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!
Do you mean the pool was within the 'query' or within the
'execute-query'?
On 19.Aug.2002 -- 09:24 AM, Alan Hodgkinson wrote:
Dear All,
Christian Haul wrote:
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!
Do you mean the
Dear Christian,
Thanks for the quick reply :)
And worse.. the Dodds IBM Tutorial, 'Cocoon 2: Build database
driven sites', presents an example that contains the following:
esql:connection
esql:execute-query
esql:pool.../esql:pool
esql:query...
...
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
Jan, this is hardly believable
..
And SQLTransformer works just fine with 1 connection attempt.
Is the way I call the esql sheet any good? :
..
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
the 'no suitable driver' error when calling the esql page..
And SQLTransformer works just fine with 1 connection attempt.
This is _really_ strange. The real stuff is handled by Avalon Excalibur
for both approaches. There should not be any difference. As I don't have
MySQL here, I cannot test
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
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
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
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
the following error while trying to connect to a postgresql
database
throw the SQLTransformer:
java.sql.SQLException: No suitable driver
I've seen in the list archives that it's been reported various times
but
none of the solutions seems to correct my problem.
web.xml:
init-param
for foo but is finding ns:foo ?)
Geoff Howard
-Original Message-
From: Albert Cervera Areny [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 10:01 AM
To: [EMAIL PROTECTED]
Subject: Problems with SQLTransformer
Hi,
I start a new thread about it because the problem deserves
-
-Original Message-
From: Albert Cervera Areny [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 4:01 PM
To: [EMAIL PROTECTED]
Subject: Problems with SQLTransformer
Hi,
I start a new thread about it because the problem deserves this and I'm
desperate ;-)
map:generate src=docs
are not the problem? (the
xsl is looking for foo but is finding ns:foo ?)
Geoff Howard
-Original Message-
From: Albert Cervera Areny [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 10:01 AM
To: [EMAIL PROTECTED]
Subject: Problems with SQLTransformer
Hi,
I start a new thread
On 09.Aug.2002 -- 05:13 PM, Albert Cervera Areny wrote:
Hi,
This is what I receive after the SQLTransform when I look it through the
browser (option view source code)
?xml version=1.0 encoding=UTF-8?
rowset
row
id081778/id
role/
nomname/nom
passwdpaswd/passwd
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 11:19 AM
To: [EMAIL PROTECTED]
Subject: Re: Problems with SQLTransformer
You need to copy all other elements explicitly!
? I don't see any that he didn't handle.
!--
Copy all
081778namepassdprogname
This looks like the default template for elements which just copies their
value. As an experiment, try this:
?xml version=1.0 encoding=iso-8859-1?
xsl:stylesheet version=1.0
xmlns:xsl=http://www.w3.org/1999/XSL/Transform;
xsl:template match=rowset
]
Subject: Problems with SQLTransformer
Hi,
I start a new thread about it because the problem deserves
this and I'm
desperate ;-)
map:generate src=docs/consulta.xml/
map:transform type=sql
map:parameter name=use-connection value=cocoon/
/map:transform
map:transform src
Albert,
you should declare the sql namespace in usuaris.xsl; moreover, don't
forget to add sql: in front of row and rowset template matching.
Yes, I know the sql: namespace is not displayed in your SQLTransformer
output, but, nevertheless, could you please try ?
Best regards
o.k.: I mean: there is an official docu for Cocoon 2 and the
SQLTransformer part is pretty long, and seems to be not too bad. but
this seems to be a VERY essential point and should be mentioned, dont
you think so.
Well, I'd love doing that (no, what I'd really love would de solving
]]
Sent: Monday, July 22, 2002 11:07 PM
To: [EMAIL PROTECTED]
Subject: Re: Strange SQLTransformer problem: Encoding bug in Cocoon 2?
Luca Morandini wrote:
Alexander,
did you solve your SQLTransformer problem ?
thank you very much. found time now.
strange enough, but your tip
mean: there is an official docu for Cocoon 2 and the
SQLTransformer part is pretty long, and seems to be not too bad. but
this seems to be a VERY essential point and should be mentioned, dont
you think so.
snip
(2) this solution works, but is practically completely unusable, as it
makes
hello
when i use SQLTransformer, how
to preserve the bank and CRLF of the data from database?
thanks
ZhaiYun
Hi.
I'm receiving two consecutive unsuported exceptions:
---
DEBUG (2002-07-16) 10:09.12:987
[sitemap.transformer.sql](/cocoon/LinePlant)
HttpProcessor[8080][4]/SQLTransformer$Query: EXECUTING SELECT
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,
130 ms if the SQLTransformer is
already executed some times? The first time, you have overhead in
creating connections etc, while after some times, the connections are
taken from a pool.
What do you mean by turning off debugging? I've
changed the logging status to ERROR, and saw some
improvement
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
/index.html
-
-Original Message-
From: Joshua McCulloch [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 08, 2002 5:41 PM
To: [EMAIL PROTECTED]
Subject: SQLTransformer
Hello,
I've been looking at page generating times with the
profiler
I think I know the answer, but is there any way to construct dynamic
queries using SQLTransformer? Specifically, I'd like to build the where
clause of my query using either a session attribute or a sitemap
parameter. I've been thru the code and don't see that it can be done,
but I thought I'd
]]
Sent: Monday, June 24, 2002 10:18 PM
To: [EMAIL PROTECTED]
Subject: Getting parameters to SQLTransformer
I think I know the answer, but is there any way to construct dynamic
queries using SQLTransformer? Specifically, I'd like to build the where
clause of my query using either a session
://utenti.tripod.it/lmorandini/index.html
-
-Original Message-
From: Lajos Moczar [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 10:18 PM
To: [EMAIL PROTECTED]
Subject: Getting parameters to SQLTransformer
I think I know the answer
-Original Message-
From: Luca Morandini [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 4:41 PM
To: [EMAIL PROTECTED]
Subject: RE: Getting parameters to SQLTransformer
What I would suggest is the use of stored procedures, with an
XSL building
the statement, hence:
can
Argyn,
here's a snippet of a stylesheet (let's pretend name-clean contains the given
parameter, be it a session, request or static
parameter), which dynamically builds a stored procedure invokation for SQLTransformer
to execute:
xsl:element name=sql:execute-query
xsl:element name
Hi SQLers,
If I understand the SQLTransformer code correctly, this construct is not
supported:
execute-query
queryselect A/query
execute-query
queryselect B using values from select A in where clause/query
execute-query
!-- is a second one here supported? --
execute-query
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
After flirting briefly with SQLTransformer, I'm using XSP/ESQL--they
work great.
A couple alternatives might be to create separate pipelines with
SQLTransformer and aggregate them in your sitemap, or to build a single
large union query.
-Original Message-
From: Argyn Kuketayev [mailto
- 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
]]
Sent: Friday, June 21, 2002 3:48 PM
To: [EMAIL PROTECTED]
Subject: SQLTransformer, multiple execute-query siblings?
Hi SQLers,
If I understand the SQLTransformer code correctly, this construct is not
supported:
execute-query
queryselect A/query
execute-query
queryselect B
- 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
I'm trying to access a Basis Plus database using their JDBC driver.
It looks like the connection opens correctly, but then I get 500 internal
error from Cocoon, and the following messages in the tomcat logs:
java.lang.AbstractMethodError
at
at
org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement
I found my problem: the JDBC driver I'm using is not JDBC 1.2 compliant -
need to tell the SQLTransformer to use the old-driver interface by
configuring it like follows in the sitemap:
map:transformer
logger=sitemap.transformer.sql-old
name=sql-old
Hallo,
are there any known issues using SQLTransformer?
I query a database and pass the result to a style sheet for further
processing...the rowset elements and contents are ignored.
If I save the resulting file before it is passed to the stylesheet for futher
processing and then pass
. Add caching to the SqlTransformer. I know this sounds weird, but
hear me
out. Our database is modified infrequently, so usually returns the
same
data. There is a datestamp in a special table which indicates when
the last
time the database was updated. The SQL Transformer would remember
May be you should consider different design, which is suited
better for
the problem? XSP pages with ESQL provide easy ability to program any
caching behavior.
What?!? You just convinced me to go from XSP/ESQL to SQLTransformer! The
problem with ESQL is the Java recompilation, which
RequestGenerator *should* cache. Give me a good reason why it shouldn't
have caching!
--Steve
-Original Message-
From: Stephen Ng [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 7:23 PM
To: 'Vadim Gritsenko'; [EMAIL PROTECTED]
Subject: RE: caching proposals: SQLTransformer
Hi Cocooners,
I'm having a problem with the encoding of a sql query from the SQLTransformer.
Configuration is:
Cocoon 2.0.3-dev from CVS
IBM JDK 1.3
Tomcat 3.3
Oracle 8.1.7
Instead of getting the wanted germans umlauts, I'm apparently getting UTF
encoded characters (instead of ü
Hi Frank,
Did you check the result you get before transformation by sql.xsl? Perhaps it is
necessary to use attribute disable-output-escaping=yes in its elements.
Roman
Frank Ridderbusch wrote:
Hi Cocooners,
I'm having a problem with the encoding of a sql query from the SQLTransformer
Hello,
I'm using SQLTransformer to convert this simple piece of SQL:
page xmlns:sql=http://apache.org/cocoon/SQL/2.0;
execute-query xmlns=http://apache.org/cocoon/SQL/2.0;
query
SELECT name
FROM listing
/query
/execute-query
/page
into XML file using this code from the DocBook XSLT
I've been load testing my cocoon app with jmeter and I think I've found a
SQLTransformer bug.
My (MS SQL Server) JDBC driver was complaining about attempts to use various
objects after they had been closed (Connections, ResultSets and Statements).
In Query.execute() I think this bit should
) and there should be a performance increase. close() probably
doesn't need to be synchronized necessarily. (again, just guesses).
-Andy
On Mon, 2002-04-08 at 03:38, neil wrote:
I've been load testing my cocoon app with jmeter and I think I've found a
SQLTransformer bug.
My (MS SQL Server) JDBC driver
Hello
I have run into a problem using SQLTransformer in Cocoon 2.0 with Oracle 8.
1.7 and Tomcat 4.0.1 on Windows NT4 Service Pack 5.
Here is the datasource as defined in cocoon.xconf:
jdbc name=gtu-bridge
pool-controller min=5 max=10 oradb=true/
dburljdbc:oracle:thin
or a count of
updated rows.
The following patch attempts to jack up SQLTransformer v1.24 to handle these
multiple results. It works well enough for what I need, but has only been
tested with a MS SQL Server stored procedure that returns one ResultSet.
v1.24 is the most recent version before SQLTransformer
:
Subject: esql Vs SQLTransformer
01/18/2002
Hello,
Can anyone explain what are the advantages/disadvantages of using the esql
logicsheet as compared to the SQL transformer?
At the moment it seems to me that SQL transformer is better because you can
chain arbitrary sql transformers together where as esql can only be done in
the generate
Only possible with the version in 2.1 (HEAD branch).
Sven
-Original Message-
From: Lajos Moczar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 8:19 AM
To: [EMAIL PROTECTED]
Subject: [C2.0b1] Request parameters w/ SQLTransformer?
Hi again -
I've finally got
I've been trying to find out why SQLTransformer has empty result sets.
After various debug statements, I realized that the finally clause in
the execute() method of the Query object in SQLTransformer.java is
closing and releasing the connection after the query is executed. Does
anyone know
Check CVS version of transformer - IIRC this issue is already resolved.
Vadim
-Original Message-
From: Lajos Moczar [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 15:20
To: [EMAIL PROTECTED]
Subject: [C2.0/1] Error in SQLTransformer??
I've been trying to find out why
[..]
Furthermore I like that SQL Transformer uses prepared statements.
The only thing I don't like too much about SQL Transformer is
that I can
tweak really the element names of the generated output.
I don't know exactly what you mean, can you be more specific about this?
Yeah, I am
1 - 100 of 104 matches
Mail list logo