You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Russell Castagnaro <ru...@4charity.com> on 2002/04/05 00:56:09 UTC
Cocoon 1.82 + CLOBs + Oracle + esql
Aloha cocoon-users,
I've had a hell of a time getting cocoon 1.82 and the esql taglib to
pull XML data stored in CLOB fields from Oracle 8.1.7 (using the
thin Oracle driver)
I decided to fix it, and happily all I had to do was add a few things
to the esql.xsl file under src.
In the event anyone needs this (and in hopes that maybe the existing
1.82 release download might be changed to include this, since Cocoon
2 is all the craze now) I've attached the esql.xsl file to this
email.
If Cocoon 2 needs this support, its easy enough to put it in.
Why do I use 1.82 instead of the newer version? It comes down to
simplicity. We have existing J2EE applications (many webapps) that
really benefit from the xml generation and transformation
capabilities in cocoon, but C2 is an entire framework, that as far
as I can see, is much more difficult to integrate with an existing
application (Using jsp, servlets, ejbs and jms).
Of course, if anyone has examples of C2 working well with a pretty
extensive webapp, I'd LOVE to be proven wrong.
--
Mahalo,
Russell mailto:russell@4charity.com
Distinguished Engineer
I'm hopeful. I know there is a lot of ambition in Washington,
obviously. But I hope the ambitious realize that they are more likely
to succeed with success as opposed to failure.
- George W. Bush
RE: Cocoon 1.82 + CLOBs + Oracle + esql
Posted by Vadim Gritsenko <va...@verizon.net>.
> From: Russell Castagnaro [mailto:russell@4charity.com]
>
> Aloha cocoon-users,
<skip/>
> Why do I use 1.82 instead of the newer version? It comes down to
> simplicity. We have existing J2EE applications (many webapps) that
> really benefit from the xml generation and transformation
> capabilities in cocoon, but C2 is an entire framework, that as far
> as I can see, is much more difficult to integrate with an existing
> application (Using jsp, servlets, ejbs and jms).
In short:
Cocoon 2 is a *servlet*, with lots of supporting libraries and some
configuration files; and servlets are part of the J2EE architecture.
This means, C2 is J2EE compatible out of the box; it may just take some
time to figure out how to set your J2EE application with the C2 in the
way which is best for you.
Vadim
>
> Of course, if anyone has examples of C2 working well with a pretty
> extensive webapp, I'd LOVE to be proven wrong.
>
>
> --
> Mahalo,
> Russell mailto:russell@4charity.com
> Distinguished Engineer
>
> I'm hopeful. I know there is a lot of ambition in Washington,
> obviously. But I hope the ambitious realize that they are more likely
> to succeed with success as opposed to failure.
>
> - George W. Bush
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re[2]: Cocoon 1.82 + CLOBs + Oracle + esql
Posted by Russell Castagnaro <ru...@castagnaro.com>.
Hello Andreas,
We are using the Oracle CLOBs because we can also use Oracle Text
(Intermedia) to do xpath type searches in the XML data it contains.
However, I can absolutely see a benefit to compressing the data in
many cases.
Open Source WOO WOO!
Thursday, April 4, 2002, 10:58:22 PM, you wrote:
AK> Hi Russell ,
>> I've had a hell of a time getting cocoon 1.82 and the esql taglib to
>> pull XML data stored in CLOB fields from Oracle 8.1.7 (using the
>> thin Oracle driver)
>>
>> I decided to fix it, and happily all I had to do was add a few things
>> to the esql.xsl file under src.
AK> thank you for your effort !
AK> Ja, I truely need *LOB-Support. Thank you !
AK> Furthermore I have to zip the XML data, there is giant redundancy in it ...
AK> If I'll succeed, I going to give it back.
AK> Does anyone uses the LONGVARBINARY type ? I would prefer it because of the lack of
AK> transactionality with *LOB types.
AK> Greetings from Germany
AK> Andreas Kuehne
AK> __________________________________________________
AK> Do You Yahoo!?
AK> Yahoo! Tax Center - online filing with TurboTax
AK> http://taxes.yahoo.com/
AK> ---------------------------------------------------------------------
AK> Please check that your question has not already been answered in the
AK> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
AK> To unsubscribe, e-mail: <co...@xml.apache.org>
AK> For additional commands, e-mail: <co...@xml.apache.org>
--
Best regards,
Russell mailto:russell@castagnaro.com
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Cocoon 1.82 + CLOBs + Oracle + esql
Posted by Andreas Kuehne <ak...@yahoo.com>.
Hi Russell ,
> I've had a hell of a time getting cocoon 1.82 and the esql taglib to
> pull XML data stored in CLOB fields from Oracle 8.1.7 (using the
> thin Oracle driver)
>
> I decided to fix it, and happily all I had to do was add a few things
> to the esql.xsl file under src.
thank you for your effort !
Ja, I truely need *LOB-Support. Thank you !
Furthermore I have to zip the XML data, there is giant redundancy in it ...
If I'll succeed, I going to give it back.
Does anyone uses the LONGVARBINARY type ? I would prefer it because of the lack of
transactionality with *LOB types.
Greetings from Germany
Andreas Kuehne
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>