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: we
SQL Transformer, part of xml doc in a database field.
What if one of the fields from a select statement
in an 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 rowse
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 con
> -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 mi
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
> -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
zip = ''
where library_id =
> -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 trans
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]
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,
Kon
thanks! i am so embarassed. ;-) i gazed right past that little
paragraph... sheesh!
-Original Message-
From: Luca Morandini
To: [EMAIL PROTECTED]
Sent: 3/18/03 1:15 AM
Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL update
table???)
Christopher,
IIUC, you need
AIL PROTECTED]' '
> Subject: 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? --c
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 u
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
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
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)
http://www.w3.org/1999/XSL/Transform";
xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
SELECT * FROM foo
> > Sent: Tuesday, March 11, 2003 7:23 PM
> > To: cocoon
> > Subject: Accessing nrofrows from SQL Transformer
> within Stylesheet
> >
> >
>
> >
> > My stylesheet snippet is:
> >
> >
> >
> >
> >
> >
> -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:
>
>
>
>
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:
http://apache.org/cocoon/SQL/2.0";
n
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 : coc
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
Hi,
I have a problem with a pipeline :
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
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-el
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 =
this is how mine look ...
And you do not use the sql namespace on the substitue-value element
(sql:substitue-value sql:name=".
Jeremy Quinn wrote:
>
> SELECT DISTINCT contributor_id, name FROM foo WHERE
> 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 default namespace
set to sql?
Carsten
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!
> -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 2
On Thu, 16 Jan 2003, Carsten Ziegeler wrote:
> I'm not sure, but I guess you have to use the sql namespace
> for the substitute-value element as well:
>
Oh man, it's ALWAYS a simple solution. Thanks! Patch for docs sent to
bugzilla and cocoon-dev, and I've added &q
2 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 r
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:
http://apache.org/cocoo
sorry, just noticed you were talking about sql transformer - i had assumed
esql logicsheet in xsp. i need more coffee.
try
...
then, your results should start off with an attribute nrofrows on rowset,
ie:
http://apache.org/cocoon/SQL/2.0";>
Geoff
-
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 w
er 13, 2002
9:45 AMTo: [EMAIL PROTECTED]Subject:
SQL-Transformer
Hallo Cocoon Users,
does the SQL-Transformer has a map-parameter like
or is there a way to retrieve
the number of cols in the resultset?
Regards
Boris
Hallo Cocoon Users,
does the SQL-Transformer has a map-parameter like
or is there a way to retrieve the
number of cols in the resultset?
Regards
Boris
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:
http
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
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.:
java.lang.Null
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.SAXParseE
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 logics
://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 + Fil
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 + Fil
Adding this line to the stylesheet fixes the bug.
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
inspected using a view
n like a charm :-s
>
> I 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]
&
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:
java.lang.ArrayIndexOutOfBoundsException
[EMAIL PROTECTED]
> 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...
>
>
> http://apache.org/cocoon/
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...
http://apache.org/cocoon/SQL/2.0";>
pool-TAL
nformation (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
onden: vrijdag 30 augustus 2002 13:03
> Aan: [EMAIL PROTECTED]
> Onderwerp: 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
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 transform
-
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 7:34 PM
> To: [EMAIL PROTECTED]
> Subject: Generic SQL transformer output
>
>
>
> Dear All,
>
> I'm trying to implement a
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 insert/update/el
JDK 1.3.1
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:
http://www.w3.or
Thanks for all the answers I agree all the people the help.
Salu2, Jeronimo Molina
-Mensaje original-
De: Bert Van Kets [mailto:[EMAIL PROTECTED]]
Enviado el: jueves, 11 de abril de 2002 22:27
Para: [EMAIL PROTECTED]
Asunto: Re: please, please, ... help with SQL transformer
I did
I did tests with access databases once using the JdbcOdbc bridge. I had
connection errors all over and I could track it to the single connection
nature of Access. The first connection went through (the authentication),
but the second and following connections always failed. I have dumped
Ac
Aitziber Zubieta wrote:
> I will be very glad if you have any other idea.
Hi,
I have also tried to use the SQL transformer to access an Access database --
without luck.
I always got an empty result set.
I finally gave up to track down the problem and switched to ESQL which works
just f
2002 8:49 AM
Subject: RE: please, 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-
[mailto:[EMAIL PROTECTED]]
Date: mercredi, 10. avril 2002 16:57
À: [EMAIL PROTECTED]
Objet: 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 transform
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 ORACLE
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 tr
and the db won´t be updated.
>
> I tried a simple xml file -(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
xml code.
Could anyone help me to insert data using sql
transformer without a nullpointer exception
Markus
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 transformer. It doesn't
work , says: "ORA-00933: SQL command not properly ended "
-
I want to put two subqueries in xml file for sql transformer. It doesn't
work , says: "ORA-00933: SQL command not properly ended "
XML file is here:
=
http://apache.org/cocoon/SQL/2.0";>
Hello
This is my first Cocoon2 page filled with sql data from PL
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
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
s
uary 27, 2002 12:56 PM
To: [EMAIL PROTECTED]
Subject: RE: [C2] Bug in SQL transformer?
Harald,
bottom line is: the problem lies in the stylesheet.
I don't think is a good idea splitting the template "@*|node()", since the
first half extracts only attributes, while the second half onl
nal Message-
> From: 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!!
>
> No
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
://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?
&g
gt; Subject: Re: [C2] Bug 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 (
inal Message-
> From: Luca 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 lo
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
> Sent: Tuesday, 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.
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 o
Hello,
If I use cocoon2 with MySQL (and a proper jdbc driver) the
following way, everything works well:
_but_ if I want to use it the other way, I only
get a NullPointerException :-(
So, the pre_sql_process.xsl is proper, but the
the sql-transformer get's a NullPo
,
> Mariano
>
> On Thursday 28 June 2001 02:49 pm, you wrote:
> > > Mariano Kamp wrote:
> > > Von: Mariano Kamp [mailto:[EMAIL PROTECTED]]
> > > Gesendet: Donnerstag, 28. Juni 2001 14:36
> > > An: [EMAIL PROTECTED]
> > > Betreff: [C2] Postgres w
ge-
> 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 with postgress, but postgres throws an exeption that
> prepareStatemen
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
er 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 tri
t; Gesendet: Donnerstag, 28. Juni 2001 14: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 supp
> Mariano Kamp wrote:
> Von: Mariano Kamp [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 28. Juni 2001 14:36
> An: [EMAIL PROTECTED]
> Betreff: [C2] Postgres with SQL - Transformer
>
>
> Hi there,
>
> I tried C2 with postgress, but postgres throws an exeptio
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
81 matches
Mail list logo
