Ugo Cei wrote:
> Majcen, Kurt wrote:
>
>> Hi all!
>>
>> I'm rather new with Cocoon but I think I've got a somehow tricky
>> question:
>>
>> In my ORACLE database XML formatted records are stored e.g. for users
>> (also
>> for other types of records but these are the easy ones I want to try
>> with)
>> in CLOB fields - so the record could look like:
>
>
> <snip/>
>
> I'd use a generator instead of an action. No need to store the
> retrieved XML in a file and read it again via XSP.
I agree that temp file idea is really bad.
> You can find an example here [1]. I'll comment the relevant parts:
>
> PreparedStatement ps = ...;
> ResultSet rs = ps.executeQuery(); // execute query and retrieve the
> result set
> while (rs.next()) {
> // CONTENT is the CLOB column
> insertXML(rs.getClob("content").getCharacterStream(), parser);
> }
> ...
>
> // The insertXML method parses the CLOB column as XML and inserts
> // it as SAX events in the pipeline.
>
> private void insertXML(Reader reader, Parser parser)
> throws SAXException, IOException
> {
> InputSource is = new InputSource(reader);
> parser.parse(is, new IncludeXMLConsumer(xmlConsumer));
> }
>
> I hope this is helpful and correct.
I think this particular case asks for BlobSource (scratchpad).
Vadim
> Ugo
>
> [1]:
>
>http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/cocoblog/CocoBlog/src/java/com/beblogging/generation/RSSGenerator.java?rev=1.1&content-type=text/vnd.viewcvs-markup
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
