sql

[Gerogi Danov <gd...@comsoft.bg>]

Hello everybody
	I've got cocoon up and running, and it's very good.
	In the documentation about the SQL processor is not stated clear, but I
have the feeling that it is capable of executing only queries . Does it mean
that statements like "update xxx set yyy=zzz" can't be executed. I tried
this with oracle 8.1.6, using thin driver, but it says "statement not
terminated correctly", and looking at the exception,I see the jdbc is
executing query.

Re: sql

[Donald Ball <ba...@webslingerZ.com>]

On Tue, 29 Aug 2000, Nicola Ken Barozzi wrote:

> Hey Donald, how come you keep saying about processor deprecation in
> the list and then put a very nicely written (at least from the coding
> style, I learned a lot reading your SAX code, very, very clear! :-) )
> SQLTransformer in C2? ;-)

that sql transformer was written in furious hour or two just after pier
gave his cocoon2 talk at apachecon, just so i could learn a little bit of
SAX and try to give pier some feedback on the c2 architecture. it compiled
but i never tested it. no one was more surprised than i when giacomo found
it in the repository and made it work with two minor changes. :) anyway,
the xsp processor was a distant dream for c2 at that time, so i figured
i'd just play around with a sql transformer in the meantime.

i'm glad my sax code was clear, though i think i owe more to the elegance
of the api itself than to my deep understanding of it - my sax exposure
was measured in hours at that point. :)

- donald

Re: sql

[Nicola Ken Barozzi <ni...@supereva.it>]

----- Original Message -----
From: "dima" <di...@merlin.octarine.net>

BTW, in Cocoon 1.8-dev in SQL taglib you read:
<
update-rows-attribute - The name of the attribute of the result doc element whose value will contain the actual number of rows
updated (if this query was not a SELECT).
>
which implies that update can be done.

It seems that Donald regards the processor to be deprecated in favor
of the taglib, maybe better starting using that?

Hey Donald, how come you keep saying about processor deprecation in
the list and then put a very nicely written
(at least from the coding style, I learned a lot reading your SAX code, very,
very clear! :-) ) SQLTransformer in C2? ;-)

nicola_ken

>
> That can't be right. SQL Processor runs all sorts of stuff (select, insert
> or update). It's most probably something about your syntax, be a bit more
> specific.
>
> cheers,
> d.
>
> On Tue, 29 Aug 2000, Gerogi Danov wrote:
>
> > Hello everybody
> > I've got cocoon up and running, and it's very good.
> > In the documentation about the SQL processor is not stated clear, but I
> > have the feeling that it is capable of executing only queries . Does it mean
> > that statements like "update xxx set yyy=zzz" can't be executed. I tried
> > this with oracle 8.1.6, using thin driver, but it says "statement not
> > terminated correctly", and looking at the exception,I see the jdbc is
> > executing query.
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> > For additional commands, e-mail: cocoon-users-help@xml.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>

Re: sql

[dima <di...@merlin.octarine.net>]

That can't be right. SQL Processor runs all sorts of stuff (select, insert
or update). It's most probably something about your syntax, be a bit more
specific.

cheers,
d.

On Tue, 29 Aug 2000, Gerogi Danov wrote:

> Hello everybody
> 	I've got cocoon up and running, and it's very good.
> 	In the documentation about the SQL processor is not stated clear, but I
> have the feeling that it is capable of executing only queries . Does it mean
> that statements like "update xxx set yyy=zzz" can't be executed. I tried
> this with oracle 8.1.6, using thin driver, but it says "statement not
> terminated correctly", and looking at the exception,I see the jdbc is
> executing query.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>