SQL Transformer/Resin broken?

Hi All, I'm having problems trying to use something under Caucho Resin that works perfectly fine under Tomcat: SQL Transformer in Cocoon 2.0.4 deployed under Resin 2.1.8/10(same result) trying to query Oracle 8i. Both Tomcat 4.0.6 and Resin 2.1.8 use the exact same settings (see below: web.xml

SQL Transformer, part of xml doc in a database field.

SQL Transformer, part of xml doc in a database field. What if one of the fields from a select statement in an sql:query has a text field that contains a valid xml document. All the '' and '' characters get escaped, I would like the xml in this field to be part of the rowset as valid xml, any

Mysql and sql transformer

Hi all, I've got a problem with mysql (on win or linux) and sql transformer. I've followed the instruction on the cocoon wiki about how to set-up mysql jdbc drivers, I've set up a simple pipeline with a really simple query, but the result is always the same: Failed to obtain connection. Made 5

Re: SQL Transformer or ESQL Stylesheet?

Konlin wrote: Hello Cocoon! Can you write me any clues when to use sql transformer and when esql stylesheet? What is more flexible, easier, more professional etc? I'm going to write simple news portal with Xindice or MySQL as DBMS and I'm wondering what solution is better. Greetz, Konrad Inglot

Re: SQL Transformer or ESQL Stylesheet?

Hi, On Tue, 18 Mar 2003, Scherler wrote: Konlin wrote: Can you write me any clues when to use sql transformer and when esql stylesheet? I have ask that question before but with no answer! My personal opinion is that you should use the SQL-transform [a] for simple Queries where you do

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

/' where library_id = xsl:value-of select=/library/id/ /sql:query /sql:execute-query -Original Message- From: Delis, Christopher E. [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 4:08 AM To: 'Luca Morandini '; '[EMAIL PROTECTED] ' Subject: RE: sql transformer

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

-Original Message- From: Delis, Christopher E. [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 5:18 PM To: '[EMAIL PROTECTED]'; 'Luca Morandini ' Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???) sitemap). has anyone else run

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

do you mind sharing the template? =-) --chris -Original Message- From: Luca Morandini [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???) -Original

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

-Original Message- From: Delis, Christopher E. [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 6:32 PM To: '[EMAIL PROTECTED]' Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???) do you mind sharing the template? =-) --chris

SQL Transformer or ESQL Stylesheet?

Hello Cocoon! Can you write me any clues when to use sql transformer and when esql stylesheet? What is more flexible, easier, more professional etc? I'm going to write simple news portal with Xindice or MySQL as DBMS and I'm wondering what solution is better. Greetz, Konrad Inglot -- [EMAIL

SQL Transformer or ESQL Stylesheet?

Hello Cocoon! Can you write me any clues when to use sql transformer and when esql stylesheet? What is more flexible, easier, more professional etc? I'm going to write simple news portal with Xindice or MySQL as DBMS and I'm wondering what solution is better. Greetz, Konrad Inglot -- [EMAIL

sql transformer question; *not* esql... (was RE: ???ESQL update table???)

i replied to the wrong topic. sorry... what i meant to ask was: is there a place-holder mechanism available using the sql transformer? --chris -Original Message- From: Delis, Christopher E. To: '[EMAIL PROTECTED]' Sent: 3/17/03 9:48 AM Subject: RE: ???ESQL update table

RE: sql transformer question; *not* esql... (was RE: ???ESQL update table???)

transformer question; *not* esql... (was RE: ???ESQL update table???) i replied to the wrong topic. sorry... what i meant to ask was: is there a place-holder mechanism available using the sql transformer? --chris -Original Message- From: Delis, Christopher E. To: '[EMAIL PROTECTED

SOLUTION: double namespace attribute in SQL Transformer

Here is the solution that I believe Charles was suggesting (for those who are as XML inept as I, it is nice to have this in black and white) ?xml version=1.0? xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xmlns:sql=http://apache.org/cocoon/SQL/2.0; xsl:template

Accessing nrofrows from SQL Transformer within Stylesheet

Hello, I can't seem to access the nrofrows value returned from the SQL Transformer. The resulting XML after the SQL Transformer executes in my pipeline is as follows: records rowset xmlns=http://apache.org/cocoon/SQL/2.0; nrofrows=4 row ... /row row ... /row

RE: Accessing nrofrows from SQL Transformer within Stylesheet

-Original Message- From: Samuel Bruce [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 7:23 PM To: cocoon Subject: Accessing nrofrows from SQL Transformer within Stylesheet My stylesheet snippet is: xsl:template match=records NumberOfRows xsl:value-of select

RE: Accessing nrofrows from SQL Transformer within Stylesheet

11, 2003 7:23 PM To: cocoon Subject: Accessing nrofrows from SQL Transformer within Stylesheet My stylesheet snippet is: xsl:template match=records NumberOfRows xsl:value-of select=sql:rowset/@nrofrows/ /NumberOfRows /xsl:template I have no problem accessing

Re: Problem with SQL Transformer[Sol]

Martin Holz wrote: Cedric Claus [EMAIL PROTECTED] writes: This pipeline doesn't work : After SQL transformation the sort and replace.xsl does wrong. But if I copy the xml result of the SQL transform and then apply the same xsl , no problem (with xalan and MSXML) My configuration :

Problem with SQL Transformer

Hi, I have a problem with a pipeline : map:match pattern=AOS/page1.html map:generate src=xml/page1.xml/ map:transform type=sql/ map:transform type=xslt src=xsl/SortAndReplace.xsl/ map:transform type=xslt src=xsl/HAbstract.xsl/ map:serialize/ /map:match This pipeline doesn't work : After

Re: Problem with SQL Transformer

Cedric Claus [EMAIL PROTECTED] writes: This pipeline doesn't work : After SQL transformation the sort and replace.xsl does wrong. But if I copy the xml result of the SQL transform and then apply the same xsl , no problem (with xalan and MSXML) My configuration : cocoon 2.0 - tomcat

Strange results: SQL Transformer - Other Transformer - XML-Serializer

Hi, for sure I do somthing wrong, because nobody seems to report similar problems. But I just can't find the error. I would like to transform SQL Transformer output to another XML using the Identity Transformation (I guess this is the right word). Problem: the attributes in the rowset-element

Re: SQL Transformer substitute-value woes with 2.0.4

On Thursday, Jan 16, 2003, at 12:21 Europe/London, Andrew Savory wrote: Hi, As far as I can tell, using substitute-value with SQL Transformer does not work in 2.0.4 (and there aren't any examples of it in the samples, something I'll rectify if I ever get the darn thing working!). Here's

RE: SQL Transformer substitute-value woes with 2.0.4

Jeremy Quinn wrote: SELECT DISTINCT contributor_id, name FROM foo WHERE contributor_id = substitute-value sql:name=contributor_id/ this is how mine look ... And you do not use the sql namespace on the substitue-value element (sql:substitue-value sql:name=.../) or have the

Re: SQL Transformer substitute-value woes with 2.0.4

On Friday, Jan 17, 2003, at 10:04 Europe/London, Carsten Ziegeler wrote: Jeremy Quinn wrote: SELECT DISTINCT contributor_id, name FROM foo WHERE contributor_id = substitute-value sql:name=contributor_id/ this is how mine look ... And you do not use the sql namespace on the

SQL Transformer substitute-value woes with 2.0.4

Hi, As far as I can tell, using substitute-value with SQL Transformer does not work in 2.0.4 (and there aren't any examples of it in the samples, something I'll rectify if I ever get the darn thing working!). Here's what I've got: test.xml: ?xml version=1.0 encoding=iso-8859-1? page

RE: SQL Transformer substitute-value woes with 2.0.4

, January 16, 2003 1:22 PM To: [EMAIL PROTECTED] Subject: SQL Transformer substitute-value woes with 2.0.4 Hi, As far as I can tell, using substitute-value with SQL Transformer does not work in 2.0.4 (and there aren't any examples of it in the samples, something I'll rectify if I ever get

RE: SQL Transformer substitute-value woes with 2.0.4

, and I've added create an SQL transformer sample to my to-do for the weekend ;-) Andrew. -- Andrew SavoryEmail: [EMAIL PROTECTED] Managing Director Tel: +44 (0)870 741 6658 Luminas Internet Applications Fax: +44 (0)700 598

RE: SQL Transformer substitute-value woes with 2.0.4

-Original Message- From: Andrew Savory [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew Savory Sent: Thursday, January 16, 2003 1:51 PM To: [EMAIL PROTECTED] Subject: RE: SQL Transformer substitute-value woes with 2.0.4 On Thu, 16 Jan 2003, Carsten Ziegeler wrote: I'm not sure

SQL-Transformer

Hallo Cocoon Users, does the SQL-Transformer has a map-parameter like map:parameter name="show-nr-of-cols"/ or is there a way to retrieve the number of cols in the resultset? Regards Boris

RE: SQL-Transformer

, 2002 9:45 AMTo: [EMAIL PROTECTED]Subject: SQL-Transformer Hallo Cocoon Users, does the SQL-Transformer has a map-parameter like map:parameter name="show-nr-of-cols"/ or is there a way to retrieve the number of cols in the resultset? Regards Boris

Re: SQL-Transformer

mysql - Original Message - From: Geoff Howard To: [EMAIL PROTECTED] Sent: Friday, December 13, 2002 4:19 PM Subject: RE: SQL-Transformer There is a tag defined but it's not fully implemented, although it may be in the very latest cvs. (it only worked

RE: SQL-Transformer

sorry, just noticed you were talking about sql transformer - i had assumed esql logicsheet in xsp. i need more coffee. try map:transform type=sql ... map:parameter name=show-nr-of-rows value=true/ /map:transform then, your results should start off with an attribute

Cocoon-2.0.4 possible bug in Sql transformer

Cocoon-2.0.4 seems to repeat namespace declaration in the sql:rowset element resulting from a sql transformation launching a stored procedure. I have cocoon 2.0.3 and cocoon 2.0.4 side by side on the same machine. I call an Oracle stored procedure with SQL transformer With this code: execute

xInclude and SQL Transformer NullPointerException

I experience the following problem: I am including fragments of another xml file using xinclude and the xpointer() syntax. Works fine. If I then want to use the SQLTransformer within the same pipeline, I get a org.apache.cocoon.ProcessingException: Failed to execute pipeline.:

Re: xInclude and SQL Transformer NullPointerException

I had a similar problem. When I used the XInclude transformer, I got a NullPointerException when I tried to refer to the results with the cocoon:/ protocol. Here was my solution (bad hack, but it worked): I made a stylesheet copy-of.xsl that simply copied what it was passed without changing it.

Action + Sql Transformer

I've been out of luck trying to get samples to work for Actions and SQL Transformer. For the sample Action I am receiving a: org.apache.cocoon.ProcessingException: The prefix xsp-request for element xsp-request:get-attribute is not bound.: org.xml.sax.SAXParseException: The prefix xsp-request

Re: pipeline or sql transformer problem

I had a similar namespace problem with SQLTransformer. I switched from Xalan to Saxon 6.5.2 (because of multi-thread issues with database XA transactions) for xslt transformations and the problem seems to be gone. Michael Maluck [EMAIL PROTECTED] wrote: Now I tried it with esql and a

RES: SQL Transformer with nested query + Filter Transformer = ArrayIndexOutOfBoundsException exception

Any ideas? Thanks, Igor -Original message- From: Igor Abade V. Leite [mailto:[EMAIL PROTECTED]] Data: sexta-feira, 30 de agosto de 2002 11:59 To: [EMAIL PROTECTED] Subject: SQL Transformer with nested query + Filter Transformer

RE: SQL Transformer with nested query + Filter Transformer = ArrayIndexOutOfBoundsException exception

://utenti.tripod.it/lmorandini/index.html - -Original Message- From: Igor Abade V. Leite [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 2:04 PM To: [EMAIL PROTECTED] Subject: RES: SQL Transformer with nested query + Filter Transformer

[SUMMARY] problems generating input to sql transformer with stylesheet (a la Langham Ziegeler book)

Adding this line to the stylesheet fixes the bug. xsl:output method=text/ In fact the problem turned out to have absolutely nothing to do with the sql transformer; the problem was earlier in the pipeline but was masked because the xml piped into the transformer appeared okay when

problems generating input to sql transformer with stylesheet (a la Langham Ziegeler book)

I'm having real problems doing a trivial tranformation (in the style of Matthew and Carsten's excellent book). I generate xml which then gets transformed by the sql transformer. Unfortunately, it only works if I have no containing elements in the input to the transformer. I'm guessing its

RE: problems generating input to sql transformer with stylesheet (a la Langham Ziegeler book)

this is exactly the same approach you would take to generate fo, for example. Koen. -Oorspronkelijk bericht- Van: Simon Price [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 30 augustus 2002 13:03 Aan: [EMAIL PROTECTED] Onderwerp: problems generating input to sql transformer

Re: problems generating input to sql transformer with stylesheet (a la Langham Ziegeler book)

(in the style of Matthew and Carsten's excellent book). I generate xml which then gets transformed by the sql transformer. Unfortunately, it only works if I have no containing elements in the input to the transformer. I'm guessing its related to the namespace? Or is it a bug in the sql transformer? Any

Re: problems generating input to sql transformer with stylesheet (a la Langham Ziegeler book)

of works but, for some reason, the rowset, row and column name tags get omitted by the sql transformer!!! In case it helps anyone say why this is, here's the intermediate xml from the stylesheet, before it goes into the sql transformer... ?xml version=1.0 encoding=UTF-8? user xmlns:sql=http

RE: problems generating input to sql transformer with stylesheet (a la Langham Ziegeler book)

] Onderwerp: Re: problems generating input to sql transformer with stylesheet (a la Langham Ziegeler book) Koen, thanks but I already tried this. The resultant xml using your stylesheet is... ?xml version=1.0 encoding=UTF-8? user xmlns:xmlns:sql=http://apache.org/cocoon/SQL/2.0; xmlns=http

SQL Transformer with nested query + Filter Transformer = ArrayIndexOutOfBoundsException exception

Hi again! When I use the SQL Transformer with a single table, everything goes fine. I can apply the Filter Transformer and I'll achieve the desired results. But when I use a nested query, I get the following error: log java.lang.ArrayIndexOutOfBoundsException

Re: problems generating input to sql transformer with stylesheet (a la Langham Ziegeler book)

must say I'm running tomcat 4.0.4, cocoon 2.0.3 on java 1.4.0... Koen -Oorspronkelijk bericht- Van: Simon Price [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 30 augustus 2002 14:53 Aan: [EMAIL PROTECTED] Onderwerp: Re: problems generating input to sql transformer with stylesheet (a la

Generic SQL transformer output

Dear All, I'm trying to implement a set of XSP sheets to manage administrative records in a database. This merely means implementing insert, update and delete for records in a number of different tables. Naturally, I'm striving for a generic solution so that I can use the same

Empty Rows Using SQL Transformer

Solaris 8 I am using the SQL transformer, which up to now has been performing wonderfully. I moved my WAR to a new (but identical as far as I can tell) machine, and now my database results come back as empty, but I get the right amount of rows back. Example transformer: xsl:stylesheet version=1.0

RE: please, please, ... help with SQL transformer

front-end application? E.g. a small Java program,just to see if it works. Regards Kurt -Message d'origine- De: Jerónimo Molina [mailto:[EMAIL PROTECTED]] Date: mercredi, 10. avril 2002 16:57 À: [EMAIL PROTECTED] Objet: please, please, ... help with SQL transformer Hi all (sorry for my

Re: please, please, ... help with SQL transformer

, please, ... help with SQL transformer Since nobody else answered, I'll give it a try. I don't know how that works with Access, but your datasource declaration seems incomplete. E.g. here's mine (of course it looks differently because your using JDBC-ODCB for Access, whereas with Oracle, there's

[XSL] please, help with SQL transformer

Hi all (sorry for my poor english): My name's Aitziber, and I'm neby with cocoon. I'm trying to work with SQL transformers, for generate an HTML page with data stored in a ACCESS database on my machine (it's my first work with cocoon, so I don't want to do this with ORACLE any other DB). I'm

please, please, ... help with SQL transformer

Hi all (sorry for my poor english): My name's Jeronimo Molina, and I'm neby with cocoon. I'm trying to work with SQL transformers, for generate an HTML page with data stored in a ACCESS database on my machine (it's my first work with cocoon, so I don't want to do this with

Re: Sql Transformer

-(insert into mytable Values ('aa')) and chose the xml serializer-but my browser couldn´t display the xml code.   Could anyone help me to insert data using sql transformer without a nullpointer exception   Markus - Please

Sql Transformer

anyone help me to insert data using sql transformer without a nullpointer exception Markus

RE: two subqueries in sql transformer xml

=component ... /query /execute-query /execute-query thanx! -Original Message- From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 12:52 PM To: '[EMAIL PROTECTED]' Subject: two subqueries in sql transformer xml I want to put two subqueries in xml file for sql

SQL Transformer after XSL with copy-of

Hi, I have a problem with SQL transformer and XSL copy-of tag. I already read something similar in the mail archive but I didn't understand if the problem has a solution. I set up a simple test case for the problem, this is the recipe: you need an xml source file (copy.xml) like

Cocoon 2.0 and SQL transformer sample does'nt work with Postgresql 6.5 and JK 1.3

In Cocoon 2.0 Sample, The SQL transformer sample does'nt work but esql samples is OK. I have the error : Error creating the resource Could not read resource file:/app/java/jakarta-tomcat-3.3/webapps/cocoon/docs/samples/sql/sql-page.xml details from source

RE: [C2] Bug in SQL transformer?

: SunnyDay [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 26, 2002 6:10 PM To: [EMAIL PROTECTED] Subject: Re: [C2] Bug in SQL transformer? Hi Luca, the clean machine does the same - but only if I access my ORACLE-DB!! Now I commented out the line in the stylesheet which Grant

Re: [C2] Bug in SQL transformer?

Hi Luca, the clean machine does the same - but only if I access my ORACLE-DB!! Now I commented out the line in the stylesheet which Grant (the originator of this thread - you remember ;) mentioned - and it worked - no exception no error page ... I decided to split the line from xsl:template

[C2] Bug in SQL transformer?

Hello, I've been trying to use the SQL transformer. However, if it comes after an XSLT transformer in the pipeline it always throws an error. If I use the output of the XSLT step as the hardcoded input from a generate step (e.g. file generator) then it works fine. The crash happens whether

RE: [C2] Bug in SQL transformer?

, January 22, 2002 1:15 PM To: '[EMAIL PROTECTED]' Subject: [C2] Bug in SQL transformer? Hello, I've been trying to use the SQL transformer. However, if it comes after an XSLT transformer in the pipeline it always throws an error. If I use the output of the XSLT step as the hardcoded input from

RE: [C2] Bug in SQL transformer?

Ok, it turns out this is to do with copying in the xsl before the sql transformer. If I copy a node then the sql transform fails. If, in XSL, I match and output the same thing as the copy would have done(in other words, a hardcoded/manual copy) then it works fine. Is there something special about

Re: [C2] Bug in SQL transformer?

Morandini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:09 PM To: [EMAIL PROTECTED] Subject: RE: [C2] Bug in SQL transformer? Grant, I'd suggest to take a look at the cocoon.log, which contains a lot of information about errors. Aanyway, I've used SQLTransformer after

RE: [C2] Bug in SQL transformer?

in SQL transformer? Hi, I had a little fight with the transformer on sunday. I tried to use a SP and it always faild. So I inserted some debug-statements and it did not realy looked like a SQLTransformer - Problem! What I did (after hourless banging my head against the wall): I ... (1

RE: [C2] Bug in SQL transformer?

://utenti.tripod.it/lmorandini/index.html - -Original Message- From: Miller, Grant [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 6:20 PM To: '[EMAIL PROTECTED]' Subject: RE: [C2] Bug in SQL transformer? Ok, it turns out this is to do

Problems with XSLT-Transformer + SQL-Transformer on Cocoon2

/html.xsl/ map:serialize type=html/ So, the pre_sql_process.xsl is proper, but the the sql-transformer get's a NullPointer. Something's is gone wrong with the Chain from the XSLT-Tranformer to the SQL-Transformer. What do I have to do within the sitemap.xmap or the stylesheet to get this chain work? I

RE: AW: [C2] Postgres with SQL - Transformer

Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 3:08 PM To: [EMAIL PROTECTED] Subject: Re: AW: [C2] Postgres with SQL - Transformer Hallo Carsten, thanks for answering my question and sorry for not being more specific in first place. Yes I am using connection pooling

Re: [C2] Postgres with SQL - Transformer

: [C2] Postgres with SQL - Transformer Hi there, I tried C2 with postgress, but postgres throws an exeption that prepareStatement() is not supported yet ;-( Is there any way to tell the SQL-Transformer not to prepare the Statements and use dynamic sql instead? Mariano

Re: AW: [C2] Postgres with SQL - Transformer

, i certainly recommend mysql. I use the following jdbc driver: http://mmmysql.sourceforge.net/ Sven -Original Message- From: Mariano Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 3:08 PM To: [EMAIL PROTECTED] Subject: Re: AW: [C2] Postgres with SQL - Transformer

[C2] Postgres with SQL - Transformer

Hi there, I tried C2 with postgress, but postgres throws an exeption that prepareStatement() is not supported yet ;-( Is there any way to tell the SQL-Transformer not to prepare the Statements and use dynamic sql instead? Mariano

Re: AW: [C2] Postgres with SQL - Transformer

:36 An: [EMAIL PROTECTED] Betreff: [C2] Postgres with SQL - Transformer Hi there, I tried C2 with postgress, but postgres throws an exeption that prepareStatement() is not supported yet ;-( Is there any way to tell the SQL-Transformer not to prepare the Statements and use dynamic

RE: [C2] Postgres with SQL - Transformer

in the cocoon_20_branch still uses createStatement(), maybe you can use this one for now. Sven -Original Message- From: Mariano Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: [C2] Postgres with SQL - Transformer Hi there, I tried C2