Re: caching proposals: SQLTransformer and Request

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 or anybody else follow up on this idea? NB: Caching of the request generator would p

RE: caching proposals: SQLTransformer and Request

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

RE: SQLTransformer bug

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 with it. It

Re: SQLTransformer bug

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 c

Re: SQLTransformer bug

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]

Re: SQLTransformer bug

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 statement get resultset close conn

SQLTransformer bug

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 creat

SQLTransformer

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 blah, blah... block. I am hitting the database over an SSH port-mapped link, so it is kind of slow. Sometimes my browser gets impatien

RE: SQLTransformer stored procedure question

> -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: > > >

SQLTransformer stored procedure question

I call an existing stored procedure with: begin qChange.R_IMS_CHANGE( 'ALZHEIMERS', '1999 Q3', 'NRX', ?); end; However, I get an "ORA-08103: object no longer exists error" at SQLTrans

Re: SQLTransformer modifications

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.

Re: SQLTransformer modifications

ing 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 of the data to be there, which we don

SQLTransformer modifications

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 o

Re: SQLtransformer repeats namespace

"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 > > > http://apache.org/cocoon/SQL/2.0";> > SQLTransformer Test >

RE: SQLtransformer repeats namespace

ginal Message- > From: 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 workin

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 to be run through an SQLTransformer http://apache.org/cocoon/SQL/2.0";> SQLTransformer Test http://apache.org/cocoon/SQL/2.0";>

Re: [2.0.4] SQLTransformer and j2ee vs. jdbc datasource

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 c

Re: [2.0.4] SQLTransformer and j2ee vs. jdbc datasource

"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

Re: [2.0.4] SQLTransformer and j2ee vs. jdbc datasource

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 libraries for J2EE datasources by default.

[2.0.4] SQLTransformer and j2ee vs. jdbc datasource

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 v

SQLTransformer for XML

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 < ,etc For example if my database contains SomeText the output Stream of my pipeline contains <title

Re: Problem SQLTransformer

| | cc: |

Réf:Re: Réf:RE: Problem SQLTransformer

RPB_ID -- -- 00427 00427 SQL> Séparateur de messages Objet : Re: Réf:RE: Problem SQLTransformer Auteur :[EMAIL PROTECTED] Date : 05/12/2002 14:10 "Rano, Didier" a écr

Re: Réf:RE: Problem SQLTransformer

"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 h

Réf:RE: Problem SQLTransformer

ier Rano Serv'N Data Séparateur de messages Objet : RE: Problem SQLTransformer Auteur :[EMAIL PROTECTED] Date : 05/12/2002 11:03 Didier, are you sure the rpb_id columns are not null ? If they were, that's the correct result. BTW, why the column name

RE: Problem SQLTransformer

ECTED] 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 SQLTransfor

Problem SQLTransformer

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: How solve this problem ? Thank you Didier Rano Serv'N

RE: Don't get XML tags with SQLTransformer

efix "esql" for element > "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 SQLTra

RE: Don't get XML tags with SQLTransformer

al 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. For example, using XSP: mp_pool

Re: Don't get XML tags with SQLTransformer

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 Nam

RE: Don't get XML tags with SQLTransformer

; Subject: Don't get XML 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="4"name=&qu

Re: Don't get XML tags with SQLTransformer

Hi! You can use another xsl or a generator to get this job done. For example, using XSP: mp_pool SELECT usr_id, usr_name, FROM users WHERE usr_enable=1

Don't get XML 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="4"name="name"> -<>   <>1  <>Max_pkg1 -<>   <>2   <>Max_pkg2 ... But how can I get the tags li

Re: Problems with substitute-value in SQLTransformer

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. > >

Re: Problems with substitute-value in SQLTransformer

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 J

Problems with substitute-value in SQLTransformer

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: (I later i

Re: ESQL DTD? (Was: SQLTransformer good, ESQL good!)

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: > > > > > > > > ... > > ... > > ... > > > > *WRONG* > > > In the Cocoon documentation

Re: ESQL DTD? (Was: SQLTransformer good, ESQL good!)

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... > > > A

ESQL DTD? (Was: SQLTransformer good, ESQL good!)

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-q

Re: SQLTransformer good, ESQL good!

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

RE: SQLTransformer good, ESQL good!

> 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.

Re: SQLTransformer good, ESQL bad

map? > > No only 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'

RE: SQLTransformer good, ESQL bad

> 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

Re: SQLTransformer good, ESQL bad

. > > 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 > ope

RE: SQLTransformer good, ESQL bad

y 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

Re: SQLTransformer good, ESQL bad

>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 state

SQLTransformer good, ESQL bad

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

RE: Problems with SQLTransformer

s too > 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 yo

Re: Problems with SQLTransformer

; > Or > > > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform";> > >hello > > > > The output is exactly the same! > > > 3) Have you ensured that any namespaces in use are not the problem? (the > > xsl is looking for but i

RE: Problems with SQLTransformer

> > 081778namepassdprogname > This looks like the "default" template for elements which just copies their value. As an experiment, try this: http://www.w3.org/1999/XSL/Transform";>

RE: Problems with SQLTransformer

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, b

RE: Problems with SQLTransformer

> -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

Re: Problems with SQLTransformer

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) > > > > > 081778 > > name > paswd > progname > > > > After the XSLTransform, the browser gives an error (because n

RE: Problems with SQLTransformer

> 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 >>

RE: Problems with SQLTransformer

- > -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 deserv

RE: Problems with SQLTransformer

g for but is finding ?) 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

Problems with SQLTransformer

> > PS: I believe, after so many problems, some day I will be able to answer > all the questions in this list ;-) May be a new Trivial Pursuit about > cocoon? That > > > On Thursday 08 August 2002 14:33, Vadim Gritsenko wrote: >> > From: Albert Cervera Areny [mailto:

RE: Strange SQLTransformer problem: Encoding bug in Cocoon 2?

> 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

Re: Strange SQLTransformer problem: Encoding bug in Cocoon 2?

the users-list... 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. > > > (2) this solution works, but is p

RE: Strange SQLTransformer problem: Encoding bug in Cocoon 2?

OTECTED]] > 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 ? > > >

when i use SQLTransformer, how to preserve the bank and CRLF of the data from database?

hello         when i use SQLTransformer, how to preserve the bank and  CRLF of the data from database?       thanks   ZhaiYun

problems with SQLTransformer

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 S

Re: SQLTransformer

jdbc:mysql://localhost/ccc aaa bbb According to the datasource configuration in cocoon.xconf, it should be pooling. The logs (core.log) seem to say its pooling: ApplicationServerThread/LogKitLogger: Got a org.apache.avalon.excalibur.datasource.JdbcConnection from the pool. ApplicationServerTh

Re: SQLTransformer

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 abou

Re: SQLTransformer

lso takes 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

Re: SQLTransformer

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,

Re: SQLTransformer

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. Maybe

RE: SQLTransformer

/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 lookin

SQLTransformer

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 130ms to complete. Combined there are about 20 rows being return

RE: Getting parameters to SQLTransformer

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: true getprod

RE: Getting parameters to SQLTransformer

> -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 &

Re: Getting parameters to SQLTransformer

>>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, but is there any way to construct dynamic >>queries using SQLTransfor

RE: Getting parameters to SQLTransformer

t; 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, but is there any way to construct dynamic > queries using SQLTransformer? Specifically, I'

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 attribute or a sitemap parameter. I've been thru the code and don't see that it can be done, bu

RE: SQLTransformer, multiple execute-query siblings?

> I presume there is scope for making a Transformer, which would make > hierarchycal rowsets from "flat" ones... anyone interested ? > > Best regards, > > - >Luca Morandini >GIS Consultant > [EMAIL PROTECTE

RE: SQLTransformer, multiple execute-query siblings?

p://utenti.tripod.it/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 e

RE: SQLTransformer, multiple execute-query siblings?

gt; 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 question has not already b

RE: SQLTransformer, multiple execute-query siblings?

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: http://apa

RE: SQLTransformer, multiple execute-query siblings?

index.html - > -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 -

Re: SQLTransformer, multiple execute-query siblings?

- 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: <[EM

RE: SQLTransformer, multiple execute-query siblings?

[EMAIL PROTECTED]] > 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: > > > > se

RE: SQLTransformer, multiple execute-query siblings?

#x27;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

Re: SQLTransformer, multiple execute-query siblings?

- 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

RE: SQLTransformer, multiple execute-query siblings?

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: Argy

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 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

SQLTransformer, multiple execute-query siblings?

Hi SQLers, If I understand the SQLTransformer code correctly, this construct is not supported: select A select B using values from select A in where clause select C using values from select A in where clause Can someone confirm this, and is there a workaround

SOLVED: SQLTransformer, AbstractMethodError in prepareStatement

tMethodError > 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:

SQLTransformer, AbstractMethodError in prepareStatement

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 org.apache.avalon.excalibur.datasource.Jdbc

known issues using SQLTransformer

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 the

RE: caching proposals: SQLTransformer and Request

Subject: RE: caching proposals: SQLTransformer and Request > > > > 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 convin

RE: caching proposals: SQLTransformer and Request

> 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 recom

RE: caching proposals: SQLTransformer and Request

ame one the pipeline knows it can skip over > everything. > > 2. 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

caching proposals: SQLTransformer and Request

lways re-done (and often there is some sql at the end of the pipe which is really slow). I'd like to hash (or MD5?) the request string and use that as the cache key so that if I get the same one the pipeline knows it can skip over everything. 2. Add caching to the SqlTransformer. I know t

Re: Problem with SQLTransformer and Encoding

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

Problem with SQLTransformer and Encoding

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 (inste

SQLTransformer returning empty XML tags

Hello, I'm using SQLTransformer to convert this simple piece of SQL: http://apache.org/cocoon/SQL/2.0";> http://apache.org/cocoon/SQL/2.0";> SELECT name FROM listing into XML file using this code from the DocBook XSLT that prints al

Re: SQLTransformer bug that appears under load

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 (M

SQLTransformer bug that appears under load

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

SQLTransformer NullPointerException with Oracle and

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:oracle:thin:@172.16.1.5:1521:gtu gtu gtu The system generates

patch to SQLTransformer for result sets returned from stored procedures

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

  1   2   >