You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Christian Kurz <cr...@gmx.de> on 2003/07/09 13:38:57 UTC

SQLTransformer: Reading Oracle CLOBs possible?

Hello,

when retrieving rows from an Oracle table containing CLOB fields using
the SQLTranformer, the returned field value is only a reference to the
value (e.g. oracle.sql.CLOB@d83365). Is is possible to retrieve the
actual value of the field?

Thanks in advance,
Christian



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Re: SQLTransformer: Reading Oracle CLOBs possible?

Posted by Yury Mikhienko <Yu...@mobicomk.ru>.
> Hello,
> 
> when retrieving rows from an Oracle table containing CLOB fields using
> the SQLTranformer, the returned field value is only a reference to the
> value (e.g. oracle.sql.CLOB@d83365). Is is possible to retrieve the
> actual value of the field?
> 

I do not know about the SQLTranformer, but in ESQL logicsheet it possible

-- 
 
Best regards,
Yury Mikhienko.
IT engineer, ZAO "Mobicom-Kavkaz"

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Syntax and/or usage hints for psuedo protocols

Posted by Adam Flegman <ad...@yahoo.com>.
Hi guys,

I have been experiencing a little trouble using session validation. I think the
only piece I am missing is getting cocoon to locate and use the descriptor.xml
file I have created.

I guess I have a choices in getting cocoon to locate the descriptor.xml file.

I was hoping to use the file:// protocol to locate the file, but haven't been
able to find much documentation on how to create absolute and relative path
names to files. I don't even know where the file:// protocol is actually
pointing to which makes it hard to create a relative file link.

If anyone has a working sample or some URLs to references on the psuedo
protocols I would be very greatful.


Cheers,

Ad.

=====
Adam Flegman - Senior Software Engineer

Mobile:     (0414) 375 735
Phone:     (07) 5547 8530
Facsimile: (07) 5547 8532
Email #1: adam_flegman@yahoo.com 
Email #2: planemad@optusnet.com.au

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


AW: SQLTransformer: Reading Oracle CLOBs possible?

Posted by Christian Kurz <cr...@gmx.de>.
For Cocoon 2.0.4 the answer is no.

I have copied some code from the AbstractDatabaseAction.java into
SQLTransformer to handle the various datatypes. With this change the
SQLTransformer now handles CLOBs.

If anybody is interested, please let me know.

-----Ursprüngliche Nachricht-----
Von: Christian Kurz [mailto:crkurz@gmx.de] 
Gesendet: Mittwoch, 9. Juli 2003 13:39
An: users@cocoon.apache.org
Betreff: SQLTransformer: Reading Oracle CLOBs possible?

Hello,

when retrieving rows from an Oracle table containing CLOB fields using
the SQLTranformer, the returned field value is only a reference to the
value (e.g. oracle.sql.CLOB@d83365). Is is possible to retrieve the
actual value of the field?

Thanks in advance,
Christian



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org